projects
/
clearscm.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
New tunnel.pl
[clearscm.git]
/
clearadm
/
lib
/
load.sql
diff --git
a/clearadm/lib/load.sql
b/clearadm/lib/load.sql
index
f89e5c2
..
a6efa48
100644
(file)
--- a/
clearadm/lib/load.sql
+++ b/
clearadm/lib/load.sql
@@
-20,7
+20,7
@@
insert into alert (
'email'
);
'email'
);
--- Predefined notifications
+-- Predefined notifications
Tables
insert into notification (
name,
alert,
insert into notification (
name,
alert,
@@
-69,6
+69,18
@@
insert into notification (
'Once a day'
);
'Once a day'
);
+insert into notification (
+ name,
+ alert,
+ cond,
+ nomorethan
+) values (
+ 'Clearcase Storage',
+ 'Email admin',
+ 'Clearcase Failure',
+ 'Once a day'
+);
+
insert into notification (
name,
alert,
insert into notification (
name,
alert,
@@
-98,24
+110,24
@@
insert into task (
name,
system,
description,
name,
system,
description,
- command
,
+ command
) values (
'Loadavg',
) values (
'Loadavg',
- '
L
ocalhost',
+ '
l
ocalhost',
'Obtain a loadavg snapshot on all systems',
'Obtain a loadavg snapshot on all systems',
- 'updatela.pl'
,
+ 'updatela.pl'
);
insert into task (
name,
system,
description,
);
insert into task (
name,
system,
description,
- command
,
+ command
) values (
'Filesystem',
) values (
'Filesystem',
- '
L
ocalhost',
+ '
l
ocalhost',
'Obtain a filesystem snapshot on all systems/filesystems',
'Obtain a filesystem snapshot on all systems/filesystems',
- 'updatefs.pl'
,
+ 'updatefs.pl'
);
insert into task (
);
insert into task (
@@
-125,19
+137,21
@@
insert into task (
command
) values (
'Scrub',
command
) values (
'Scrub',
- '
L
ocalhost',
+ '
l
ocalhost',
'Scrub Clearadm database',
'Scrub Clearadm database',
- 'clearadmscrub.pl'
,
+ 'clearadmscrub.pl'
);
insert into task (
name,
system,
);
insert into task (
name,
system,
- description
+ description,
+ command
) values (
'System checkin',
) values (
'System checkin',
- '
L
ocalhost',
+ '
l
ocalhost',
'Checkin from all systems',
'Checkin from all systems',
+ 'default'
);
insert into task (
);
insert into task (
@@
-147,9
+161,21
@@
insert into task (
command
) values (
'Update systems',
command
) values (
'Update systems',
- '
L
ocalhost',
+ '
l
ocalhost',
'Update all systems',
'Update all systems',
- 'updatesystem.pl -host all',
+ 'updatesystem.pl -host all'
+);
+
+insert into task (
+ name,
+ system,
+ description,
+ command
+) values (
+ 'Clearcase Storage',
+ 'localhost',
+ 'Update Clearcase VOB/View storage',
+ 'updateccfs.pl'
);
-- Predefined schedule
);
-- Predefined schedule
@@
-186,5
+212,19
@@
insert into schedule (
'Scrub',
'Scrub',
'Scrub',
'Scrub',
'Scrub',
'Scrub',
- '1 day
+ '1 day'
+);
+
+insert into schedule (
+ name,
+ task,
+ notification,
+ frequency
+) values (
+ 'Clearcase Storage',
+ 'Clearcase Storage',
+ 'Clearcase Storage',
+ '1 day'
);
);
+
+