Big update of Clearadm

[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'
 );
 
--- Predefined notifications
+-- Predefined notificationsTables
 insert into notification (
   name,
   alert,
@@ -69,6 +69,18 @@ insert into notification (
   '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,
@@ -98,24 +110,24 @@ insert into task (
   name,
   system,
   description,
-  command,
+  command
 ) values (
   'Loadavg',
-  'Localhost',
+  'localhost',
   'Obtain a loadavg snapshot on all systems',
-  'updatela.pl',
+  'updatela.pl'
 );
 
 insert into task (
   name,
   system,
   description,
-  command,
+  command
 ) values (
   'Filesystem',
-  'Localhost',
+  'localhost',
   'Obtain a filesystem snapshot on all systems/filesystems',
-  'updatefs.pl',
+  'updatefs.pl'
 );
 
 insert into task (
@@ -125,19 +137,21 @@ insert into task (
   command
 ) values (
   'Scrub',
-  'Localhost',
+  'localhost',
   'Scrub Clearadm database',
-  'clearadmscrub.pl',
+  'clearadmscrub.pl'
 );
 
 insert into task (
   name,
   system,
-  description
+  description,
+  command
 ) values (
   'System checkin',
-  'Localhost',
+  'localhost',
   'Checkin from all systems',
+  'default'
 );
 
 insert into task (
@@ -147,9 +161,21 @@ insert into task (
   command
 ) values (
   'Update systems',
-  'Localhost',
+  'localhost',
   '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
@@ -186,5 +212,19 @@ insert into schedule (
   'Scrub',
   'Scrub',
   'Scrub',
-  '1 day
+  '1 day'
+);
+
+insert into schedule (
+  name,
+  task,
+  notification,
+  frequency
+) values (
+  'Clearcase Storage',
+  'Clearcase Storage',
+  'Clearcase Storage',
+  '1 day'
 );
+
+