X-Git-Url: https://defaria.com/gitweb/?a=blobdiff_plain;f=clearadm%2Flib%2Fload.sql;h=a6efa48be00295677efc3471260a150a81bddfe1;hb=a70e80a6af6e31d56b120348bc8bc23cdd6543f5;hp=f89e5c20b476fee055d543b34d408e93e0c56879;hpb=020a4a5ea2be725b155cae3a2cadc9aba3911b9b;p=clearscm.git

diff --git a/clearadm/lib/load.sql b/clearadm/lib/load.sql
index f89e5c2..a6efa48 100644
--- 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'
 );
+
+