1 -- -----------------------------------------------------------------------------
3 -- File: $RCSfile: load.sql,v $
4 -- Revision: $Revision: 1.10 $
5 -- Description: Create predefined data in the Clearadm database
6 -- Author: Andrew@ClearSCM.com
7 -- Created: Tue Nov 30 08:46:42 EST 2010
8 -- Modified: $Date: 2012/07/04 20:51:34 $
11 -- Copyright (c) 2010, ClearSCM, Inc., all rights reserved
13 -- -----------------------------------------------------------------------------
23 -- Predefined notificationsTables
24 insert into notification (
32 'Filesystem over threshold',
36 insert into notification (
48 insert into notification (
56 'Loadavg over threshold',
60 insert into notification (
72 insert into notification (
84 insert into notification (
105 'Obtain a loadavg snapshot on all systems',
117 'Obtain a filesystem snapshot on all systems/filesystems',
129 'Scrub Clearadm database',
141 'Checkin from all systems',
153 'Update all systems',
154 'updatesystem.pl -host all'
157 -- Predefined schedule
158 insert into schedule (
170 insert into schedule (
182 insert into schedule (