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 notifications
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',
140 'Checkin from all systems',
151 'Update all systems',
152 'updatesystem.pl -host all',
155 -- Predefined schedule
156 insert into schedule (
168 insert into schedule (
180 insert into schedule (