-- MySQL dump 10.11 -- -- Host: localhost Database: GWCollageDB -- ------------------------------------------------------ -- Server version 5.0.50sp1-enterprise /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `Action` -- DROP TABLE IF EXISTS `Action`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `Action` ( `ActionID` int(11) NOT NULL auto_increment, `ActionTypeID` int(11) NOT NULL, `Name` varchar(256) NOT NULL, `Description` varchar(512) default NULL, PRIMARY KEY (`ActionID`), UNIQUE KEY `Name` (`Name`), KEY `ActionTypeID` (`ActionTypeID`), KEY `idx_Action_Name` (`Name`), CONSTRAINT `Action_ibfk_1` FOREIGN KEY (`ActionTypeID`) REFERENCES `ActionType` (`ActionTypeID`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `Action` -- LOCK TABLES `Action` WRITE; /*!40000 ALTER TABLE `Action` DISABLE KEYS */; INSERT INTO `Action` VALUES (1,4,'Nagios Acknowledge','Acknowledge Nagios Log Message'),(2,1,'Accept Log Message','Update Log Message Operation Status To Accepted'),(3,1,'Close Log Message','Update Log Message Operation Status To Closed'),(4,1,'Notify Log Message','Update Log Message Operation Status To Notified'),(5,1,'Open Log Message','Update Log Message Operation Status To Open'),(6,5,'Submit Passive Check','Submit a passive check for this service'); /*!40000 ALTER TABLE `Action` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ActionParameter` -- DROP TABLE IF EXISTS `ActionParameter`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `ActionParameter` ( `ActionParameterID` int(11) NOT NULL auto_increment, `ActionID` int(11) NOT NULL, `Name` varchar(128) NOT NULL, `Value` text, PRIMARY KEY (`ActionParameterID`), UNIQUE KEY `ActionID` (`ActionID`,`Name`), CONSTRAINT `ActionParameter_ibfk_1` FOREIGN KEY (`ActionID`) REFERENCES `Action` (`ActionID`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `ActionParameter` -- LOCK TABLES `ActionParameter` WRITE; /*!40000 ALTER TABLE `ActionParameter` DISABLE KEYS */; INSERT INTO `ActionParameter` VALUES (1,6,'nsca_host','nsca_host'),(2,6,'user','user'),(3,6,'comment','comment'),(4,6,'host','host'),(5,6,'service','service'),(6,6,'state','state'); /*!40000 ALTER TABLE `ActionParameter` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ActionProperty` -- DROP TABLE IF EXISTS `ActionProperty`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `ActionProperty` ( `ActionPropertyID` int(11) NOT NULL auto_increment, `ActionID` int(11) NOT NULL, `Name` varchar(128) NOT NULL, `Value` text, PRIMARY KEY (`ActionPropertyID`), UNIQUE KEY `ActionID` (`ActionID`,`Name`), CONSTRAINT `ActionProperty_ibfk_1` FOREIGN KEY (`ActionID`) REFERENCES `Action` (`ActionID`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `ActionProperty` -- LOCK TABLES `ActionProperty` WRITE; /*!40000 ALTER TABLE `ActionProperty` DISABLE KEYS */; INSERT INTO `ActionProperty` VALUES (1,1,'NagiosCommandFile','/usr/local/groundwork/nagios/var/spool/nagios.cmd'),(2,2,'OperationStatus','ACCEPTED'),(3,3,'OperationStatus','CLOSED'),(4,4,'OperationStatus','NOTIFIED'),(5,5,'OperationStatus','OPEN'),(6,6,'Script','/usr/local/groundwork/foundation/scripts/reset_passive_check.sh'); /*!40000 ALTER TABLE `ActionProperty` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ActionType` -- DROP TABLE IF EXISTS `ActionType`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `ActionType` ( `ActionTypeID` int(11) NOT NULL auto_increment, `Name` varchar(256) NOT NULL, `ClassName` varchar(256) NOT NULL, PRIMARY KEY (`ActionTypeID`), UNIQUE KEY `Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `ActionType` -- LOCK TABLES `ActionType` WRITE; /*!40000 ALTER TABLE `ActionType` DISABLE KEYS */; INSERT INTO `ActionType` VALUES (1,'LOG_MESSAGE_OPERATION_STATUS','org.groundwork.foundation.bs.actions.UpdateOperationStatusAction'),(2,'SCRIPT_ACTION','org.groundwork.foundation.bs.actions.ShellScriptAction'),(3,'HTTP_REQUEST_ACTION','org.groundwork.foundation.bs.actions.HttpRequestAction'),(4,'NAGIOS_ACKNOWLEDGE_ACTION','org.groundwork.foundation.bs.actions.NagiosAcknowledgeAction'),(5,'PASSIVE_CHECK_ACTION','org.groundwork.foundation.bs.actions.ShellScriptAction'); /*!40000 ALTER TABLE `ActionType` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ApplicationAction` -- DROP TABLE IF EXISTS `ApplicationAction`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `ApplicationAction` ( `ApplicationTypeID` int(11) NOT NULL, `ActionID` int(11) NOT NULL, PRIMARY KEY (`ApplicationTypeID`,`ActionID`), KEY `ActionID` (`ActionID`), CONSTRAINT `ApplicationAction_ibfk_1` FOREIGN KEY (`ApplicationTypeID`) REFERENCES `ApplicationType` (`ApplicationTypeID`) ON DELETE CASCADE, CONSTRAINT `ApplicationAction_ibfk_2` FOREIGN KEY (`ActionID`) REFERENCES `Action` (`ActionID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `ApplicationAction` -- LOCK TABLES `ApplicationAction` WRITE; /*!40000 ALTER TABLE `ApplicationAction` DISABLE KEYS */; INSERT INTO `ApplicationAction` VALUES (100,1),(1,2),(1,3),(1,4),(1,5),(101,6),(102,6); /*!40000 ALTER TABLE `ApplicationAction` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ApplicationEntityProperty` -- DROP TABLE IF EXISTS `ApplicationEntityProperty`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `ApplicationEntityProperty` ( `ApplicationEntityPropertyID` int(11) NOT NULL auto_increment, `ApplicationTypeID` int(11) NOT NULL, `EntityTypeID` int(11) NOT NULL, `PropertyTypeID` int(11) NOT NULL, `SortOrder` int(11) NOT NULL default '999', PRIMARY KEY (`ApplicationEntityPropertyID`), UNIQUE KEY `ApplicationTypeID` (`ApplicationTypeID`,`EntityTypeID`,`PropertyTypeID`), KEY `EntityTypeID` (`EntityTypeID`), KEY `PropertyTypeID` (`PropertyTypeID`), CONSTRAINT `ApplicationEntityProperty_ibfk_1` FOREIGN KEY (`ApplicationTypeID`) REFERENCES `ApplicationType` (`ApplicationTypeID`), CONSTRAINT `ApplicationEntityProperty_ibfk_2` FOREIGN KEY (`EntityTypeID`) REFERENCES `EntityType` (`EntityTypeID`), CONSTRAINT `ApplicationEntityProperty_ibfk_3` FOREIGN KEY (`PropertyTypeID`) REFERENCES `PropertyType` (`PropertyTypeID`) ) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `ApplicationEntityProperty` -- LOCK TABLES `ApplicationEntityProperty` WRITE; /*!40000 ALTER TABLE `ApplicationEntityProperty` DISABLE KEYS */; INSERT INTO `ApplicationEntityProperty` VALUES (1,100,1,1,1),(2,100,1,2,4),(3,100,1,3,5),(4,100,1,4,6),(5,100,1,5,7),(6,100,1,6,8),(7,100,1,7,9),(8,100,1,8,10),(9,100,1,9,11),(10,100,1,10,12),(11,100,1,11,13),(12,100,1,12,14),(13,100,1,13,15),(14,100,1,14,16),(15,100,1,15,17),(16,100,1,16,18),(17,100,1,17,19),(18,100,1,34,20),(19,100,1,25,20),(20,100,1,26,21),(21,100,1,35,22),(22,100,1,38,23),(23,100,1,39,24),(24,100,1,40,25),(25,100,1,43,26),(26,100,1,44,27),(27,100,1,47,28),(28,100,1,48,29),(29,100,2,1,30),(30,100,2,18,31),(31,100,2,10,33),(32,100,2,19,34),(33,100,2,11,35),(34,100,2,20,37),(35,100,2,21,39),(36,100,2,22,40),(37,100,2,23,41),(38,100,2,24,42),(39,100,2,7,43),(40,100,2,8,44),(41,100,2,9,45),(42,100,2,25,46),(43,100,2,26,47),(44,100,2,12,48),(45,100,2,27,49),(46,100,2,14,50),(47,100,2,15,51),(48,100,2,16,52),(49,100,2,17,53),(50,100,2,28,54),(51,100,2,34,55),(52,100,2,40,56),(53,100,2,43,57),(54,100,2,44,58),(55,100,2,47,67),(56,100,2,48,68),(57,100,2,41,69),(58,100,2,42,70),(59,100,3,29,59),(60,100,3,30,60),(61,100,3,31,61),(62,100,3,32,62),(63,100,3,33,63),(64,100,3,36,65),(65,100,3,37,66),(66,1,4,50,1),(67,1,4,51,2),(68,1,4,52,3),(69,101,3,53,1),(70,101,3,54,2),(71,101,3,55,3),(72,101,3,56,4),(73,101,3,57,5),(74,101,3,58,6),(75,102,3,53,1),(76,102,3,31,2),(77,102,3,33,3); /*!40000 ALTER TABLE `ApplicationEntityProperty` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ApplicationType` -- DROP TABLE IF EXISTS `ApplicationType`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `ApplicationType` ( `ApplicationTypeID` int(11) NOT NULL auto_increment, `Name` varchar(128) NOT NULL, `Description` varchar(254) default NULL, `StateTransitionCriteria` varchar(512) default NULL, PRIMARY KEY (`ApplicationTypeID`), UNIQUE KEY `Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `ApplicationType` -- LOCK TABLES `ApplicationType` WRITE; /*!40000 ALTER TABLE `ApplicationType` DISABLE KEYS */; INSERT INTO `ApplicationType` VALUES (1,'SYSTEM','Properties that exist regardless of the Application being monitored','Device'),(100,'NAGIOS','System monitored by Nagios','Device;Host;ServiceDescription'),(101,'SNMPTRAP','SNMP Trap application','Device;Event_OID_numeric'),(102,'SYSLOG','SYSLOG application','Device'); /*!40000 ALTER TABLE `ApplicationType` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Category` -- DROP TABLE IF EXISTS `Category`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `Category` ( `CategoryID` int(11) NOT NULL auto_increment, `Name` varchar(254) NOT NULL, `Description` varchar(254) default NULL, `EntityTypeID` int(11) NOT NULL, PRIMARY KEY (`CategoryID`), UNIQUE KEY `Name` (`Name`), KEY `EntityTypeID_ibfk1_1` (`EntityTypeID`), CONSTRAINT `EntityTypeID_ibfk1_1` FOREIGN KEY (`EntityTypeID`) REFERENCES `EntityType` (`EntityTypeID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `Category` -- LOCK TABLES `Category` WRITE; /*!40000 ALTER TABLE `Category` DISABLE KEYS */; /*!40000 ALTER TABLE `Category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `CategoryEntity` -- DROP TABLE IF EXISTS `CategoryEntity`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `CategoryEntity` ( `CategoryEntityID` int(11) NOT NULL auto_increment, `ObjectID` int(11) NOT NULL default '0', `CategoryID` int(11) NOT NULL default '0', `EntityTypeID` int(11) NOT NULL default '0', PRIMARY KEY (`CategoryEntityID`), KEY `CategoryID` (`CategoryID`), KEY `EntityTypeID` (`EntityTypeID`), CONSTRAINT `CategoryEntity_ibfk_1` FOREIGN KEY (`CategoryID`) REFERENCES `Category` (`CategoryID`) ON DELETE CASCADE, CONSTRAINT `CategoryEntity_ibfk_2` FOREIGN KEY (`EntityTypeID`) REFERENCES `EntityType` (`EntityTypeID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `CategoryEntity` -- LOCK TABLES `CategoryEntity` WRITE; /*!40000 ALTER TABLE `CategoryEntity` DISABLE KEYS */; /*!40000 ALTER TABLE `CategoryEntity` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `CategoryHierarchy` -- DROP TABLE IF EXISTS `CategoryHierarchy`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `CategoryHierarchy` ( `CategoryID` int(11) NOT NULL default '0', `ParentID` int(11) NOT NULL default '0', PRIMARY KEY (`CategoryID`,`ParentID`), KEY `ParentID` (`ParentID`), CONSTRAINT `CategoryHierarchy_ibfk_1` FOREIGN KEY (`ParentID`) REFERENCES `Category` (`CategoryID`) ON DELETE CASCADE, CONSTRAINT `CategoryHierarchy_ibfk_2` FOREIGN KEY (`CategoryID`) REFERENCES `Category` (`CategoryID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `CategoryHierarchy` -- LOCK TABLES `CategoryHierarchy` WRITE; /*!40000 ALTER TABLE `CategoryHierarchy` DISABLE KEYS */; /*!40000 ALTER TABLE `CategoryHierarchy` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `CheckType` -- DROP TABLE IF EXISTS `CheckType`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `CheckType` ( `CheckTypeID` int(11) NOT NULL auto_increment, `Name` varchar(254) NOT NULL, `Description` varchar(254) default NULL, PRIMARY KEY (`CheckTypeID`), UNIQUE KEY `Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `CheckType` -- LOCK TABLES `CheckType` WRITE; /*!40000 ALTER TABLE `CheckType` DISABLE KEYS */; INSERT INTO `CheckType` VALUES (1,'ACTIVE','Active Check'),(2,'PASSIVE','Passive Check'); /*!40000 ALTER TABLE `CheckType` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Component` -- DROP TABLE IF EXISTS `Component`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `Component` ( `ComponentID` int(11) NOT NULL auto_increment, `Name` varchar(128) NOT NULL, `Description` varchar(254) default NULL, PRIMARY KEY (`ComponentID`), UNIQUE KEY `Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `Component` -- LOCK TABLES `Component` WRITE; /*!40000 ALTER TABLE `Component` DISABLE KEYS */; INSERT INTO `Component` VALUES (1,'SNMP','SNMP Component'),(2,'MQ','MessageQueue component'),(3,'JMSLISTENER','JMSListener component'),(4,'UNDEFINED','Undefined component'); /*!40000 ALTER TABLE `Component` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ConsolidationCriteria` -- DROP TABLE IF EXISTS `ConsolidationCriteria`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `ConsolidationCriteria` ( `ConsolidationCriteriaID` int(11) NOT NULL auto_increment, `Name` varchar(254) NOT NULL, `Criteria` varchar(512) NOT NULL, PRIMARY KEY (`ConsolidationCriteriaID`), UNIQUE KEY `Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `ConsolidationCriteria` -- LOCK TABLES `ConsolidationCriteria` WRITE; /*!40000 ALTER TABLE `ConsolidationCriteria` DISABLE KEYS */; INSERT INTO `ConsolidationCriteria` VALUES (1,'NAGIOSEVENT','Device;MonitorStatus;OperationStatus;SubComponent;ErrorType'),(2,'SYSTEM','OperationStatus;Device;MonitorStatus;ApplicationType;TextMessage'),(3,'SNMPTRAP','OperationStatus;Device;ipaddress;MonitorStatus;Event_OID_numeric;Event_Name;Category;Variable_Bindings'),(4,'SYSLOG','OperationStatus;Device;MonitorStatus;ipaddress;ErrorType;SubComponent'); /*!40000 ALTER TABLE `ConsolidationCriteria` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Device` -- DROP TABLE IF EXISTS `Device`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `Device` ( `DeviceID` int(11) NOT NULL auto_increment, `DisplayName` varchar(254) default NULL, `Identification` varchar(128) NOT NULL, `DESCRIPTION` varchar(254) default NULL, PRIMARY KEY (`DeviceID`), UNIQUE KEY `Identification` (`Identification`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `Device` -- LOCK TABLES `Device` WRITE; /*!40000 ALTER TABLE `Device` DISABLE KEYS */; INSERT INTO `Device` VALUES (1,'127.0.0.1','127.0.0.1','Device localhost'),(2,'172.28.112.55','172.28.112.55',NULL); /*!40000 ALTER TABLE `Device` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `DeviceParent` -- DROP TABLE IF EXISTS `DeviceParent`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `DeviceParent` ( `DeviceID` int(11) NOT NULL, `ParentID` int(11) NOT NULL, PRIMARY KEY (`DeviceID`,`ParentID`), KEY `ParentID` (`ParentID`), CONSTRAINT `DeviceParent_ibfk_1` FOREIGN KEY (`DeviceID`) REFERENCES `Device` (`DeviceID`) ON DELETE CASCADE, CONSTRAINT `DeviceParent_ibfk_2` FOREIGN KEY (`ParentID`) REFERENCES `Device` (`DeviceID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `DeviceParent` -- LOCK TABLES `DeviceParent` WRITE; /*!40000 ALTER TABLE `DeviceParent` DISABLE KEYS */; /*!40000 ALTER TABLE `DeviceParent` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Entity` -- DROP TABLE IF EXISTS `Entity`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `Entity` ( `EntityID` int(11) NOT NULL auto_increment, `Name` varchar(254) NOT NULL, `Description` varchar(254) NOT NULL, `Class` varchar(254) NOT NULL, `ApplicationTypeID` int(11) NOT NULL, PRIMARY KEY (`EntityID`), KEY `ApplicationTypeID_ibfk1_1` (`ApplicationTypeID`), CONSTRAINT `ApplicationTypeID_ibfk1_1` FOREIGN KEY (`ApplicationTypeID`) REFERENCES `ApplicationType` (`ApplicationTypeID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='New Entity Table to support service groups'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `Entity` -- LOCK TABLES `Entity` WRITE; /*!40000 ALTER TABLE `Entity` DISABLE KEYS */; /*!40000 ALTER TABLE `Entity` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `EntityProperty` -- DROP TABLE IF EXISTS `EntityProperty`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `EntityProperty` ( `EntityTypeID` int(11) NOT NULL, `ObjectID` int(11) NOT NULL, `PropertyTypeID` int(11) NOT NULL, `ValueString` varchar(4096) default NULL, `ValueDate` datetime default NULL, `ValueBoolean` tinyint(1) default NULL, `ValueInteger` int(11) default NULL, `ValueLong` bigint(20) default NULL, `ValueDouble` double default NULL, `LastEditedOn` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `CreatedOn` timestamp NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`EntityTypeID`,`ObjectID`,`PropertyTypeID`), KEY `PropertyTypeID` (`PropertyTypeID`), CONSTRAINT `EntityProperty_ibfk_1` FOREIGN KEY (`EntityTypeID`) REFERENCES `EntityType` (`EntityTypeID`) ON DELETE CASCADE, CONSTRAINT `EntityProperty_ibfk_2` FOREIGN KEY (`PropertyTypeID`) REFERENCES `PropertyType` (`PropertyTypeID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `EntityProperty` -- LOCK TABLES `EntityProperty` WRITE; /*!40000 ALTER TABLE `EntityProperty` DISABLE KEYS */; /*!40000 ALTER TABLE `EntityProperty` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `EntityType` -- DROP TABLE IF EXISTS `EntityType`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `EntityType` ( `EntityTypeID` int(11) NOT NULL auto_increment, `Name` varchar(128) NOT NULL, `Description` varchar(254) default NULL, `IsLogicalEntity` tinyint(1) NOT NULL default '0', `IsApplicationTypeSupported` tinyint(1) NOT NULL default '0', PRIMARY KEY (`EntityTypeID`), UNIQUE KEY `Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `EntityType` -- LOCK TABLES `EntityType` WRITE; /*!40000 ALTER TABLE `EntityType` DISABLE KEYS */; INSERT INTO `EntityType` VALUES (1,'HOST_STATUS','com.groundwork.collage.model.impl.HostStatus',0,0),(2,'SERVICE_STATUS','com.groundwork.collage.model.impl.ServiceStatus',0,0),(3,'LOG_MESSAGE','com.groundwork.collage.model.impl.LogMessage',0,0),(4,'DEVICE','com.groundwork.collage.model.impl.Device',0,0),(5,'HOST','com.groundwork.collage.model.impl.Host',0,0),(6,'HOSTGROUP','com.groundwork.collage.model.impl.HostGroup',0,0),(7,'APPLICATION_TYPE','com.groundwork.collage.model.impl.ApplicationType',0,0),(8,'CATEGORY','com.groundwork.collage.model.impl.Category',0,0),(9,'CHECK_TYPE','com.groundwork.collage.model.impl.CheckType',0,0),(10,'COMPONENT','com.groundwork.collage.model.impl.Component',0,0),(11,'MONITOR_STATUS','com.groundwork.collage.model.impl.MonitorStatus',0,0),(12,'OPERATION_STATUS','com.groundwork.collage.model.impl.OperationStatus',0,0),(13,'PRIORITY','com.groundwork.collage.model.impl.Priority',0,0),(14,'SEVERITY','com.groundwork.collage.model.impl.Severity',0,0),(15,'STATE_TYPE','com.groundwork.collage.model.impl.StateType',0,0),(16,'TYPE_RULE','com.groundwork.collage.model.impl.TypeRule',0,0),(17,'MONITOR_SERVER','com.groundwork.collage.model.impl.MonitorServer',0,0),(18,'LOG_MESSAGE_STATISTICS','com.groundwork.collage.model.impl.LogMessageStatistic',1,0),(19,'HOST_STATISTICS','com.groundwork.collage.model.impl.HostStatistic',1,0),(20,'SERVICE_STATISTICS','com.groundwork.collage.model.impl.ServiceStatistic',1,0),(21,'HOST_STATE_TRANSITIONS','com.groundwork.collage.model.impl.HostStateTransition',1,0),(22,'SERVICE_STATE_TRANSITIONS','com.groundwork.collage.model.impl.ServiceStateTransition',1,0),(23,'SERVICE_GROUP','com.groundwork.collage.model.impl.ServiceGroup',1,0); /*!40000 ALTER TABLE `EntityType` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Host` -- DROP TABLE IF EXISTS `Host`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `Host` ( `HostID` int(11) NOT NULL auto_increment, `DeviceID` int(11) NOT NULL, `HostName` varchar(254) NOT NULL, `Description` varchar(254) default NULL, `ApplicationTypeID` int(11) default NULL, PRIMARY KEY (`HostID`), UNIQUE KEY `HostName` (`HostName`), UNIQUE KEY `HostID` (`HostID`), KEY `DeviceID` (`DeviceID`), KEY `ApplicationTypeID` (`ApplicationTypeID`), CONSTRAINT `Host_ibfk_1` FOREIGN KEY (`DeviceID`) REFERENCES `Device` (`DeviceID`) ON DELETE CASCADE, CONSTRAINT `Host_ibfk_2` FOREIGN KEY (`ApplicationTypeID`) REFERENCES `ApplicationType` (`ApplicationTypeID`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `Host` -- LOCK TABLES `Host` WRITE; /*!40000 ALTER TABLE `Host` DISABLE KEYS */; INSERT INTO `Host` VALUES (1,1,'localhost','localhost',100); /*!40000 ALTER TABLE `Host` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `HostGroup` -- DROP TABLE IF EXISTS `HostGroup`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `HostGroup` ( `HostGroupID` int(11) NOT NULL auto_increment, `Name` varchar(254) NOT NULL, `Description` varchar(254) default NULL, `ApplicationTypeID` int(11) default NULL, `Alias` varchar(254) default NULL, PRIMARY KEY (`HostGroupID`), UNIQUE KEY `Name` (`Name`), KEY `ApplicationTypeID` (`ApplicationTypeID`), CONSTRAINT `HostGroup_ibfk_1` FOREIGN KEY (`ApplicationTypeID`) REFERENCES `ApplicationType` (`ApplicationTypeID`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `HostGroup` -- LOCK TABLES `HostGroup` WRITE; /*!40000 ALTER TABLE `HostGroup` DISABLE KEYS */; INSERT INTO `HostGroup` VALUES (1,'Linux Servers','HostGroup for all Linux Servers',100,'Linux Servers'); /*!40000 ALTER TABLE `HostGroup` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `HostGroupCollection` -- DROP TABLE IF EXISTS `HostGroupCollection`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `HostGroupCollection` ( `HostID` int(11) NOT NULL, `HostGroupID` int(11) NOT NULL, PRIMARY KEY (`HostID`,`HostGroupID`), KEY `HostGroupID` (`HostGroupID`), CONSTRAINT `HostGroupCollection_ibfk_1` FOREIGN KEY (`HostID`) REFERENCES `Host` (`HostID`) ON DELETE CASCADE, CONSTRAINT `HostGroupCollection_ibfk_2` FOREIGN KEY (`HostGroupID`) REFERENCES `HostGroup` (`HostGroupID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `HostGroupCollection` -- LOCK TABLES `HostGroupCollection` WRITE; /*!40000 ALTER TABLE `HostGroupCollection` DISABLE KEYS */; INSERT INTO `HostGroupCollection` VALUES (1,1); /*!40000 ALTER TABLE `HostGroupCollection` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `HostStatus` -- DROP TABLE IF EXISTS `HostStatus`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `HostStatus` ( `HostStatusID` int(11) NOT NULL, `ApplicationTypeID` int(11) NOT NULL, `MonitorStatusID` int(11) NOT NULL, `LastCheckTime` datetime default NULL, `CheckTypeID` int(11) default NULL, `StateTypeID` int(11) default NULL, `NextCheckTime` datetime default NULL, PRIMARY KEY (`HostStatusID`), KEY `MonitorStatusID` (`MonitorStatusID`), KEY `CheckTypeID` (`CheckTypeID`), KEY `StateTypeID` (`StateTypeID`), CONSTRAINT `HostStatus_ibfk_1` FOREIGN KEY (`HostStatusID`) REFERENCES `Host` (`HostID`) ON DELETE CASCADE, CONSTRAINT `HostStatus_ibfk_2` FOREIGN KEY (`MonitorStatusID`) REFERENCES `MonitorStatus` (`MonitorStatusID`) ON DELETE CASCADE, CONSTRAINT `HostStatus_ibfk_3` FOREIGN KEY (`CheckTypeID`) REFERENCES `CheckType` (`CheckTypeID`) ON DELETE CASCADE, CONSTRAINT `HostStatus_ibfk_4` FOREIGN KEY (`StateTypeID`) REFERENCES `StateType` (`StateTypeID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `HostStatus` -- LOCK TABLES `HostStatus` WRITE; /*!40000 ALTER TABLE `HostStatus` DISABLE KEYS */; INSERT INTO `HostStatus` VALUES (1,100,7,'2010-02-07 12:09:36',NULL,2,'2010-02-07 12:09:36'); /*!40000 ALTER TABLE `HostStatus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `HostStatusProperty` -- DROP TABLE IF EXISTS `HostStatusProperty`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `HostStatusProperty` ( `HostStatusID` int(11) NOT NULL, `PropertyTypeID` int(11) NOT NULL, `ValueString` varchar(32768) default NULL, `ValueDate` datetime default NULL, `ValueBoolean` tinyint(1) default NULL, `ValueInteger` int(11) default NULL, `ValueLong` bigint(20) default NULL, `ValueDouble` double default NULL, `LastEditedOn` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `CreatedOn` timestamp NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`HostStatusID`,`PropertyTypeID`), KEY `PropertyTypeID` (`PropertyTypeID`), CONSTRAINT `HostStatusProperty_ibfk_1` FOREIGN KEY (`HostStatusID`) REFERENCES `HostStatus` (`HostStatusID`) ON DELETE CASCADE, CONSTRAINT `HostStatusProperty_ibfk_2` FOREIGN KEY (`PropertyTypeID`) REFERENCES `PropertyType` (`PropertyTypeID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `HostStatusProperty` -- LOCK TABLES `HostStatusProperty` WRITE; /*!40000 ALTER TABLE `HostStatusProperty` DISABLE KEYS */; INSERT INTO `HostStatusProperty` VALUES (1,1,'OK - 127.0.0.1: rta 0.111ms, lost 0%',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(1,2,NULL,'2010-02-03 07:17:35',NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(1,3,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:39','2010-02-03 17:38:39'),(1,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(1,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(1,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(1,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(1,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(1,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(1,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(1,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(1,25,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:39','2010-02-03 17:38:39'),(1,26,NULL,NULL,NULL,NULL,NULL,8,'2010-02-03 17:38:39','2010-02-03 17:38:39'),(1,35,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:39','2010-02-03 17:38:39'),(1,39,'Linux Server #1',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:06:39','2010-02-03 20:06:39'),(1,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(1,44,NULL,NULL,NULL,NULL,10,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(1,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'); /*!40000 ALTER TABLE `HostStatusProperty` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `LogMessage` -- DROP TABLE IF EXISTS `LogMessage`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `LogMessage` ( `LogMessageID` int(11) NOT NULL auto_increment, `ApplicationTypeID` int(11) NOT NULL, `DeviceID` int(11) NOT NULL, `HostStatusID` int(11) default NULL, `ServiceStatusID` int(11) default NULL, `TextMessage` varchar(4096) NOT NULL, `MsgCount` int(11) NOT NULL default '1', `FirstInsertDate` datetime NOT NULL, `LastInsertDate` datetime NOT NULL, `ReportDate` datetime NOT NULL, `MonitorStatusID` int(11) default NULL, `SeverityID` int(11) NOT NULL, `ApplicationSeverityID` int(11) NOT NULL, `PriorityID` int(11) NOT NULL, `TypeRuleID` int(11) NOT NULL, `ComponentID` int(11) NOT NULL, `OperationStatusID` int(11) NOT NULL, `isStateChanged` tinyint(1) NOT NULL default '0', `ConsolidationHash` int(11) NOT NULL default '0', `StatelessHash` int(11) NOT NULL default '0', `StateTransitionHash` int(11) default NULL, PRIMARY KEY (`LogMessageID`), KEY `ApplicationTypeID` (`ApplicationTypeID`), KEY `DeviceID` (`DeviceID`), KEY `fk_LogMessage_ServiceStatusID` (`ServiceStatusID`), KEY `fk_LogMessage_HostStatusID` (`HostStatusID`), KEY `MonitorStatusID` (`MonitorStatusID`), KEY `SeverityID` (`SeverityID`), KEY `ApplicationSeverityID` (`ApplicationSeverityID`), KEY `PriorityID` (`PriorityID`), KEY `TypeRuleID` (`TypeRuleID`), KEY `ComponentID` (`ComponentID`), KEY `OperationStatusID` (`OperationStatusID`), KEY `idx_LogMessage_ConsolidationHash` (`ConsolidationHash`), KEY `idx_LogMessage_StatelessHash` (`StatelessHash`), KEY `idx_LogMessage_FirstInsertDate` (`FirstInsertDate`), KEY `idx_LogMessage_LastInsertDate` (`LastInsertDate`), KEY `idx_LogMessage_ReportDate` (`ReportDate`), KEY `idx_LogMessage_StateTransitionHash` (`StateTransitionHash`), CONSTRAINT `fk_LogMessage_HostStatusID` FOREIGN KEY (`HostStatusID`) REFERENCES `HostStatus` (`HostStatusID`) ON DELETE SET NULL, CONSTRAINT `fk_LogMessage_ServiceStatusID` FOREIGN KEY (`ServiceStatusID`) REFERENCES `ServiceStatus` (`ServiceStatusID`) ON DELETE SET NULL, CONSTRAINT `LogMessage_ibfk_1` FOREIGN KEY (`ApplicationTypeID`) REFERENCES `ApplicationType` (`ApplicationTypeID`), CONSTRAINT `LogMessage_ibfk_2` FOREIGN KEY (`DeviceID`) REFERENCES `Device` (`DeviceID`) ON DELETE CASCADE, CONSTRAINT `LogMessage_ibfk_3` FOREIGN KEY (`MonitorStatusID`) REFERENCES `MonitorStatus` (`MonitorStatusID`) ON DELETE CASCADE, CONSTRAINT `LogMessage_ibfk_4` FOREIGN KEY (`SeverityID`) REFERENCES `Severity` (`SeverityID`) ON DELETE CASCADE, CONSTRAINT `LogMessage_ibfk_5` FOREIGN KEY (`ApplicationSeverityID`) REFERENCES `Severity` (`SeverityID`) ON DELETE CASCADE, CONSTRAINT `LogMessage_ibfk_6` FOREIGN KEY (`PriorityID`) REFERENCES `Priority` (`PriorityID`) ON DELETE CASCADE, CONSTRAINT `LogMessage_ibfk_7` FOREIGN KEY (`TypeRuleID`) REFERENCES `TypeRule` (`TypeRuleID`) ON DELETE CASCADE, CONSTRAINT `LogMessage_ibfk_8` FOREIGN KEY (`ComponentID`) REFERENCES `Component` (`ComponentID`) ON DELETE CASCADE, CONSTRAINT `LogMessage_ibfk_9` FOREIGN KEY (`OperationStatusID`) REFERENCES `OperationStatus` (`OperationStatusID`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `LogMessage` -- LOCK TABLES `LogMessage` WRITE; /*!40000 ALTER TABLE `LogMessage` DISABLE KEYS */; INSERT INTO `LogMessage` VALUES (1,1,1,NULL,NULL,'Foundation-Nagios status check process started.',31,'2010-02-03 09:38:28','2010-02-04 11:37:15','2010-02-04 11:37:15',1,18,18,1,6,4,1,0,-383630449,-340063629,1505998205),(2,100,1,1,24,'Connection refused',1,'2010-02-03 07:28:32','2010-02-03 07:28:32','2010-02-03 09:38:38',5,17,17,1,6,4,1,1,1018707641,-1005692198,-33523121),(3,100,1,1,2,'CRITICAL - total %CPU for process java : 179.168',1,'2010-02-03 07:32:02','2010-02-03 07:32:02','2010-02-03 09:38:39',5,17,17,1,6,4,1,1,-1672380329,2141641750,-1245545245),(4,100,1,1,2,'WARNING: process java not running !',1,'2010-02-03 08:02:02','2010-02-03 08:02:02','2010-02-03 09:38:39',6,19,19,1,6,4,1,1,-1905367162,2141641750,-1245545245),(5,100,1,1,2,'CRITICAL - total %CPU for process java : 149.138',1,'2010-02-03 08:12:02','2010-02-03 08:12:02','2010-02-03 09:38:40',5,17,17,1,6,4,1,1,-1672380329,2141641750,-1245545245),(6,100,1,1,2,'OK - total %CPU for process java : 0.0',1,'2010-02-03 08:22:02','2010-02-03 08:22:02','2010-02-03 09:38:40',1,18,18,1,6,4,1,1,-1623958278,2141641750,-1245545245),(7,100,1,1,2,'CRITICAL - total %CPU for process java : 164.153',1,'2010-02-03 08:45:02','2010-02-03 08:45:02','2010-02-03 09:38:40',5,17,17,1,6,4,1,1,-1672380329,2141641750,-1245545245),(8,100,1,1,24,'TCP OK - 0.001 second response time on port 4913',1,'2010-02-03 09:40:21','2010-02-03 09:40:21','2010-02-03 09:40:24',1,18,18,1,6,4,1,0,-1775176074,-1005692198,-33523121),(9,100,1,1,2,'OK - total %CPU for process java : 27.0',1,'2010-02-03 09:43:21','2010-02-03 09:43:21','2010-02-03 09:43:24',1,18,18,1,6,4,1,0,-1623958278,2141641750,-1245545245),(10,101,2,NULL,NULL,'Link down on interface $1. Admin state: $2. Operational state: $3 ',1,'2010-02-04 10:58:28','2010-02-04 10:58:31','2010-02-04 10:58:32',1,20,20,1,6,4,1,0,237327987,-405844401,-1301433100); /*!40000 ALTER TABLE `LogMessage` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `LogMessageProperty` -- DROP TABLE IF EXISTS `LogMessageProperty`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `LogMessageProperty` ( `LogMessageID` int(11) NOT NULL, `PropertyTypeID` int(11) NOT NULL, `ValueString` varchar(4096) default NULL, `ValueDate` datetime default NULL, `ValueBoolean` tinyint(1) default NULL, `ValueInteger` int(11) default NULL, `ValueLong` bigint(20) default NULL, `ValueDouble` double default NULL, `LastEditedOn` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `CreatedOn` timestamp NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`LogMessageID`,`PropertyTypeID`), KEY `PropertyTypeID` (`PropertyTypeID`), CONSTRAINT `LogMessageProperty_ibfk_1` FOREIGN KEY (`LogMessageID`) REFERENCES `LogMessage` (`LogMessageID`) ON DELETE CASCADE, CONSTRAINT `LogMessageProperty_ibfk_2` FOREIGN KEY (`PropertyTypeID`) REFERENCES `PropertyType` (`PropertyTypeID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `LogMessageProperty` -- LOCK TABLES `LogMessageProperty` WRITE; /*!40000 ALTER TABLE `LogMessageProperty` DISABLE KEYS */; INSERT INTO `LogMessageProperty` VALUES (2,31,'localhost:tcp_gw_listener',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:39','2010-02-03 17:38:39'),(2,33,'SERVICE ALERT',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:39','2010-02-03 17:38:39'),(3,31,'localhost:local_cpu_java',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:39','2010-02-03 17:38:39'),(3,33,'SERVICE ALERT',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:39','2010-02-03 17:38:39'),(4,31,'localhost:local_cpu_java',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:39','2010-02-03 17:38:39'),(4,33,'SERVICE ALERT',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:39','2010-02-03 17:38:39'),(5,31,'localhost:local_cpu_java',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(5,33,'SERVICE ALERT',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(6,31,'localhost:local_cpu_java',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(6,33,'SERVICE ALERT',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(7,31,'localhost:local_cpu_java',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(7,33,'SERVICE ALERT',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(8,31,'localhost:tcp_gw_listener',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:40:24','2010-02-03 17:40:24'),(8,33,'SERVICE ALERT',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:40:24','2010-02-03 17:40:24'),(9,31,'localhost:local_cpu_java',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:43:24','2010-02-03 17:43:24'),(9,33,'SERVICE ALERT',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:43:24','2010-02-03 17:43:24'),(10,53,'172.28.112.55',NULL,NULL,NULL,NULL,NULL,'2010-02-04 18:58:32','2010-02-04 18:58:32'),(10,54,'.1.3.6.1.6.3.1.1.5.3',NULL,NULL,NULL,NULL,NULL,'2010-02-04 18:58:32','2010-02-04 18:58:32'),(10,55,'linkDown',NULL,NULL,NULL,NULL,NULL,'2010-02-04 18:58:32','2010-02-04 18:58:32'),(10,56,'linkDown',NULL,NULL,NULL,NULL,NULL,'2010-02-04 18:58:32','2010-02-04 18:58:32'),(10,57,'Status Events',NULL,NULL,NULL,NULL,NULL,'2010-02-04 18:58:32','2010-02-04 18:58:32'),(10,58,'',NULL,NULL,NULL,NULL,NULL,'2010-02-04 18:58:32','2010-02-04 18:58:32'); /*!40000 ALTER TABLE `LogMessageProperty` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `LogPerformanceData` -- DROP TABLE IF EXISTS `LogPerformanceData`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `LogPerformanceData` ( `LogPerformanceDataID` int(11) NOT NULL auto_increment, `ServiceStatusID` int(11) NOT NULL, `LastCheckTime` datetime NOT NULL, `Maximum` double default '0', `Minimum` double default '0', `Average` double default '0', `MeasurementPoints` int(11) default '0', `PerformanceDataLabelID` int(11) default NULL, PRIMARY KEY (`LogPerformanceDataID`), KEY `ServiceStatusID` (`ServiceStatusID`), KEY `PerformanceDataLabelID` (`PerformanceDataLabelID`), CONSTRAINT `LogPerformanceData_ibfk_1` FOREIGN KEY (`ServiceStatusID`) REFERENCES `ServiceStatus` (`ServiceStatusID`) ON DELETE CASCADE, CONSTRAINT `LogPerformanceData_ibfk_2` FOREIGN KEY (`PerformanceDataLabelID`) REFERENCES `PerformanceDataLabel` (`PerformanceDataLabelID`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=227 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `LogPerformanceData` -- LOCK TABLES `LogPerformanceData` WRITE; /*!40000 ALTER TABLE `LogPerformanceData` DISABLE KEYS */; INSERT INTO `LogPerformanceData` VALUES (1,15,'2010-02-03 23:57:32',1.8,1.5,1.79310344827586,87,10),(2,19,'2010-02-03 23:57:54',1,1,1,87,11),(3,20,'2010-02-03 23:58:18',2,2,2,87,12),(4,21,'2010-02-03 23:58:40',1,1,1,87,13),(5,22,'2010-02-03 23:59:03',2,2,2,87,14),(6,23,'2010-02-03 23:59:26',5759,5759,5759,87,15),(7,7,'2010-02-03 23:59:50',1,0,0.482758620689655,87,16),(8,24,'2010-02-03 23:50:12',0.003039,0.000126,0.000669662790697674,86,17),(9,25,'2010-02-03 23:50:36',0.016362,0.00061,0.00190077906976744,86,18),(10,25,'2010-02-03 23:50:36',1261,1261,1261,86,19),(11,26,'2010-02-03 23:50:58',0.001198,0.000131,0.000639337209302325,86,20),(12,16,'2010-02-03 23:52:36',0,0,0,86,21),(13,1,'2010-02-03 23:52:54',0,0,0,86,22),(14,10,'2010-02-03 23:52:59',27.1,23.6,26.2872093023256,86,23),(15,2,'2010-02-03 23:53:17',27,3.5,4.58720930232558,86,24),(16,17,'2010-02-03 23:53:21',24,12,18.2093023255814,86,25),(17,17,'2010-02-03 23:53:21',0,0,0,86,26),(18,17,'2010-02-03 23:53:21',8.371,2.558,3.06130232558139,86,27),(19,3,'2010-02-03 23:53:43',0.2,0,0.00581395348837209,86,28),(20,18,'2010-02-03 23:53:44',0.135,0.001,0.0240348837209302,86,29),(21,18,'2010-02-03 23:53:44',1.015,0.855,0.973883720930232,86,30),(22,18,'2010-02-03 23:53:44',0.578,0.392,0.510290697674419,86,31),(23,4,'2010-02-03 23:54:03',0,0,0,86,32),(24,5,'2010-02-03 23:54:27',0.2,0,0.00348837209302326,86,33),(25,6,'2010-02-03 23:54:49',0,0,0,86,34),(26,8,'2010-02-03 23:55:12',3297,3294,3296.37209302326,86,35),(27,9,'2010-02-03 23:55:35',0.31,0,0.0565116279069767,86,36),(28,9,'2010-02-03 23:55:35',0.61,0,0.0644186046511628,86,37),(29,9,'2010-02-03 23:55:35',0.66,0,0.0402325581395348,86,38),(30,11,'2010-02-03 23:55:58',1.3,1.2,1.21395348837209,86,39),(31,12,'2010-02-03 23:56:58',22.2,19.1,21.4697674418605,86,40),(32,13,'2010-02-03 23:56:44',3.2,2.8,3.14302325581395,86,41),(33,14,'2010-02-03 23:57:08',0,0,0,86,42),(34,24,'2010-02-04 23:51:12',0.002622,0.00012,0.000661591549295775,142,17),(35,25,'2010-02-04 23:50:36',0.080011,0.000558,0.00329683802816902,142,18),(36,25,'2010-02-04 23:50:36',1261,1261,1261,142,19),(37,26,'2010-02-04 23:50:58',0.008111,0.000129,0.000642380281690141,142,20),(38,16,'2010-02-04 23:52:39',0,0,0,144,21),(39,1,'2010-02-04 09:32:54',0,0,0,58,22),(40,10,'2010-02-04 23:52:59',63.8,23.6,27.7826388888889,144,23),(41,2,'2010-02-04 23:57:30',94.5,2.9,5.86122448979592,147,24),(42,17,'2010-02-04 23:53:21',22,11,15.3263888888889,144,25),(43,17,'2010-02-04 23:53:21',0,0,0,144,26),(44,17,'2010-02-04 23:53:21',2.835,2.394,2.56246527777778,144,27),(45,3,'2010-02-04 23:53:43',0,0,0,144,28),(46,18,'2010-02-04 23:53:44',0.31,0.001,0.0680277777777777,144,29),(47,18,'2010-02-04 23:53:44',1.002,0.694,0.952090277777778,144,30),(48,18,'2010-02-04 23:53:44',0.642,0.326,0.507881944444444,144,31),(49,4,'2010-02-04 23:54:03',0,0,0,144,32),(50,5,'2010-02-04 23:54:28',0.2,0,0.00486111111111111,144,33),(51,6,'2010-02-04 23:57:54',0,0,0,145,34),(52,8,'2010-02-04 23:58:18',3352,3297,3306.81944444444,144,35),(53,9,'2010-02-04 23:58:42',0.68,0,0.0828472222222222,144,36),(54,9,'2010-02-04 23:58:42',0.7,0,0.0746527777777777,144,37),(55,9,'2010-02-04 23:58:42',0.45,0,0.0338888888888888,144,38),(56,11,'2010-02-04 23:59:06',1.3,0.7,1.1125,144,39),(57,13,'2010-02-04 23:59:54',3.3,3.2,3.25915492957747,142,41),(58,12,'2010-02-04 23:59:30',23.3,17.8,22.0788732394366,142,40),(59,14,'2010-02-04 23:57:08',0,0,0,142,42),(60,15,'2010-02-04 23:57:32',1.8,1.5,1.79788732394367,142,10),(61,19,'2010-02-04 23:57:54',1,1,1,142,11),(62,20,'2010-02-04 23:58:18',2,2,2,142,12),(63,21,'2010-02-04 23:58:40',1,1,1,142,13),(64,22,'2010-02-04 23:59:03',2,2,2,142,14),(65,23,'2010-02-04 23:59:26',5759,5759,5759,142,15),(66,7,'2010-02-04 23:59:50',1,0,0.507042253521127,142,16),(67,25,'2010-02-05 23:50:38',0.007093,0.001411,0.00200038194444445,144,18),(68,25,'2010-02-05 23:50:38',1261,1261,1261,144,19),(69,26,'2010-02-05 23:50:58',0.001924,0.000121,0.000585958333333333,144,20),(70,24,'2010-02-05 23:51:14',0.003005,0.000113,0.0006554375,144,17),(71,16,'2010-02-05 23:52:39',0,0,0,144,21),(72,10,'2010-02-05 23:52:59',80.8,27.6,28.2208333333334,144,23),(73,17,'2010-02-05 23:53:21',13,11,11.7083333333333,144,25),(74,17,'2010-02-05 23:53:21',0,0,0,144,26),(75,17,'2010-02-05 23:53:21',2.392,2.206,2.28427777777778,144,27),(76,3,'2010-02-05 23:53:43',0,0,0,144,28),(77,18,'2010-02-05 23:53:44',0.329,0.001,0.0685833333333333,144,29),(78,18,'2010-02-05 23:53:44',1.002,0.74,0.941916666666666,144,30),(79,18,'2010-02-05 23:53:44',0.703,0.329,0.510597222222222,144,31),(80,4,'2010-02-05 23:54:03',0,0,0,144,32),(81,5,'2010-02-05 23:54:28',0,0,0,144,33),(82,14,'2010-02-05 23:57:08',0,0,0,144,42),(83,2,'2010-02-05 23:57:30',2.9,2.7,2.76249999999999,144,24),(84,15,'2010-02-05 23:57:32',1.8,1.8,1.8,144,10),(85,19,'2010-02-05 23:57:54',1,1,1,144,11),(86,6,'2010-02-05 23:57:54',0,0,0,144,34),(87,8,'2010-02-05 23:58:18',3355,3352,3352.88888888889,144,35),(88,20,'2010-02-05 23:58:20',2,2,2,144,12),(89,21,'2010-02-05 23:58:40',1,1,1,144,13),(90,9,'2010-02-05 23:58:42',1.27,0,0.0674999999999999,144,36),(91,9,'2010-02-05 23:58:42',0.31,0.01,0.0526388888888888,144,37),(92,9,'2010-02-05 23:58:42',0.1,0,0.0119444444444445,144,38),(93,22,'2010-02-05 23:59:03',2,2,2,144,14),(94,11,'2010-02-05 23:59:06',1.2,0.7,0.849305555555554,144,39),(95,23,'2010-02-05 23:59:26',5759,5759,5759,144,15),(96,12,'2010-02-05 23:59:30',22.2,22.2,22.1999999999999,144,40),(97,7,'2010-02-05 23:59:51',2,0,0.534722222222222,144,16),(98,13,'2010-02-05 23:59:55',3.3,3.3,3.30000000000001,144,41),(99,25,'2010-02-06 23:50:38',0.196613,0.001453,0.00462739583333333,144,18),(100,25,'2010-02-06 23:50:38',1261,1261,1261,144,19),(101,26,'2010-02-06 23:50:58',0.007399,0.000113,0.000517423611111111,144,20),(102,24,'2010-02-06 23:51:14',0.003103,0.000104,0.000456756944444444,144,17),(103,16,'2010-02-06 23:52:40',0,0,0,144,21),(104,10,'2010-02-06 23:53:00',28.6,27.7,27.7937500000001,144,23),(105,17,'2010-02-06 23:53:21',15,11,12.4583333333333,144,25),(106,17,'2010-02-06 23:53:21',0,0,0,144,26),(107,17,'2010-02-06 23:53:21',2.205,2.126,2.16179861111111,144,27),(108,3,'2010-02-06 23:53:43',0,0,0,144,28),(109,18,'2010-02-06 23:53:44',0.31,0.001,0.0490069444444444,144,29),(110,18,'2010-02-06 23:53:44',1.008,0.686,0.930180555555555,144,30),(111,18,'2010-02-06 23:53:44',0.624,0.302,0.476798611111111,144,31),(112,4,'2010-02-06 23:54:04',0,0,0,144,32),(113,5,'2010-02-06 23:54:28',0,0,0,144,33),(114,14,'2010-02-06 23:57:09',0,0,0,144,42),(115,2,'2010-02-06 23:57:30',2.7,2.6,2.64097222222223,144,24),(116,15,'2010-02-06 23:57:33',1.8,1.8,1.8,144,10),(117,19,'2010-02-06 23:57:55',1,1,1,144,11),(118,6,'2010-02-06 23:57:55',0,0,0,144,34),(119,8,'2010-02-06 23:58:18',3359,3355,3357.14583333333,144,35),(120,20,'2010-02-06 23:58:20',2,2,2,144,12),(121,21,'2010-02-06 23:58:40',1,1,1,144,13),(122,9,'2010-02-06 23:59:44',5.69,0,0.136620689655172,145,36),(123,9,'2010-02-06 23:59:44',1.93,0,0.0881379310344827,145,37),(124,9,'2010-02-06 23:59:44',0.78,0,0.0407586206896552,145,38),(125,22,'2010-02-06 23:59:03',2,2,2,144,14),(126,11,'2010-02-06 23:59:06',0.8,0.7,0.716666666666669,144,39),(127,23,'2010-02-06 23:59:26',5759,5759,5759,144,15),(128,12,'2010-02-06 23:59:30',22.3,22.2,22.2055555555555,144,40),(129,7,'2010-02-06 23:59:51',1,1,1,144,16),(130,13,'2010-02-06 23:59:55',3.3,3.3,3.30000000000001,144,41),(131,25,'2010-02-07 23:50:38',0.006486,0.001433,0.00192556944444444,144,18),(132,25,'2010-02-07 23:50:38',1261,1261,1261,144,19),(133,26,'2010-02-07 23:50:58',0.001244,0.000122,0.000381298611111111,144,20),(134,24,'2010-02-07 23:51:14',0.002781,0.000114,0.000446152777777778,144,17),(135,16,'2010-02-07 23:52:40',0,0,0,144,21),(136,10,'2010-02-07 23:53:02',28.4,27.8,27.9055555555556,144,23),(137,17,'2010-02-07 23:53:21',17,11,13.5833333333333,144,25),(138,17,'2010-02-07 23:53:21',0,0,0,144,26),(139,17,'2010-02-07 23:53:21',2.126,2.081,2.10184027777778,144,27),(140,3,'2010-02-07 23:53:44',0,0,0,144,28),(141,18,'2010-02-07 23:53:44',0.36,0,0.0713125,144,29),(142,18,'2010-02-07 23:53:44',1.004,0.686,0.907541666666666,144,30),(143,18,'2010-02-07 23:53:44',0.662,0.316,0.474902777777778,144,31),(144,4,'2010-02-07 23:54:05',0,0,0,144,32),(145,5,'2010-02-07 23:54:30',0,0,0,144,33),(146,14,'2010-02-07 23:57:10',0,0,0,144,42),(147,2,'2010-02-07 23:57:30',2.7,2.6,2.6625,144,24),(148,15,'2010-02-07 23:57:34',1.8,1.8,1.8,144,10),(149,19,'2010-02-07 23:57:56',1,1,1,144,11),(150,6,'2010-02-07 23:57:56',0,0,0,144,34),(151,8,'2010-02-07 23:58:18',3364,3359,3361.84722222222,144,35),(152,20,'2010-02-07 23:58:20',2,2,2,144,12),(153,21,'2010-02-07 23:58:41',1,1,1,144,13),(154,22,'2010-02-07 23:59:03',2,2,2,144,14),(155,11,'2010-02-07 23:59:07',0.8,0.7,0.729861111111111,144,39),(156,23,'2010-02-07 23:59:26',5759,5759,5759,144,15),(157,12,'2010-02-07 23:50:30',42.1,22.2,22.4777777777778,144,40),(158,9,'2010-02-07 23:59:44',0.53,0,0.065625,144,36),(159,9,'2010-02-07 23:59:44',1.64,0.01,0.0740972222222221,144,37),(160,9,'2010-02-07 23:59:44',1.24,0,0.0465972222222222,144,38),(161,7,'2010-02-07 23:59:51',1,1,1,144,16),(162,13,'2010-02-07 23:59:55',3.3,3.3,3.30000000000001,144,41),(163,12,'2010-02-08 23:50:30',23.3,22.4,22.917361111111,144,40),(164,25,'2010-02-08 23:50:38',0.003619,0.000557,0.00182552777777778,144,18),(165,25,'2010-02-08 23:50:38',1261,1261,1261,144,19),(166,26,'2010-02-08 23:50:58',0.01913,0.000105,0.0005846875,144,20),(167,24,'2010-02-08 23:51:14',0.004421,0.000109,0.000523236111111112,144,17),(168,16,'2010-02-08 23:52:40',0,0,0,144,21),(169,10,'2010-02-08 23:53:02',29.1,28,28.6340277777778,144,23),(170,17,'2010-02-08 23:53:21',22,12,16.8263888888889,144,25),(171,17,'2010-02-08 23:53:21',0,0,0,144,26),(172,17,'2010-02-08 23:53:21',2.081,2.057,2.06824305555555,144,27),(173,18,'2010-02-08 23:53:44',0.312,0.001,0.0745069444444444,144,29),(174,18,'2010-02-08 23:53:44',1.003,0.694,0.922270833333332,144,30),(175,18,'2010-02-08 23:53:44',0.667,0.322,0.474368055555556,144,31),(176,3,'2010-02-08 23:53:45',0,0,0,144,28),(177,4,'2010-02-08 23:54:05',0,0,0,144,32),(178,5,'2010-02-08 23:54:31',0,0,0,144,33),(179,14,'2010-02-08 23:57:11',0,0,0,144,42),(180,2,'2010-02-08 23:57:30',2.7,2.6,2.66527777777777,144,24),(181,15,'2010-02-08 23:57:35',1.8,1.8,1.8,144,10),(182,19,'2010-02-08 23:57:57',1,1,1,144,11),(183,6,'2010-02-08 23:57:57',0,0,0,144,34),(184,8,'2010-02-08 23:58:20',3369,3364,3366.82638888889,144,35),(185,20,'2010-02-08 23:58:20',2,2,2,144,12),(186,21,'2010-02-08 23:58:42',1,1,1,144,13),(187,22,'2010-02-08 23:59:04',2,2,2,144,14),(188,11,'2010-02-08 23:59:07',1.3,0.7,1.06875,144,39),(189,23,'2010-02-08 23:59:26',5759,5759,5759,144,15),(190,9,'2010-02-08 23:59:45',0.7,0,0.0721527777777777,144,36),(191,9,'2010-02-08 23:59:45',0.32,0,0.0602777777777778,144,37),(192,9,'2010-02-08 23:59:45',0.13,0,0.025625,144,38),(193,7,'2010-02-08 23:59:51',2,0,1.02777777777778,144,16),(194,13,'2010-02-08 23:59:55',3.3,3.3,3.30000000000001,144,41),(195,12,'2010-02-09 10:40:30',23.3,23.2,23.2015384615385,65,40),(196,25,'2010-02-09 10:40:39',0.007496,0.000893,0.00201969230769231,65,18),(197,25,'2010-02-09 10:40:39',1261,1261,1261,65,19),(198,26,'2010-02-09 10:40:59',0.001221,0.000111,0.000425123076923077,65,20),(199,24,'2010-02-09 10:41:14',0.002619,0.00011,0.000555676923076923,65,17),(200,16,'2010-02-09 10:32:40',0,0,0,64,21),(201,10,'2010-02-09 10:33:02',29.1,28.8,28.925,64,23),(202,17,'2010-02-09 10:33:22',23,13,19.203125,64,25),(203,17,'2010-02-09 10:33:22',0,0,0,64,26),(204,17,'2010-02-09 10:33:22',2.057,2.05,2.053109375,64,27),(205,18,'2010-02-09 10:33:44',0.286,0.003,0.0663125,64,29),(206,18,'2010-02-09 10:33:44',1.002,0.852,0.96309375,64,30),(207,18,'2010-02-09 10:33:44',0.64,0.471,0.57028125,64,31),(208,3,'2010-02-09 10:33:45',0,0,0,64,28),(209,4,'2010-02-09 10:34:05',0,0,0,64,32),(210,5,'2010-02-09 10:34:31',0,0,0,64,33),(211,14,'2010-02-09 10:37:11',0,0,0,64,42),(212,2,'2010-02-09 10:37:30',2.7,2.7,2.7,64,24),(213,15,'2010-02-09 10:37:35',1.8,1.8,1.8,64,10),(214,19,'2010-02-09 10:37:57',1,1,1,64,11),(215,6,'2010-02-09 10:37:57',0,0,0,64,34),(216,8,'2010-02-09 10:38:20',3372,3369,3370.515625,64,35),(217,20,'2010-02-09 10:38:20',2,2,2,64,12),(218,21,'2010-02-09 10:38:42',1,1,1,64,13),(219,22,'2010-02-09 10:39:04',2,2,2,64,14),(220,11,'2010-02-09 10:39:07',1.3,0.7,1.040625,64,39),(221,23,'2010-02-09 10:39:26',5759,5759,5759,64,15),(222,9,'2010-02-09 10:39:46',0.37,0,0.05421875,64,36),(223,9,'2010-02-09 10:39:46',0.16,0,0.05203125,64,37),(224,9,'2010-02-09 10:39:46',0.08,0,0.02296875,64,38),(225,7,'2010-02-09 10:39:51',1,0,0.03125,64,16),(226,13,'2010-02-09 10:39:55',3.3,3.3,3.3,64,41); /*!40000 ALTER TABLE `LogPerformanceData` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `MessageFilter` -- DROP TABLE IF EXISTS `MessageFilter`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `MessageFilter` ( `MessageFilterID` int(11) NOT NULL auto_increment, `Name` varchar(254) NOT NULL, `RegExpresion` varchar(512) NOT NULL, `isChangeSeverityToStatistic` tinyint(1) default '0', PRIMARY KEY (`MessageFilterID`), UNIQUE KEY `Name` (`Name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `MessageFilter` -- LOCK TABLES `MessageFilter` WRITE; /*!40000 ALTER TABLE `MessageFilter` DISABLE KEYS */; /*!40000 ALTER TABLE `MessageFilter` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `MonitorList` -- DROP TABLE IF EXISTS `MonitorList`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `MonitorList` ( `MonitorServerID` int(11) NOT NULL, `DeviceID` int(11) NOT NULL, PRIMARY KEY (`MonitorServerID`,`DeviceID`), KEY `DeviceID` (`DeviceID`), CONSTRAINT `MonitorList_ibfk_1` FOREIGN KEY (`MonitorServerID`) REFERENCES `MonitorServer` (`MonitorServerID`) ON DELETE CASCADE, CONSTRAINT `MonitorList_ibfk_2` FOREIGN KEY (`DeviceID`) REFERENCES `Device` (`DeviceID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `MonitorList` -- LOCK TABLES `MonitorList` WRITE; /*!40000 ALTER TABLE `MonitorList` DISABLE KEYS */; INSERT INTO `MonitorList` VALUES (1,1),(1,2); /*!40000 ALTER TABLE `MonitorList` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `MonitorServer` -- DROP TABLE IF EXISTS `MonitorServer`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `MonitorServer` ( `MonitorServerID` int(11) NOT NULL auto_increment, `MonitorServerName` varchar(254) NOT NULL, `IP` varchar(128) NOT NULL, `Description` varchar(254) default NULL, PRIMARY KEY (`MonitorServerID`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `MonitorServer` -- LOCK TABLES `MonitorServer` WRITE; /*!40000 ALTER TABLE `MonitorServer` DISABLE KEYS */; INSERT INTO `MonitorServer` VALUES (1,'localhost','127.0.0.1','Default Monitor Server'); /*!40000 ALTER TABLE `MonitorServer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `MonitorStatus` -- DROP TABLE IF EXISTS `MonitorStatus`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `MonitorStatus` ( `MonitorStatusID` int(11) NOT NULL auto_increment, `Name` varchar(254) NOT NULL, `Description` varchar(254) default NULL, PRIMARY KEY (`MonitorStatusID`), UNIQUE KEY `Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `MonitorStatus` -- LOCK TABLES `MonitorStatus` WRITE; /*!40000 ALTER TABLE `MonitorStatus` DISABLE KEYS */; INSERT INTO `MonitorStatus` VALUES (1,'OK','Status OK'),(2,'DOWN','Status DOWN'),(3,'UNREACHABLE','Status UNREACHABLE'),(4,'WARNING','Status WARNING'),(5,'CRITICAL','Status CRITICAL'),(6,'UNKNOWN','Status UNKNOWN'),(7,'UP','Status UP'),(8,'PENDING','Status PENDING'),(9,'MAINTENANCE','Status MAINTENANCE'),(10,'SCHEDULED DOWN','Scheduled Down'),(11,'UNSCHEDULED DOWN','UnScheduled Down'),(12,'SCHEDULED CRITICAL','Scheduled Critical'),(13,'UNSCHEDULED CRITICAL','UnScheduled Critical'),(14,'ACKNOWLEDGEMENT (WARNING)','ACKNOWLEDGEMENT (WARNING)'),(15,'ACKNOWLEDGEMENT (CRITICAL)','ACKNOWLEDGEMENT (CRITICAL)'),(16,'ACKNOWLEDGEMENT (DOWN)','ACKNOWLEDGEMENT (DOWN)'),(17,'ACKNOWLEDGEMENT (UP)','ACKNOWLEDGEMENT (UP)'),(18,'ACKNOWLEDGEMENT (OK)','ACKNOWLEDGEMENT (OK)'),(19,'ACKNOWLEDGEMENT (UNREACHABLE)','ACKNOWLEDGEMENT (UNREACHABLE)'),(20,'ACKNOWLEDGEMENT (UNKNOWN)','ACKNOWLEDGEMENT (UNKNOWN)'),(21,'ACKNOWLEDGEMENT (PENDING)','ACKNOWLEDGEMENT (PENDING)'),(22,'ACKNOWLEDGEMENT (MAINTENANCE)','ACKNOWLEDGEMENT (MAINTENANCE)'); /*!40000 ALTER TABLE `MonitorStatus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `OperationStatus` -- DROP TABLE IF EXISTS `OperationStatus`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `OperationStatus` ( `OperationStatusID` int(11) NOT NULL auto_increment, `Name` varchar(128) NOT NULL, `Description` varchar(254) default NULL, PRIMARY KEY (`OperationStatusID`), UNIQUE KEY `Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `OperationStatus` -- LOCK TABLES `OperationStatus` WRITE; /*!40000 ALTER TABLE `OperationStatus` DISABLE KEYS */; INSERT INTO `OperationStatus` VALUES (1,'OPEN','Status OPEN'),(2,'CLOSED','Status CLOSED'),(3,'NOTIFIED','Status NOTIFIED'),(4,'ACCEPTED','Status accepted'); /*!40000 ALTER TABLE `OperationStatus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `PerformanceDataLabel` -- DROP TABLE IF EXISTS `PerformanceDataLabel`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `PerformanceDataLabel` ( `PerformanceDataLabelID` int(11) NOT NULL auto_increment, `PerformanceName` varchar(254) default '', `ServiceDisplayName` varchar(128) default '', `MetricLabel` varchar(128) default '', `Unit` varchar(64) default '', PRIMARY KEY (`PerformanceDataLabelID`), UNIQUE KEY `PerformanceName` (`PerformanceName`) ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `PerformanceDataLabel` -- LOCK TABLES `PerformanceDataLabel` WRITE; /*!40000 ALTER TABLE `PerformanceDataLabel` DISABLE KEYS */; INSERT INTO `PerformanceDataLabel` VALUES (1,'Current Load_load1','Load average last minute','Load factor','load'),(2,'Current Load_load5','Load average last 5 minutes','Load factor','load'),(3,'Current Load_load15','Load average last 15 minutes','Load factor','load'),(4,'Current Users_users','Users on System','users','users'),(5,'Root Partition_/','Used space on Root partition','Percentage used','%'),(6,'icmp_ping_alive_rta','Ping round trip average','rta','ms'),(7,'icmp_ping_alive_pl','Process load','pl','%'),(8,'http_alive_time','Web Server time','time','sec'),(9,'http_alive_size','Web Server size','size','kb'),(10,'local_mem_perl_%MEM','local_mem_perl_%MEM','',''),(11,'local_process_gw_listener_number','local_process_gw_listener_number','',''),(12,'local_process_mysqld_number','local_process_mysqld_number','',''),(13,'local_process_mysqld_safe_number','local_process_mysqld_safe_number','',''),(14,'local_process_nagios_number','local_process_nagios_number','',''),(15,'local_swap_swap','local_swap_swap','',''),(16,'local_users_users','local_users_users','',''),(17,'tcp_gw_listener_time','tcp_gw_listener_time','',''),(18,'tcp_http_time','tcp_http_time','',''),(19,'tcp_http_size','tcp_http_size','',''),(20,'tcp_nsca_time','tcp_nsca_time','',''),(21,'local_mem_syslog-ng_%MEM','local_mem_syslog-ng_%MEM','',''),(22,'local_cpu_httpd_%CPU','local_cpu_httpd_%CPU','',''),(23,'local_memory_pct','local_memory_pct','',''),(24,'local_cpu_java_%CPU','local_cpu_java_%CPU','',''),(25,'local_mysql_database_threads','local_mysql_database_threads','',''),(26,'local_mysql_database_slow_queries','local_mysql_database_slow_queries','',''),(27,'local_mysql_database_queries_per_sec','local_mysql_database_queries_per_sec','',''),(28,'local_cpu_mysql_%CPU','local_cpu_mysql_%CPU','',''),(29,'local_nagios_latency_Min','local_nagios_latency_Min','',''),(30,'local_nagios_latency_Max','local_nagios_latency_Max','',''),(31,'local_nagios_latency_Avg','local_nagios_latency_Avg','',''),(32,'local_cpu_nagios_%CPU','local_cpu_nagios_%CPU','',''),(33,'local_cpu_perl_%CPU','local_cpu_perl_%CPU','',''),(34,'local_cpu_syslog-ng_%CPU','local_cpu_syslog-ng_%CPU','',''),(35,'local_disk_root_/','local_disk_root_/','',''),(36,'local_load_load1','local_load_load1','',''),(37,'local_load_load5','local_load_load5','',''),(38,'local_load_load15','local_load_load15','',''),(39,'local_mem_httpd_%MEM','local_mem_httpd_%MEM','',''),(40,'local_mem_java_%MEM','local_mem_java_%MEM','',''),(41,'local_mem_mysql_%MEM','local_mem_mysql_%MEM','',''),(42,'local_mem_nagios_%MEM','local_mem_nagios_%MEM','',''); /*!40000 ALTER TABLE `PerformanceDataLabel` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Priority` -- DROP TABLE IF EXISTS `Priority`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `Priority` ( `PriorityID` int(11) NOT NULL auto_increment, `Name` varchar(128) NOT NULL, `Description` varchar(254) default NULL, PRIMARY KEY (`PriorityID`), UNIQUE KEY `Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `Priority` -- LOCK TABLES `Priority` WRITE; /*!40000 ALTER TABLE `Priority` DISABLE KEYS */; INSERT INTO `Priority` VALUES (1,'1','Lowest Priority in a scale from 1 -10'),(2,'2','Low priority in a scale from 1 -10'),(3,'3','Low priority in a scale from 1 -10'),(4,'4','Low priority in a scale from 1 -10'),(5,'5','Medium priority in a scale from 1 -10'),(6,'6','Medium priority in a scale from 1 -10'),(7,'7','Medium-High priority in a scale from 1 -10'),(8,'8','Medium-High priority in a scale from 1 -10'),(9,'9','High priority in a scale from 1 -10'),(10,'10','Highest priority in a scale from 1 -10'); /*!40000 ALTER TABLE `Priority` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `PropertyType` -- DROP TABLE IF EXISTS `PropertyType`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `PropertyType` ( `PropertyTypeID` int(11) NOT NULL auto_increment, `Name` varchar(128) NOT NULL, `Description` varchar(254) default NULL, `isDate` tinyint(1) default '0', `isBoolean` tinyint(1) default '0', `isString` tinyint(1) default '0', `isInteger` tinyint(1) default '0', `isLong` tinyint(1) default '0', `isDouble` tinyint(1) default '0', `isVisible` tinyint(1) default '1', PRIMARY KEY (`PropertyTypeID`), UNIQUE KEY `Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `PropertyType` -- LOCK TABLES `PropertyType` WRITE; /*!40000 ALTER TABLE `PropertyType` DISABLE KEYS */; INSERT INTO `PropertyType` VALUES (1,'LastPluginOutput','Last output received',0,0,1,0,0,0,1),(2,'LastStateChange','The time of the last change of state',1,0,0,0,0,0,1),(3,'isAcknowledged','Has the current state been acknowledged?',0,1,0,0,0,0,1),(4,'TimeUp','The amount of time that the host has been UP',0,0,0,0,1,0,1),(5,'TimeDown','The amount of time that the host has been DOWN',0,0,0,0,1,0,1),(6,'TimeUnreachable','The amount of time that the host has been UNREACHABLE',0,0,0,0,1,0,1),(7,'LastNotificationTime','The time of the last notification',1,0,0,0,0,0,1),(8,'CurrentNotificationNumber','The count of notifications',0,0,0,1,0,0,1),(9,'isNotificationsEnabled','',0,1,0,0,0,0,1),(10,'isChecksEnabled','',0,1,0,0,0,0,1),(11,'isEventHandlersEnabled','',0,1,0,0,0,0,1),(12,'isFlapDetectionEnabled','',0,1,0,0,0,0,1),(13,'isHostFlapping','',0,1,0,0,0,0,1),(14,'PercentStateChange','',0,0,0,0,0,1,1),(15,'ScheduledDowntimeDepth','',0,0,0,1,0,0,1),(16,'isFailurePredictionEnabled','',0,1,0,0,0,0,1),(17,'isProcessPerformanceData','',0,1,0,0,0,0,1),(18,'RetryNumber','The number of times an attempt has been made to contact the service',0,0,0,1,0,0,1),(19,'isAcceptPassiveChecks','',0,1,0,0,0,0,1),(20,'isProblemAcknowledged','',0,1,0,0,0,0,1),(21,'TimeOK','The amount of time that the entity has had a status of OK',0,0,0,0,1,0,1),(22,'TimeUnknown','The amount of time that the entity has had a status of UNKNOWN',0,0,0,0,1,0,1),(23,'TimeWarning','The amount of time that the entity has had a status of WARNING',0,0,0,0,1,0,1),(24,'TimeCritical','The amount of time that the entity has had a status of CRITICAL',0,0,0,0,1,0,1),(25,'Latency','',0,0,0,0,0,1,1),(26,'ExecutionTime','',0,0,0,0,0,1,1),(27,'isServiceFlapping','',0,1,0,0,0,0,1),(28,'isObsessOverService','',0,1,0,0,0,0,1),(29,'ApplicationName','',0,0,1,0,0,0,1),(30,'ApplicationCode','',0,0,1,0,0,0,1),(31,'SubComponent','',0,0,1,0,0,0,1),(32,'LoggerName','',0,0,1,0,0,0,1),(33,'ErrorType','',0,0,1,0,0,0,1),(34,'30DayMovingAvg','',0,0,0,0,0,1,1),(35,'isPassiveChecksEnabled','Nagios 2.0',0,1,0,0,0,0,1),(36,'AcknowledgedBy','',0,0,1,0,0,0,1),(37,'AcknowledgeComment','',0,0,1,0,0,0,1),(38,'Parent','List of parent hosts separated by commas',0,0,1,0,0,0,1),(39,'Alias','Host Alias information',0,0,1,0,0,0,1),(40,'RRDPath','fully qualified path to RRD image',0,0,1,0,0,0,1),(41,'RRDLabel','Label for Graph',0,0,1,0,0,0,1),(42,'RRDCommand','Custom RRD command',0,0,1,0,0,0,1),(43,'CurrentAttempt','Current attempt running check',0,0,0,0,1,0,1),(44,'MaxAttempts','Max attempts configured',0,0,0,0,1,0,1),(45,'isObsessOverHost','',0,0,0,1,0,0,1),(46,'ServiceDependencies','',0,0,1,0,0,0,1),(47,'ExtendedInfo','',0,0,1,0,0,0,1),(48,'Comments','Host or Service Comments in XML format',0,0,1,0,0,0,1),(49,'CactiRRDCommand','Cacti RRD Command',0,0,1,0,0,0,1),(50,'Location','Last output received',0,0,1,0,0,0,1),(51,'ContactPerson','Last output received',0,0,1,0,0,0,1),(52,'ContactNumber','Last output received',0,0,1,0,0,0,1),(53,'ipaddress','ipdddress of snmp device',0,0,1,0,0,0,1),(54,'Event_OID_numeric','Event_OID_numeric',0,0,1,0,0,0,1),(55,'Event_OID_symbolic','Event_OID_symbolic of snmp device',0,0,1,0,0,0,1),(56,'Event_Name','Event_Name',0,0,1,0,0,0,1),(57,'Category','Category of snmp device',0,0,1,0,0,0,1),(58,'Variable_Bindings','Variable_Bindings',0,0,1,0,0,0,1); /*!40000 ALTER TABLE `PropertyType` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `SchemaInfo` -- DROP TABLE IF EXISTS `SchemaInfo`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `SchemaInfo` ( `Name` varchar(254) default NULL, `VALUE` varchar(254) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `SchemaInfo` -- LOCK TABLES `SchemaInfo` WRITE; /*!40000 ALTER TABLE `SchemaInfo` DISABLE KEYS */; INSERT INTO `SchemaInfo` VALUES ('Schema Version','3.0.2'),('Schema created','2010-02-03 07:16:19'),('AvailabilityUpdateInterval','60'),('AvailabilityDataPoints','720'); /*!40000 ALTER TABLE `SchemaInfo` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ServiceStatus` -- DROP TABLE IF EXISTS `ServiceStatus`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `ServiceStatus` ( `ServiceStatusID` int(11) NOT NULL auto_increment, `ApplicationTypeID` int(11) NOT NULL, `ServiceDescription` varchar(254) NOT NULL, `HostID` int(11) NOT NULL, `MonitorStatusID` int(11) NOT NULL, `LastCheckTime` datetime default NULL, `NextCheckTime` datetime default NULL, `LastStateChange` datetime default NULL, `LastHardStateID` int(11) NOT NULL, `StateTypeID` int(11) NOT NULL, `CheckTypeID` int(11) NOT NULL, `MetricType` varchar(254) default NULL, `Domain` varchar(254) default NULL, PRIMARY KEY (`ServiceStatusID`), UNIQUE KEY `HostID` (`HostID`,`ServiceDescription`), KEY `ApplicationTypeID` (`ApplicationTypeID`), KEY `StateTypeID` (`StateTypeID`), KEY `CheckTypeID` (`CheckTypeID`), KEY `LastHardStateID` (`LastHardStateID`), KEY `MonitorStatusID` (`MonitorStatusID`), CONSTRAINT `ServiceStatus_ibfk_1` FOREIGN KEY (`ApplicationTypeID`) REFERENCES `ApplicationType` (`ApplicationTypeID`), CONSTRAINT `ServiceStatus_ibfk_2` FOREIGN KEY (`HostID`) REFERENCES `Host` (`HostID`) ON DELETE CASCADE, CONSTRAINT `ServiceStatus_ibfk_3` FOREIGN KEY (`StateTypeID`) REFERENCES `StateType` (`StateTypeID`) ON DELETE CASCADE, CONSTRAINT `ServiceStatus_ibfk_4` FOREIGN KEY (`CheckTypeID`) REFERENCES `CheckType` (`CheckTypeID`) ON DELETE CASCADE, CONSTRAINT `ServiceStatus_ibfk_5` FOREIGN KEY (`LastHardStateID`) REFERENCES `MonitorStatus` (`MonitorStatusID`) ON DELETE CASCADE, CONSTRAINT `ServiceStatus_ibfk_6` FOREIGN KEY (`MonitorStatusID`) REFERENCES `MonitorStatus` (`MonitorStatusID`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `ServiceStatus` -- LOCK TABLES `ServiceStatus` WRITE; /*!40000 ALTER TABLE `ServiceStatus` DISABLE KEYS */; INSERT INTO `ServiceStatus` VALUES (1,100,'local_cpu_httpd',1,1,'2010-02-04 09:32:54','2010-02-04 09:42:54','2010-02-03 07:17:35',8,2,1,NULL,NULL),(2,100,'local_cpu_java',1,1,'2010-02-09 10:37:30','2010-02-09 10:47:30','2010-02-04 09:26:17',8,2,1,NULL,NULL),(3,100,'local_cpu_mysql',1,1,'2010-02-09 10:33:45','2010-02-09 10:43:45','2010-02-03 07:18:21',8,2,1,NULL,NULL),(4,100,'local_cpu_nagios',1,1,'2010-02-09 10:34:05','2010-02-09 10:44:05','2010-02-03 07:18:44',8,2,1,NULL,NULL),(5,100,'local_cpu_perl',1,1,'2010-02-09 10:34:31','2010-02-09 10:44:31','2010-02-03 07:19:07',8,2,1,NULL,NULL),(6,100,'local_cpu_syslog-ng',1,1,'2010-02-09 10:37:57','2010-02-09 10:47:57','2010-02-03 07:19:30',8,2,1,NULL,NULL),(7,100,'local_users',1,1,'2010-02-09 10:39:51','2010-02-09 10:49:51','2010-02-03 07:26:02',8,2,1,NULL,NULL),(8,100,'local_disk_root',1,1,'2010-02-09 10:38:20','2010-02-09 10:48:20','2010-02-03 07:19:53',8,2,1,NULL,NULL),(9,100,'local_load',1,1,'2010-02-09 10:39:46','2010-02-09 10:49:46','2010-02-06 19:49:44',8,2,1,NULL,NULL),(10,100,'local_memory',1,1,'2010-02-09 10:33:02','2010-02-09 10:43:02','2010-02-03 07:22:58',8,2,1,NULL,NULL),(11,100,'local_mem_httpd',1,1,'2010-02-09 10:39:07','2010-02-09 10:49:07','2010-02-03 07:20:39',8,2,1,NULL,NULL),(12,100,'local_mem_java',1,1,'2010-02-09 10:40:30','2010-02-09 10:50:30','2010-02-07 12:10:30',8,2,1,NULL,NULL),(13,100,'local_mem_mysql',1,1,'2010-02-09 10:39:55','2010-02-09 10:49:55','2010-02-03 07:21:25',8,2,1,NULL,NULL),(14,100,'local_mem_nagios',1,1,'2010-02-09 10:37:11','2010-02-09 10:47:11','2010-02-03 07:21:48',8,2,1,NULL,NULL),(15,100,'local_mem_perl',1,1,'2010-02-09 10:37:35','2010-02-09 10:47:35','2010-02-03 07:22:12',8,2,1,NULL,NULL),(16,100,'local_mem_syslog-ng',1,1,'2010-02-09 10:42:40','2010-02-09 10:52:40','2010-02-03 07:22:35',8,2,1,NULL,NULL),(17,100,'local_mysql_database',1,1,'2010-02-09 10:33:22','2010-02-09 10:43:22','2010-02-03 07:23:21',8,2,1,NULL,NULL),(18,100,'local_nagios_latency',1,1,'2010-02-09 10:33:44','2010-02-09 10:43:44','2010-02-03 07:23:44',8,2,1,NULL,NULL),(19,100,'local_process_gw_listener',1,1,'2010-02-09 10:37:57','2010-02-09 10:47:57','2010-02-03 09:15:07',8,2,1,NULL,NULL),(20,100,'local_process_mysqld',1,1,'2010-02-09 10:38:20','2010-02-09 10:48:20','2010-02-03 07:24:30',8,2,1,NULL,NULL),(21,100,'local_process_mysqld_safe',1,1,'2010-02-09 10:38:42','2010-02-09 10:48:42','2010-02-03 07:24:53',8,2,1,NULL,NULL),(22,100,'local_process_nagios',1,1,'2010-02-09 10:39:04','2010-02-09 10:49:04','2010-02-03 07:25:16',8,2,1,NULL,NULL),(23,100,'local_swap',1,1,'2010-02-09 10:39:26','2010-02-09 10:49:26','2010-02-03 07:25:39',8,2,1,NULL,NULL),(24,100,'tcp_gw_listener',1,1,'2010-02-09 10:41:14','2010-02-09 10:51:14','2010-02-04 08:51:12',8,2,1,NULL,NULL),(25,100,'tcp_http',1,1,'2010-02-09 10:40:39','2010-02-09 10:50:39','2010-02-03 07:26:48',8,2,1,NULL,NULL),(26,100,'tcp_nsca',1,1,'2010-02-09 10:40:59','2010-02-09 10:50:59','2010-02-03 07:27:12',8,2,1,NULL,NULL); /*!40000 ALTER TABLE `ServiceStatus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ServiceStatusProperty` -- DROP TABLE IF EXISTS `ServiceStatusProperty`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `ServiceStatusProperty` ( `ServiceStatusID` int(11) NOT NULL, `PropertyTypeID` int(11) NOT NULL, `ValueString` varchar(4096) default NULL, `ValueDate` datetime default NULL, `ValueBoolean` tinyint(1) default NULL, `ValueInteger` int(11) default NULL, `ValueLong` bigint(20) default NULL, `ValueDouble` double default NULL, `LastEditedOn` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `CreatedOn` timestamp NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`ServiceStatusID`,`PropertyTypeID`), KEY `PropertyTypeID` (`PropertyTypeID`), CONSTRAINT `ServiceStatusProperty_ibfk_1` FOREIGN KEY (`ServiceStatusID`) REFERENCES `ServiceStatus` (`ServiceStatusID`) ON DELETE CASCADE, CONSTRAINT `ServiceStatusProperty_ibfk_2` FOREIGN KEY (`PropertyTypeID`) REFERENCES `PropertyType` (`PropertyTypeID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `ServiceStatusProperty` -- LOCK TABLES `ServiceStatusProperty` WRITE; /*!40000 ALTER TABLE `ServiceStatusProperty` DISABLE KEYS */; INSERT INTO `ServiceStatusProperty` VALUES (1,1,'OK - total %CPU for process httpd : 0.0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(1,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(1,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(1,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(1,10,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(1,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(1,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(1,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(1,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(1,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(1,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(1,25,NULL,NULL,NULL,NULL,NULL,686,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(1,26,NULL,NULL,NULL,NULL,NULL,419,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(1,40,'/usr/local/groundwork/rrd/localhost_local_cpu_httpd.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(1,41,'CPU Utilization',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(1,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_cpu_httpd.rrd\":CPU:AVERAGE DEF:w=\"/usr/local/groundwork/rrd/localhost_local_cpu_httpd.rrd\":CPU_wn:AVERAGE DEF:c=\"/usr/local/groundwork/rrd/localhost_local_cpu_httpd.rrd\":CPU_cr:AVERAGE CDEF:cdefa=a CDEF:cdefb=a,0.99,* AREA:cdefa#7D1B7E:\"Process CPU Utilization\" GPRINT:cdefa:LAST:Current=%.2lf GPRINT:cdefa:MIN:min=%.2lf GPRINT:cdefa:AVERAGE:avg=%.2lf GPRINT:cdefa:MAX:max=\"%.2lf\\l\" AREA:cdefb#571B7E: CDEF:cdefw=w CDEF:cdefc=c CDEF:cdefm=cdefc,1.01,* LINE2:cdefw#FFFF00:\"Warning Threshold\\:\" GPRINT:cdefw:LAST:\"%.2lf\" LINE2:cdefc#FF0033:\"Critical Threshold\\:\" GPRINT:cdefc:LAST:\"%.2lf\\l\" COMMENT:\"Service\\: local_cpu_httpd\" CDEF:cdefws=a,cdefw,GT,a,0,IF AREA:cdefws#FFFF00 CDEF:cdefcs=a,cdefc,GT,a,0,IF AREA:cdefcs#FF0033 CDEF:cdefwt=a,cdefw,GT,cdefw,0,IF LINE:cdefwt#000000 CDEF:cdefct=a,cdefc,GT,cdefc,0,IF LINE:cdefct#000000 -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y --height 120 --rigid -u 100 -l 0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(1,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(1,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(1,48,'#1,02-04-2010 09:35:08,(Nagios Process),\'This service has been scheduled for flexible downtime starting between 02-04-2010 09:34:42 and 02-04-2010 11:34:42 and lasting for a period of 1 hours and 0 minutes. Notifications for the service will not be sent out during that time period.\'',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(2,1,'OK - total %CPU for process java : 2.7',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(2,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(2,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(2,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(2,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(2,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(2,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(2,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(2,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(2,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(2,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(2,25,NULL,NULL,NULL,NULL,NULL,746,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(2,26,NULL,NULL,NULL,NULL,NULL,157,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(2,40,'/usr/local/groundwork/rrd/localhost_local_cpu_java.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(2,41,'CPU Utilization',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(2,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_cpu_java.rrd\":CPU:AVERAGE DEF:w=\"/usr/local/groundwork/rrd/localhost_local_cpu_java.rrd\":CPU_wn:AVERAGE DEF:c=\"/usr/local/groundwork/rrd/localhost_local_cpu_java.rrd\":CPU_cr:AVERAGE CDEF:cdefa=a CDEF:cdefb=a,0.99,* AREA:cdefa#7D1B7E:\"Process CPU Utilization\" GPRINT:cdefa:LAST:Current=%.2lf GPRINT:cdefa:MIN:min=%.2lf GPRINT:cdefa:AVERAGE:avg=%.2lf GPRINT:cdefa:MAX:max=\"%.2lf\\l\" AREA:cdefb#571B7E: CDEF:cdefw=w CDEF:cdefc=c CDEF:cdefm=cdefc,1.01,* LINE2:cdefw#FFFF00:\"Warning Threshold\\:\" GPRINT:cdefw:LAST:\"%.2lf\" LINE2:cdefc#FF0033:\"Critical Threshold\\:\" GPRINT:cdefc:LAST:\"%.2lf\\l\" COMMENT:\"Service\\: local_cpu_java\" CDEF:cdefws=a,cdefw,GT,a,0,IF AREA:cdefws#FFFF00 CDEF:cdefcs=a,cdefc,GT,a,0,IF AREA:cdefcs#FF0033 CDEF:cdefwt=a,cdefw,GT,cdefw,0,IF LINE:cdefwt#000000 CDEF:cdefct=a,cdefc,GT,cdefc,0,IF LINE:cdefct#000000 -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y --height 120 --rigid -u 100 -l 0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(2,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(2,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(2,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(3,1,'OK - total %CPU for process mysql : 0.0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(3,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(3,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(3,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(3,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(3,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(3,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(3,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(3,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(3,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(3,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(3,25,NULL,NULL,NULL,NULL,NULL,355,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(3,26,NULL,NULL,NULL,NULL,NULL,192,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(3,40,'/usr/local/groundwork/rrd/localhost_local_cpu_mysql.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(3,41,'CPU Utilization',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(3,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_cpu_mysql.rrd\":CPU:AVERAGE DEF:w=\"/usr/local/groundwork/rrd/localhost_local_cpu_mysql.rrd\":CPU_wn:AVERAGE DEF:c=\"/usr/local/groundwork/rrd/localhost_local_cpu_mysql.rrd\":CPU_cr:AVERAGE CDEF:cdefa=a CDEF:cdefb=a,0.99,* AREA:cdefa#7D1B7E:\"Process CPU Utilization\" GPRINT:cdefa:LAST:Current=%.2lf GPRINT:cdefa:MIN:min=%.2lf GPRINT:cdefa:AVERAGE:avg=%.2lf GPRINT:cdefa:MAX:max=\"%.2lf\\l\" AREA:cdefb#571B7E: CDEF:cdefw=w CDEF:cdefc=c CDEF:cdefm=cdefc,1.01,* LINE2:cdefw#FFFF00:\"Warning Threshold\\:\" GPRINT:cdefw:LAST:\"%.2lf\" LINE2:cdefc#FF0033:\"Critical Threshold\\:\" GPRINT:cdefc:LAST:\"%.2lf\\l\" COMMENT:\"Service\\: local_cpu_mysql\" CDEF:cdefws=a,cdefw,GT,a,0,IF AREA:cdefws#FFFF00 CDEF:cdefcs=a,cdefc,GT,a,0,IF AREA:cdefcs#FF0033 CDEF:cdefwt=a,cdefw,GT,cdefw,0,IF LINE:cdefwt#000000 CDEF:cdefct=a,cdefc,GT,cdefc,0,IF LINE:cdefct#000000 -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y --height 120 --rigid -u 100 -l 0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(3,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(3,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(3,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(4,1,'OK - total %CPU for process nagios : 0.0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(4,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(4,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(4,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(4,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(4,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(4,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(4,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(4,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(4,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(4,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(4,25,NULL,NULL,NULL,NULL,NULL,381,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(4,26,NULL,NULL,NULL,NULL,NULL,182,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(4,40,'/usr/local/groundwork/rrd/localhost_local_cpu_nagios.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(4,41,'CPU Utilization',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(4,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_cpu_nagios.rrd\":CPU:AVERAGE DEF:w=\"/usr/local/groundwork/rrd/localhost_local_cpu_nagios.rrd\":CPU_wn:AVERAGE DEF:c=\"/usr/local/groundwork/rrd/localhost_local_cpu_nagios.rrd\":CPU_cr:AVERAGE CDEF:cdefa=a CDEF:cdefb=a,0.99,* AREA:cdefa#7D1B7E:\"Process CPU Utilization\" GPRINT:cdefa:LAST:Current=%.2lf GPRINT:cdefa:MIN:min=%.2lf GPRINT:cdefa:AVERAGE:avg=%.2lf GPRINT:cdefa:MAX:max=\"%.2lf\\l\" AREA:cdefb#571B7E: CDEF:cdefw=w CDEF:cdefc=c CDEF:cdefm=cdefc,1.01,* LINE2:cdefw#FFFF00:\"Warning Threshold\\:\" GPRINT:cdefw:LAST:\"%.2lf\" LINE2:cdefc#FF0033:\"Critical Threshold\\:\" GPRINT:cdefc:LAST:\"%.2lf\\l\" COMMENT:\"Service\\: local_cpu_nagios\" CDEF:cdefws=a,cdefw,GT,a,0,IF AREA:cdefws#FFFF00 CDEF:cdefcs=a,cdefc,GT,a,0,IF AREA:cdefcs#FF0033 CDEF:cdefwt=a,cdefw,GT,cdefw,0,IF LINE:cdefwt#000000 CDEF:cdefct=a,cdefc,GT,cdefc,0,IF LINE:cdefct#000000 -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y --height 120 --rigid -u 100 -l 0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(4,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(4,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(4,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(5,1,'OK - total %CPU for process perl : 0.0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(5,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(5,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(5,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(5,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(5,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(5,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(5,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(5,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(5,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(5,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(5,25,NULL,NULL,NULL,NULL,NULL,413,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(5,26,NULL,NULL,NULL,NULL,NULL,581,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(5,40,'/usr/local/groundwork/rrd/localhost_local_cpu_perl.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(5,41,'CPU Utilization',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(5,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_cpu_perl.rrd\":CPU:AVERAGE DEF:w=\"/usr/local/groundwork/rrd/localhost_local_cpu_perl.rrd\":CPU_wn:AVERAGE DEF:c=\"/usr/local/groundwork/rrd/localhost_local_cpu_perl.rrd\":CPU_cr:AVERAGE CDEF:cdefa=a CDEF:cdefb=a,0.99,* AREA:cdefa#7D1B7E:\"Process CPU Utilization\" GPRINT:cdefa:LAST:Current=%.2lf GPRINT:cdefa:MIN:min=%.2lf GPRINT:cdefa:AVERAGE:avg=%.2lf GPRINT:cdefa:MAX:max=\"%.2lf\\l\" AREA:cdefb#571B7E: CDEF:cdefw=w CDEF:cdefc=c CDEF:cdefm=cdefc,1.01,* LINE2:cdefw#FFFF00:\"Warning Threshold\\:\" GPRINT:cdefw:LAST:\"%.2lf\" LINE2:cdefc#FF0033:\"Critical Threshold\\:\" GPRINT:cdefc:LAST:\"%.2lf\\l\" COMMENT:\"Service\\: local_cpu_perl\" CDEF:cdefws=a,cdefw,GT,a,0,IF AREA:cdefws#FFFF00 CDEF:cdefcs=a,cdefc,GT,a,0,IF AREA:cdefcs#FF0033 CDEF:cdefwt=a,cdefw,GT,cdefw,0,IF LINE:cdefwt#000000 CDEF:cdefct=a,cdefc,GT,cdefc,0,IF LINE:cdefct#000000 -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y --height 120 --rigid -u 100 -l 0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(5,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(5,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(5,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(6,1,'OK - total %CPU for process syslog-ng : 0.0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(6,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(6,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(6,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(6,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(6,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(6,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(6,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(6,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(6,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(6,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(6,25,NULL,NULL,NULL,NULL,NULL,790,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(6,26,NULL,NULL,NULL,NULL,NULL,183,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(6,40,'/usr/local/groundwork/rrd/localhost_local_cpu_syslog-ng.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(6,41,'CPU Utilization',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(6,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_cpu_syslog-ng.rrd\":CPU:AVERAGE DEF:w=\"/usr/local/groundwork/rrd/localhost_local_cpu_syslog-ng.rrd\":CPU_wn:AVERAGE DEF:c=\"/usr/local/groundwork/rrd/localhost_local_cpu_syslog-ng.rrd\":CPU_cr:AVERAGE CDEF:cdefa=a CDEF:cdefb=a,0.99,* AREA:cdefa#7D1B7E:\"Process CPU Utilization\" GPRINT:cdefa:LAST:Current=%.2lf GPRINT:cdefa:MIN:min=%.2lf GPRINT:cdefa:AVERAGE:avg=%.2lf GPRINT:cdefa:MAX:max=\"%.2lf\\l\" AREA:cdefb#571B7E: CDEF:cdefw=w CDEF:cdefc=c CDEF:cdefm=cdefc,1.01,* LINE2:cdefw#FFFF00:\"Warning Threshold\\:\" GPRINT:cdefw:LAST:\"%.2lf\" LINE2:cdefc#FF0033:\"Critical Threshold\\:\" GPRINT:cdefc:LAST:\"%.2lf\\l\" COMMENT:\"Service\\: local_cpu_syslog-ng\" CDEF:cdefws=a,cdefw,GT,a,0,IF AREA:cdefws#FFFF00 CDEF:cdefcs=a,cdefc,GT,a,0,IF AREA:cdefcs#FF0033 CDEF:cdefwt=a,cdefw,GT,cdefw,0,IF LINE:cdefwt#000000 CDEF:cdefct=a,cdefc,GT,cdefc,0,IF LINE:cdefct#000000 -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y --height 120 --rigid -u 100 -l 0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(6,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(6,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(6,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(7,1,'USERS OK - 1 users currently logged in',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(7,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(7,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(7,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(7,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(7,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(7,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(7,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(7,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(7,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(7,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(7,25,NULL,NULL,NULL,NULL,NULL,12,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(7,26,NULL,NULL,NULL,NULL,NULL,10,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(7,40,'/usr/local/groundwork/rrd/localhost_local_users.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(7,41,'Current Users',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(7,42,'rrdtool graph - --imgformat=PNG --slope-mode DEF:a=/usr/local/groundwork/rrd/localhost_local_users.rrd:users:AVERAGE CDEF:cdefa=a AREA:cdefa#0033CC:\"Number of logged in users\" -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF-Y --height 120',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(7,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(7,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(7,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(8,1,'DISK OK - free space: / 6270 MB (65% inode=97%):',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(8,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(8,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(8,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(8,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(8,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(8,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(8,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(8,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(8,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(8,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(8,25,NULL,NULL,NULL,NULL,NULL,818,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(8,26,NULL,NULL,NULL,NULL,NULL,8,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(8,40,'/usr/local/groundwork/rrd/localhost_local_disk_root.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(8,41,'Disk Utilization',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(8,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_disk_root.rrd\":root:AVERAGE DEF:w=\"/usr/local/groundwork/rrd/localhost_local_disk_root.rrd\":root_wn:AVERAGE DEF:c=\"/usr/local/groundwork/rrd/localhost_local_disk_root.rrd\":root_cr:AVERAGE DEF:m=\"/usr/local/groundwork/rrd/localhost_local_disk_root.rrd\":root_mx:AVERAGE CDEF:cdefa=a,m,/,100,* CDEF:cdefb=a,0.99,* CDEF:cdefw=w CDEF:cdefc=c CDEF:cdefm=m AREA:a#C35617:\"Space Used\\: \" LINE:cdefa#FFCC00: GPRINT:a:LAST:\"%.2lf MB\\l\" LINE2:cdefw#FFFF00:\"Warning Threshold\\:\" GPRINT:cdefw:AVERAGE:\"%.2lf\" LINE2:cdefc#FF0033:\"Critical Threshold\\:\" GPRINT:cdefc:AVERAGE:\"%.2lf\\l\" GPRINT:cdefa:AVERAGE:\"Percentage Space Used\"=%.2lf GPRINT:cdefm:AVERAGE:\"Maximum Capacity\"=%.2lf CDEF:cdefws=a,cdefw,GT,a,0,IF AREA:cdefws#FFFF00 CDEF:cdefcs=a,cdefc,GT,a,0,IF AREA:cdefcs#FF0033 -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y -l 0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(8,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(8,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(8,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(9,1,'OK - load average: 0.00, 0.02, 0.00',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(9,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(9,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(9,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(9,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(9,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(9,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(9,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(9,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(9,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(9,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(9,25,NULL,NULL,NULL,NULL,NULL,1000,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(9,26,NULL,NULL,NULL,NULL,NULL,8,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(9,40,'/usr/local/groundwork/rrd/localhost_local_load.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(9,41,'Load Averages',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(9,42,'rrdtool graph - --imgformat=PNG --slope-mode DEF:a=/usr/local/groundwork/rrd/localhost_local_load.rrd:load1:AVERAGE DEF:aw=\"/usr/local/groundwork/rrd/localhost_local_load.rrd\":load1_wn:AVERAGE DEF:ac=\"/usr/local/groundwork/rrd/localhost_local_load.rrd\":load1_cr:AVERAGE DEF:b=/usr/local/groundwork/rrd/localhost_local_load.rrd:load5:AVERAGE DEF:bw=\"/usr/local/groundwork/rrd/localhost_local_load.rrd\":load5_wn:AVERAGE DEF:bc=\"/usr/local/groundwork/rrd/localhost_local_load.rrd\":load5_cr:AVERAGE DEF:c=/usr/local/groundwork/rrd/localhost_local_load.rrd:load15:AVERAGE DEF:cw=\"/usr/local/groundwork/rrd/localhost_local_load.rrd\":load15_wn:AVERAGE DEF:cc=\"/usr/local/groundwork/rrd/localhost_local_load.rrd\":load15_cr:AVERAGE CDEF:cdefa=a CDEF:cdefb=b CDEF:cdefc=c AREA:cdefa#FF6600:\"One Minute Load Average\" GPRINT:cdefa:MIN:min=%.2lf GPRINT:cdefa:AVERAGE:avg=%.2lf GPRINT:cdefa:MAX:\"max=%.2lf\\l\" LINE:aw#FFCC33:\"1 min avg Warning Threshold\" GPRINT:aw:LAST:\"%.1lf\" LINE:ac#FF0000:\"1 min avg Critical Threshold\" GPRINT:ac:LAST:\"%.1lf\\l\" LINE2:cdefb#3300FF:\"Five Minute Load Average\" GPRINT:cdefb:MIN:min=%.2lf GPRINT:cdefb:AVERAGE:avg=%.2lf GPRINT:cdefb:MAX:\"max=%.2lf\\l\" LINE:bw#6666CC:\"5 min avg Warning Threshold\" GPRINT:bw:LAST:\"%.1lf\" LINE:bc#CC0000:\"5 min avg Critical Threshold\" GPRINT:bc:LAST:\"%.1lf\\l\" LINE3:cdefc#999999:\"Fifteen Minute Load Average\" GPRINT:cdefc:MIN:min=%.2lf GPRINT:cdefc:AVERAGE:avg=%.2lf GPRINT:cdefc:MAX:\"max=%.2lf\\l\" LINE:cw#CCCC99:\"15 min avg Warning Threshold\" GPRINT:cw:LAST:\"%.1lf\" LINE:cc#990000:\"15 min avg Critical Threshold\" GPRINT:cc:LAST:\"%.1lf\\l\" -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF-Y --height 120',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(9,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(9,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(9,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(10,1,'Memory OK - 29.1% (1124536 kB) used',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(10,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(10,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(10,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(10,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(10,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(10,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(10,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(10,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(10,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(10,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(10,25,NULL,NULL,NULL,NULL,NULL,290,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(10,26,NULL,NULL,NULL,NULL,NULL,20,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(10,40,'/usr/local/groundwork/rrd/localhost_local_memory.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(10,41,'Memory Utilization',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(10,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_memory.rrd\":pct:AVERAGE DEF:w=\"/usr/local/groundwork/rrd/localhost_local_memory.rrd\":pct_wn:AVERAGE DEF:c=\"/usr/local/groundwork/rrd/localhost_local_memory.rrd\":pct_cr:AVERAGE CDEF:cdefa=a CDEF:cdefb=a,0.99,* CDEF:cdefw=w CDEF:cdefc=c CDEF:cdefm=c,1.05,* AREA:a#33FFFF AREA:cdefb#3399FF:\"Memory Utilized\\:\" GPRINT:a:LAST:\"%.2lf Percent\" GPRINT:cdefa:MIN:min=%.2lf GPRINT:cdefa:AVERAGE:avg=%.2lf GPRINT:cdefa:MAX:max=\"%.2lf\\l\" LINE2:cdefw#FFFF00:\"Warning Threshold\\:\" GPRINT:cdefw:LAST:\"%.2lf\" LINE2:cdefc#FF0033:\"Critical Threshold\\:\" GPRINT:cdefc:LAST:\"%.2lf\\l\" COMMENT:\"Service\\: local_memory\" CDEF:cdefws=a,cdefw,GT,a,0,IF AREA:cdefws#FFFF00 CDEF:cdefcs=a,cdefc,GT,a,0,IF AREA:cdefcs#FF0033 CDEF:cdefwt=a,cdefw,GT,cdefw,0,IF LINE:cdefwt#000000 CDEF:cdefct=a,cdefc,GT,cdefc,0,IF LINE:cdefct#000000 -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y -u 100 -l 0 --rigid',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(10,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(10,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(10,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(11,1,'OK - total %MEM for process httpd : 1.3',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(11,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(11,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(11,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(11,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(11,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(11,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(11,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(11,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(11,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(11,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(11,25,NULL,NULL,NULL,NULL,NULL,895,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(11,26,NULL,NULL,NULL,NULL,NULL,529,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(11,40,'/usr/local/groundwork/rrd/localhost_local_mem_httpd.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(11,41,'Memory Utilization',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(11,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_mem_httpd.rrd\":MEM:AVERAGE DEF:w=\"/usr/local/groundwork/rrd/localhost_local_mem_httpd.rrd\":MEM_wn:AVERAGE DEF:c=\"/usr/local/groundwork/rrd/localhost_local_mem_httpd.rrd\":MEM_cr:AVERAGE CDEF:cdefa=a CDEF:cdefb=a,0.99,* CDEF:cdefw=w CDEF:cdefc=c CDEF:cdefm=c,1.05,* AREA:a#33FFFF AREA:cdefb#3399FF:\"Memory Utilized\\:\" GPRINT:a:LAST:\"%.2lf Percent\" GPRINT:cdefa:MIN:min=%.2lf GPRINT:cdefa:AVERAGE:avg=%.2lf GPRINT:cdefa:MAX:max=\"%.2lf\\l\" LINE2:cdefw#FFFF00:\"Warning Threshold\\:\" GPRINT:cdefw:LAST:\"%.2lf\" LINE2:cdefc#FF0033:\"Critical Threshold\\:\" GPRINT:cdefc:LAST:\"%.2lf\\l\" COMMENT:\"Service\\: local_mem_httpd\" CDEF:cdefws=a,cdefw,GT,a,0,IF AREA:cdefws#FFFF00 CDEF:cdefcs=a,cdefc,GT,a,0,IF AREA:cdefcs#FF0033 CDEF:cdefwt=a,cdefw,GT,cdefw,0,IF LINE:cdefwt#000000 CDEF:cdefct=a,cdefc,GT,cdefc,0,IF LINE:cdefct#000000 -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y -u 100 -l 0 --rigid',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(11,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(11,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(11,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(12,1,'OK - total %MEM for process java : 23.2',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(12,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(12,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(12,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(12,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(12,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(12,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(12,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(12,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(12,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(12,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(12,25,NULL,NULL,NULL,NULL,NULL,85,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(12,26,NULL,NULL,NULL,NULL,NULL,152,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(12,40,'/usr/local/groundwork/rrd/localhost_local_mem_java.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(12,41,'Memory Utilization',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(12,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_mem_java.rrd\":MEM:AVERAGE DEF:w=\"/usr/local/groundwork/rrd/localhost_local_mem_java.rrd\":MEM_wn:AVERAGE DEF:c=\"/usr/local/groundwork/rrd/localhost_local_mem_java.rrd\":MEM_cr:AVERAGE CDEF:cdefa=a CDEF:cdefb=a,0.99,* CDEF:cdefw=w CDEF:cdefc=c CDEF:cdefm=c,1.05,* AREA:a#33FFFF AREA:cdefb#3399FF:\"Memory Utilized\\:\" GPRINT:a:LAST:\"%.2lf Percent\" GPRINT:cdefa:MIN:min=%.2lf GPRINT:cdefa:AVERAGE:avg=%.2lf GPRINT:cdefa:MAX:max=\"%.2lf\\l\" LINE2:cdefw#FFFF00:\"Warning Threshold\\:\" GPRINT:cdefw:LAST:\"%.2lf\" LINE2:cdefc#FF0033:\"Critical Threshold\\:\" GPRINT:cdefc:LAST:\"%.2lf\\l\" COMMENT:\"Service\\: local_mem_java\" CDEF:cdefws=a,cdefw,GT,a,0,IF AREA:cdefws#FFFF00 CDEF:cdefcs=a,cdefc,GT,a,0,IF AREA:cdefcs#FF0033 CDEF:cdefwt=a,cdefw,GT,cdefw,0,IF LINE:cdefwt#000000 CDEF:cdefct=a,cdefc,GT,cdefc,0,IF LINE:cdefct#000000 -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y -u 100 -l 0 --rigid',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(12,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(12,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(12,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(13,1,'OK - total %MEM for process mysql : 3.3',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(13,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(13,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(13,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(13,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(13,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(13,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(13,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(13,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(13,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(13,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(13,25,NULL,NULL,NULL,NULL,NULL,22,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(13,26,NULL,NULL,NULL,NULL,NULL,188,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(13,40,'/usr/local/groundwork/rrd/localhost_local_mem_mysql.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(13,41,'Memory Utilization',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(13,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_mem_mysql.rrd\":MEM:AVERAGE DEF:w=\"/usr/local/groundwork/rrd/localhost_local_mem_mysql.rrd\":MEM_wn:AVERAGE DEF:c=\"/usr/local/groundwork/rrd/localhost_local_mem_mysql.rrd\":MEM_cr:AVERAGE CDEF:cdefa=a CDEF:cdefb=a,0.99,* CDEF:cdefw=w CDEF:cdefc=c CDEF:cdefm=c,1.05,* AREA:a#33FFFF AREA:cdefb#3399FF:\"Memory Utilized\\:\" GPRINT:a:LAST:\"%.2lf Percent\" GPRINT:cdefa:MIN:min=%.2lf GPRINT:cdefa:AVERAGE:avg=%.2lf GPRINT:cdefa:MAX:max=\"%.2lf\\l\" LINE2:cdefw#FFFF00:\"Warning Threshold\\:\" GPRINT:cdefw:LAST:\"%.2lf\" LINE2:cdefc#FF0033:\"Critical Threshold\\:\" GPRINT:cdefc:LAST:\"%.2lf\\l\" COMMENT:\"Service\\: local_mem_mysql\" CDEF:cdefws=a,cdefw,GT,a,0,IF AREA:cdefws#FFFF00 CDEF:cdefcs=a,cdefc,GT,a,0,IF AREA:cdefcs#FF0033 CDEF:cdefwt=a,cdefw,GT,cdefw,0,IF LINE:cdefwt#000000 CDEF:cdefct=a,cdefc,GT,cdefc,0,IF LINE:cdefct#000000 -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y -u 100 -l 0 --rigid',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(13,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(13,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(13,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(14,1,'OK - total %MEM for process nagios : 0.0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(14,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(14,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(14,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(14,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(14,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(14,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(14,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(14,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(14,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(14,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(14,25,NULL,NULL,NULL,NULL,NULL,722,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(14,26,NULL,NULL,NULL,NULL,NULL,187,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(14,40,'/usr/local/groundwork/rrd/localhost_local_mem_nagios.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:36','2010-02-03 20:11:36'),(14,41,'Memory Utilization',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:36','2010-02-03 20:11:36'),(14,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_mem_nagios.rrd\":MEM:AVERAGE DEF:w=\"/usr/local/groundwork/rrd/localhost_local_mem_nagios.rrd\":MEM_wn:AVERAGE DEF:c=\"/usr/local/groundwork/rrd/localhost_local_mem_nagios.rrd\":MEM_cr:AVERAGE CDEF:cdefa=a CDEF:cdefb=a,0.99,* CDEF:cdefw=w CDEF:cdefc=c CDEF:cdefm=c,1.05,* AREA:a#33FFFF AREA:cdefb#3399FF:\"Memory Utilized\\:\" GPRINT:a:LAST:\"%.2lf Percent\" GPRINT:cdefa:MIN:min=%.2lf GPRINT:cdefa:AVERAGE:avg=%.2lf GPRINT:cdefa:MAX:max=\"%.2lf\\l\" LINE2:cdefw#FFFF00:\"Warning Threshold\\:\" GPRINT:cdefw:LAST:\"%.2lf\" LINE2:cdefc#FF0033:\"Critical Threshold\\:\" GPRINT:cdefc:LAST:\"%.2lf\\l\" COMMENT:\"Service\\: local_mem_nagios\" CDEF:cdefws=a,cdefw,GT,a,0,IF AREA:cdefws#FFFF00 CDEF:cdefcs=a,cdefc,GT,a,0,IF AREA:cdefcs#FF0033 CDEF:cdefwt=a,cdefw,GT,cdefw,0,IF LINE:cdefwt#000000 CDEF:cdefct=a,cdefc,GT,cdefc,0,IF LINE:cdefct#000000 -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y -u 100 -l 0 --rigid',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:36','2010-02-03 20:11:36'),(14,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(14,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(14,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(15,1,'OK - total %MEM for process perl : 1.8',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(15,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(15,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(15,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(15,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(15,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(15,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(15,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(15,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(15,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(15,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(15,25,NULL,NULL,NULL,NULL,NULL,754,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(15,26,NULL,NULL,NULL,NULL,NULL,548,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(15,40,'/usr/local/groundwork/rrd/localhost_local_mem_perl.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:36','2010-02-03 20:11:36'),(15,41,'Memory Utilization',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:36','2010-02-03 20:11:36'),(15,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_mem_perl.rrd\":MEM:AVERAGE DEF:w=\"/usr/local/groundwork/rrd/localhost_local_mem_perl.rrd\":MEM_wn:AVERAGE DEF:c=\"/usr/local/groundwork/rrd/localhost_local_mem_perl.rrd\":MEM_cr:AVERAGE CDEF:cdefa=a CDEF:cdefb=a,0.99,* CDEF:cdefw=w CDEF:cdefc=c CDEF:cdefm=c,1.05,* AREA:a#33FFFF AREA:cdefb#3399FF:\"Memory Utilized\\:\" GPRINT:a:LAST:\"%.2lf Percent\" GPRINT:cdefa:MIN:min=%.2lf GPRINT:cdefa:AVERAGE:avg=%.2lf GPRINT:cdefa:MAX:max=\"%.2lf\\l\" LINE2:cdefw#FFFF00:\"Warning Threshold\\:\" GPRINT:cdefw:LAST:\"%.2lf\" LINE2:cdefc#FF0033:\"Critical Threshold\\:\" GPRINT:cdefc:LAST:\"%.2lf\\l\" COMMENT:\"Service\\: local_mem_perl\" CDEF:cdefws=a,cdefw,GT,a,0,IF AREA:cdefws#FFFF00 CDEF:cdefcs=a,cdefc,GT,a,0,IF AREA:cdefcs#FF0033 CDEF:cdefwt=a,cdefw,GT,cdefw,0,IF LINE:cdefwt#000000 CDEF:cdefct=a,cdefc,GT,cdefc,0,IF LINE:cdefct#000000 -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y -u 100 -l 0 --rigid',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:36','2010-02-03 20:11:36'),(15,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(15,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(15,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(16,1,'OK - total %MEM for process syslog-ng : 0.0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(16,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(16,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(16,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(16,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(16,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(16,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(16,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(16,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(16,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(16,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(16,25,NULL,NULL,NULL,NULL,NULL,348,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(16,26,NULL,NULL,NULL,NULL,NULL,187,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(16,40,'/usr/local/groundwork/rrd/localhost_local_mem_syslog-ng.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(16,41,'Memory Utilization',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(16,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_mem_syslog-ng.rrd\":MEM:AVERAGE DEF:w=\"/usr/local/groundwork/rrd/localhost_local_mem_syslog-ng.rrd\":MEM_wn:AVERAGE DEF:c=\"/usr/local/groundwork/rrd/localhost_local_mem_syslog-ng.rrd\":MEM_cr:AVERAGE CDEF:cdefa=a CDEF:cdefb=a,0.99,* CDEF:cdefw=w CDEF:cdefc=c CDEF:cdefm=c,1.05,* AREA:a#33FFFF AREA:cdefb#3399FF:\"Memory Utilized\\:\" GPRINT:a:LAST:\"%.2lf Percent\" GPRINT:cdefa:MIN:min=%.2lf GPRINT:cdefa:AVERAGE:avg=%.2lf GPRINT:cdefa:MAX:max=\"%.2lf\\l\" LINE2:cdefw#FFFF00:\"Warning Threshold\\:\" GPRINT:cdefw:LAST:\"%.2lf\" LINE2:cdefc#FF0033:\"Critical Threshold\\:\" GPRINT:cdefc:LAST:\"%.2lf\\l\" COMMENT:\"Service\\: local_mem_syslog-ng\" CDEF:cdefws=a,cdefw,GT,a,0,IF AREA:cdefws#FFFF00 CDEF:cdefcs=a,cdefc,GT,a,0,IF AREA:cdefcs#FF0033 CDEF:cdefwt=a,cdefw,GT,cdefw,0,IF LINE:cdefwt#000000 CDEF:cdefct=a,cdefc,GT,cdefc,0,IF LINE:cdefct#000000 -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y -u 100 -l 0 --rigid',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(16,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(16,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(16,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(17,1,'Uptime: 522067 Threads: 18 Questions: 1070553 Slow queries: 0 Opens: 753 Flush tables: 1 Open tables: 191 Queries per second avg: 2.051',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(17,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(17,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(17,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(17,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(17,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(17,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(17,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(17,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(17,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(17,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(17,25,NULL,NULL,NULL,NULL,NULL,314,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(17,26,NULL,NULL,NULL,NULL,NULL,12,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(17,40,'/usr/local/groundwork/rrd/localhost_local_mysql_database.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(17,41,'MySQL Threads and Query Stats',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(17,42,'rrdtool graph - DEF:a=/usr/local/groundwork/rrd/localhost_local_mysql_database.rrd:threads:AVERAGE CDEF:cdefa=a LINE2:a#FF0033:threads GPRINT:a:MIN:min=%.2lf GPRINT:a:AVERAGE:avg=%.2lf GPRINT:a:MAX:max=\"%.2lf\\l\" DEF:b=/usr/local/groundwork/rrd/localhost_local_mysql_database.rrd:slow_queries:AVERAGE CDEF:cdefb=b LINE2:b#33CC00:slow_queries GPRINT:b:MIN:min=%.2lf GPRINT:b:AVERAGE:avg=%.2lf GPRINT:b:MAX:max=\"%.2lf\\l\" DEF:c=/usr/local/groundwork/rrd/localhost_local_mysql_database.rrd:queries_per_sec:AVERAGE CDEF:cdefc=c LINE2:c#3366FF:queries_per_sec GPRINT:c:MIN:min=%.2lf GPRINT:c:AVERAGE:avg=%.2lf GPRINT:c:MAX:max=\"%.2lf\\l\" -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y --height 120',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(17,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(17,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(17,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(18,1,'Nagios latency: Min=0.023, Max=0.991, Avg=0.606',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(18,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(18,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(18,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(18,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(18,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(18,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(18,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(18,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(18,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(18,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(18,25,NULL,NULL,NULL,NULL,NULL,352,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(18,26,NULL,NULL,NULL,NULL,NULL,32,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(18,40,'/usr/local/groundwork/rrd/localhost_local_nagios_latency.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(18,41,'Nagios Service Check Latency in Seconds',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(18,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_nagios_latency.rrd\":min:AVERAGE DEF:b=\"/usr/local/groundwork/rrd/localhost_local_nagios_latency.rrd\":max:AVERAGE DEF:c=\"/usr/local/groundwork/rrd/localhost_local_nagios_latency.rrd\":avg:AVERAGE CDEF:cdefa=a CDEF:cdefb=b CDEF:cdefc=c AREA:cdefb#66FFFF:\"Maximum Latency\\: \" GPRINT:cdefb:LAST:\"%.2lf sec\" GPRINT:cdefb:MIN:min=%.2lf GPRINT:cdefb:AVERAGE:avg=%.2lf GPRINT:cdefb:MAX:max=\"%.2lf\\l\" LINE:cdefb#999999 AREA:cdefc#006699:\"Average Latency\\: \" GPRINT:c:LAST:\"%.2lf sec\" GPRINT:cdefc:MIN:min=%.2lf GPRINT:cdefc:AVERAGE:avg=%.2lf GPRINT:cdefc:MAX:max=\"%.2lf\\l\" LINE:cdefc#999999 AREA:a#333366:\"Minimum Latency\\: \" GPRINT:a:LAST:\"%.2lf sec\" GPRINT:cdefa:MIN:min=%.2lf GPRINT:cdefa:AVERAGE:avg=%.2lf GPRINT:cdefa:MAX:max=\"%.2lf\\l\" LINE:cdefa#999999 -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y -l 0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 20:11:35','2010-02-03 20:11:35'),(18,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(18,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(18,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:42','2010-02-03 17:38:42'),(19,1,'PROCS OK: 1 process with args \'groundwork/foundation/container/lib/jboss\'',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(19,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(19,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(19,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(19,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(19,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(19,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(19,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(19,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(19,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(19,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(19,25,NULL,NULL,NULL,NULL,NULL,787,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(19,26,NULL,NULL,NULL,NULL,NULL,24,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(19,40,'/usr/local/groundwork/rrd/localhost_local_process_gw_listener.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(19,41,'Process Count',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(19,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_process_gw_listener.rrd\":number:AVERAGE CDEF:cdefa=a AREA:cdefa#0000FF:\"Number of Processes\" GPRINT:cdefa:MIN:min=%.2lf GPRINT:cdefa:AVERAGE:avg=%.2lf GPRINT:cdefa:MAX:max=%.2lf -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y --height 120 -l 0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(19,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(19,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(19,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(20,1,'PROCS OK: 2 processes with args \'mysqld\'',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(20,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(20,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(20,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(20,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(20,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(20,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(20,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(20,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(20,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(20,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(20,25,NULL,NULL,NULL,NULL,NULL,820,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(20,26,NULL,NULL,NULL,NULL,NULL,17,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(20,40,'/usr/local/groundwork/rrd/localhost_local_process_mysqld.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(20,41,'Process Count',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(20,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_process_mysqld.rrd\":number:AVERAGE CDEF:cdefa=a AREA:cdefa#0000FF:\"Number of Processes\" GPRINT:cdefa:MIN:min=%.2lf GPRINT:cdefa:AVERAGE:avg=%.2lf GPRINT:cdefa:MAX:max=%.2lf -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y --height 120 -l 0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(20,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(20,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(20,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(21,1,'PROCS OK: 1 process with args \'mysqld_safe\'',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(21,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(21,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(21,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(21,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(21,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(21,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(21,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(21,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(21,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(21,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(21,25,NULL,NULL,NULL,NULL,NULL,862,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(21,26,NULL,NULL,NULL,NULL,NULL,17,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(21,40,'/usr/local/groundwork/rrd/localhost_local_process_mysqld_safe.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(21,41,'Process Count',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(21,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_process_mysqld_safe.rrd\":number:AVERAGE CDEF:cdefa=a AREA:cdefa#0000FF:\"Number of Processes\" GPRINT:cdefa:MIN:min=%.2lf GPRINT:cdefa:AVERAGE:avg=%.2lf GPRINT:cdefa:MAX:max=%.2lf -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y --height 120 -l 0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(21,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(21,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(21,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(22,1,'NAGIOS OK: 2 processes, status log updated 13 seconds ago',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(22,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(22,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(22,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(22,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(22,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(22,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(22,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(22,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(22,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(22,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(22,25,NULL,NULL,NULL,NULL,NULL,888,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(22,26,NULL,NULL,NULL,NULL,NULL,17,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(22,40,'/usr/local/groundwork/rrd/localhost_local_process_nagios.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(22,41,'Process Count',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(22,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_process_nagios.rrd\":number:AVERAGE CDEF:cdefa=a AREA:cdefa#0000FF:\"Number of Processes\" GPRINT:cdefa:MIN:min=%.2lf GPRINT:cdefa:AVERAGE:avg=%.2lf GPRINT:cdefa:MAX:max=%.2lf -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y --height 120 -l 0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(22,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(22,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(22,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(23,1,'SWAP OK - 100% free (5759 MB out of 5759 MB)',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(23,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(23,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(23,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(23,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(23,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(23,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(23,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(23,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(23,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(23,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(23,25,NULL,NULL,NULL,NULL,NULL,967,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(23,26,NULL,NULL,NULL,NULL,NULL,8,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(23,40,'/usr/local/groundwork/rrd/localhost_local_swap.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(23,41,'Swap Utilization',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(23,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_local_swap.rrd\":swap:AVERAGE DEF:w=\"/usr/local/groundwork/rrd/localhost_local_swap.rrd\":swap_wn:AVERAGE DEF:c=\"/usr/local/groundwork/rrd/localhost_local_swap.rrd\":swap_cr:AVERAGE DEF:m=\"/usr/local/groundwork/rrd/localhost_local_swap.rrd\":swap_mx:AVERAGE CDEF:cdefa=a,m,/,100,* CDEF:cdefw=w CDEF:cdefc=c CDEF:cdefm=m AREA:a#9900FF:\"Swap Free\\: \" LINE2:a#6600FF: GPRINT:a:LAST:\"%.2lf MB\\l\" CDEF:cdefws=a,cdefw,LT,a,0,IF AREA:cdefws#FFFF00 CDEF:cdefcs=a,cdefc,LT,a,0,IF AREA:cdefcs#FF0033 LINE2:cdefw#FFFF00:\"Warning Threshold\\:\" GPRINT:cdefw:AVERAGE:\"%.2lf\" LINE2:cdefc#FF0033:\"Critical Threshold\\:\" GPRINT:cdefc:AVERAGE:\"%.2lf\\l\" GPRINT:cdefa:AVERAGE:\"Percentage Swap Free\"=%.2lf GPRINT:cdefm:AVERAGE:\"Total Swap Space=%.2lf\" -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y -l 0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(23,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(23,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(23,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(24,1,'TCP OK - 0.000 second response time on port 4913',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(24,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(24,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(24,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(24,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(24,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(24,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(24,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(24,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(24,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(24,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(24,25,NULL,NULL,NULL,NULL,NULL,163,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(24,26,NULL,NULL,NULL,NULL,NULL,11,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(24,40,'/usr/local/groundwork/rrd/localhost_tcp_gw_listener.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(24,41,'Foundation Listener Response Time',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(24,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_tcp_gw_listener.rrd\":time:AVERAGE DEF:w=\"/usr/local/groundwork/rrd/localhost_tcp_gw_listener.rrd\":time_wn:AVERAGE DEF:c=\"/usr/local/groundwork/rrd/localhost_tcp_gw_listener.rrd\":time_cr:AVERAGE CDEF:cdefa=a CDEF:cdefb=a,0.99,* CDEF:cdefw=w CDEF:cdefc=c AREA:a#33FFFF AREA:cdefb#00CF00:\"Response Time\\:\" GPRINT:a:LAST:\"%.4lf Seconds\" GPRINT:a:MIN:min=%.2lf GPRINT:a:AVERAGE:avg=%.2lf GPRINT:a:MAX:max=\"%.2lf\\l\" LINE2:cdefw#FFFF00:\"Warning Threshold\\:\" GPRINT:cdefw:LAST:\"%.2lf\" LINE2:cdefc#FF0033:\"Critical Threshold\\:\" GPRINT:cdefc:LAST:\"%.2lf\\l\" COMMENT:\"Host\\: localhost\\l\" COMMENT:\"Service\\: tcp_gw_listener\" CDEF:cdefws=a,cdefw,GT,a,0,IF AREA:cdefws#FFFF00 CDEF:cdefcs=a,cdefc,GT,a,0,IF AREA:cdefcs#FF0033 -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y -l 0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(24,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(24,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(24,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(25,1,'HTTP OK HTTP/1.1 200 OK - 1261 bytes in 0.001 seconds',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(25,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(25,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(25,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(25,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(25,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(25,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(25,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(25,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(25,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(25,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(25,25,NULL,NULL,NULL,NULL,NULL,98,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(25,26,NULL,NULL,NULL,NULL,NULL,12,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(25,40,'/usr/local/groundwork/rrd/localhost_tcp_http.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(25,41,'HTTP Response Time',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(25,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_tcp_http.rrd\":time:AVERAGE DEF:w=\"/usr/local/groundwork/rrd/localhost_tcp_http.rrd\":time_wn:AVERAGE DEF:c=\"/usr/local/groundwork/rrd/localhost_tcp_http.rrd\":time_cr:AVERAGE CDEF:cdefa=a CDEF:cdefb=a,0.99,* CDEF:cdefw=w CDEF:cdefc=c AREA:a#33FFFF AREA:cdefb#00CF00:\"Response Time\\:\" GPRINT:a:LAST:\"%.4lf Seconds\" GPRINT:a:MIN:min=%.2lf GPRINT:a:AVERAGE:avg=%.2lf GPRINT:a:MAX:max=\"%.2lf\\l\" LINE2:cdefw#FFFF00:\"Warning Threshold\\:\" GPRINT:cdefw:LAST:\"%.2lf\" LINE2:cdefc#FF0033:\"Critical Threshold\\:\" GPRINT:cdefc:LAST:\"%.2lf\\l\" COMMENT:\"Host\\: localhost\\l\" COMMENT:\"Service\\: tcp_http\" CDEF:cdefws=a,cdefw,GT,a,0,IF AREA:cdefws#FFFF00 CDEF:cdefcs=a,cdefc,GT,a,0,IF AREA:cdefcs#FF0033 -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y -l 0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(25,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(25,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(25,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:40','2010-02-03 17:38:40'),(26,1,'TCP OK - 0.001 second response time on port 5667',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(26,7,NULL,NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(26,8,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(26,9,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(26,10,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(26,11,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(26,12,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(26,14,NULL,NULL,NULL,NULL,NULL,0,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(26,15,NULL,NULL,NULL,0,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(26,19,NULL,NULL,1,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(26,20,NULL,NULL,0,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(26,25,NULL,NULL,NULL,NULL,NULL,136,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(26,26,NULL,NULL,NULL,NULL,NULL,10,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(26,40,'/usr/local/groundwork/rrd/localhost_tcp_nsca.rrd',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(26,41,'NSCA Response Time',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(26,42,'rrdtool graph - DEF:a=\"/usr/local/groundwork/rrd/localhost_tcp_nsca.rrd\":time:AVERAGE DEF:w=\"/usr/local/groundwork/rrd/localhost_tcp_nsca.rrd\":time_wn:AVERAGE DEF:c=\"/usr/local/groundwork/rrd/localhost_tcp_nsca.rrd\":time_cr:AVERAGE CDEF:cdefa=a CDEF:cdefb=a,0.99,* CDEF:cdefw=w CDEF:cdefc=c AREA:a#33FFFF AREA:cdefb#00CF00:\"Response Time\\:\" GPRINT:a:LAST:\"%.4lf Seconds\" GPRINT:a:MIN:min=%.4lf GPRINT:a:AVERAGE:avg=%.4lf GPRINT:a:MAX:max=\"%.4lf\\l\" LINE2:cdefw#FFFF00:\"Warning Threshold\\:\" GPRINT:cdefw:LAST:\"%.2lf\" LINE2:cdefc#FF0033:\"Critical Threshold\\:\" GPRINT:cdefc:LAST:\"%.2lf\\l\" COMMENT:\"Host\\: localhost\\l\" COMMENT:\"Service\\: tcp_nsca\" CDEF:cdefws=a,cdefw,GT,a,0,IF AREA:cdefws#FFFF00 CDEF:cdefcs=a,cdefc,GT,a,0,IF AREA:cdefcs#FF0033 -c BACK#FFFFFF -c CANVAS#FFFFFF -c GRID#C0C0C0 -c MGRID#404040 -c ARROW#FFFFFF -Y -l 0',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:42:36','2010-02-03 17:42:36'),(26,43,NULL,NULL,NULL,NULL,1,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(26,44,NULL,NULL,NULL,NULL,3,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'),(26,48,' ',NULL,NULL,NULL,NULL,NULL,'2010-02-03 17:38:41','2010-02-03 17:38:41'); /*!40000 ALTER TABLE `ServiceStatusProperty` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Severity` -- DROP TABLE IF EXISTS `Severity`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `Severity` ( `SeverityID` int(11) NOT NULL auto_increment, `Name` varchar(128) NOT NULL, `Description` varchar(254) default NULL, PRIMARY KEY (`SeverityID`), UNIQUE KEY `Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `Severity` -- LOCK TABLES `Severity` WRITE; /*!40000 ALTER TABLE `Severity` DISABLE KEYS */; INSERT INTO `Severity` VALUES (1,'ACKNOWLEDGEMENT (WARNING)','ACKNOWLEDGEMENT (WARNING)'),(2,'ACKNOWLEDGEMENT (CRITICAL)','ACKNOWLEDGEMENT (CRITICAL)'),(3,'ACKNOWLEDGEMENT (DOWN)','ACKNOWLEDGEMENT (DOWN)'),(4,'ACKNOWLEDGEMENT (UP)','ACKNOWLEDGEMENT (UP)'),(5,'ACKNOWLEDGEMENT (OK)','ACKNOWLEDGEMENT (OK)'),(6,'ACKNOWLEDGEMENT (UNREACHABLE)','ACKNOWLEDGEMENT (UNREACHABLE)'),(7,'ACKNOWLEDGEMENT (UNKNOWN)','ACKNOWLEDGEMENT (UNKNOWN)'),(8,'ACKNOWLEDGEMENT (PENDING)','ACKNOWLEDGEMENT (PENDING)'),(9,'ACKNOWLEDGEMENT (MAINTENANCE)','ACKNOWLEDGEMENT (MAINTENANCE)'),(10,'FATAL','Severity FATAL'),(11,'HIGH','Severity HIGH'),(12,'LOW','Severity LOW'),(13,'WARNING','Severity WARNING'),(14,'PERFORMANCE','Severity PERFORMANCE'),(15,'STATISTIC','Severity STATISTIC'),(16,'SERIOUS','Severity SERIOUS'),(17,'CRITICAL','GroundWork Severity CRITICAL. Also MIB standard'),(18,'OK','GroundWork Severity OK'),(19,'UNKNOWN','GroundWork Severity UNKNOWN'),(20,'NORMAL','Standard MIB type for Severity'),(21,'MAJOR','Standard MIB type for MonitorStatus'),(22,'MINOR','Standard MIB type for MonitorStatus'),(23,'INFORMATIONAL','Standard MIB type'),(24,'UP','Severity UP'),(25,'DOWN','Severity DOWN'),(26,'UNREACHABLE','Severity unreachable'); /*!40000 ALTER TABLE `Severity` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `StateType` -- DROP TABLE IF EXISTS `StateType`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `StateType` ( `StateTypeID` int(11) NOT NULL auto_increment, `Name` varchar(254) NOT NULL, `Description` varchar(254) default NULL, PRIMARY KEY (`StateTypeID`), UNIQUE KEY `Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `StateType` -- LOCK TABLES `StateType` WRITE; /*!40000 ALTER TABLE `StateType` DISABLE KEYS */; INSERT INTO `StateType` VALUES (1,'SOFT','State Soft'),(2,'HARD','State Hard'),(3,'UNKNOWN','State UNKNOWN'); /*!40000 ALTER TABLE `StateType` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `TypeRule` -- DROP TABLE IF EXISTS `TypeRule`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `TypeRule` ( `TypeRuleID` int(11) NOT NULL auto_increment, `Name` varchar(128) NOT NULL, `Description` varchar(254) default NULL, PRIMARY KEY (`TypeRuleID`), UNIQUE KEY `Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `TypeRule` -- LOCK TABLES `TypeRule` WRITE; /*!40000 ALTER TABLE `TypeRule` DISABLE KEYS */; INSERT INTO `TypeRule` VALUES (1,'NETWORK','Network'),(2,'HARDWARE','Hardware'),(3,'SERVICE','Service'),(4,'APPLICATION','Application'),(5,'FILTERED','Message filtered by GroundWork-Bridge'),(6,'UNDEFINED','Undefined type'),(7,'NAGIOS_LOG','NAGIOS_LOG type'),(8,'ACKNOWLEDGE','ACKNOWLEDGE type'),(9,'UNACKNOWLEDGE','UNACKNOWLEDGE type'); /*!40000 ALTER TABLE `TypeRule` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `network_service_notifications` -- DROP TABLE IF EXISTS `network_service_notifications`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `network_service_notifications` ( `id` int(11) NOT NULL auto_increment, `created_at` timestamp NOT NULL default CURRENT_TIMESTAMP, `guid` int(11) default NULL, `type` varchar(20) default NULL, `title` varchar(255) default NULL, `critical` int(11) default NULL, `description` text, `webpage_url` text, `webpage_url_description` text, `update_md5` varchar(255) default NULL, `update_url` varchar(255) default NULL, `update_cmd_switch` varchar(255) default NULL, `update_instruction` text, `update_size` int(11) default NULL, `update_type` varchar(255) default NULL, `update_os` varchar(255) default NULL, `is_read` int(11) default '0', `is_archived` int(11) default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `network_service_notifications` -- LOCK TABLES `network_service_notifications` WRITE; /*!40000 ALTER TABLE `network_service_notifications` DISABLE KEYS */; /*!40000 ALTER TABLE `network_service_notifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `network_service_short_news` -- DROP TABLE IF EXISTS `network_service_short_news`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `network_service_short_news` ( `id` int(11) NOT NULL auto_increment, `status` int(11) default NULL, `title` varchar(255) default NULL, `message` text, `url` varchar(255) default NULL, `url_description` text, `is_archived` int(11) default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `network_service_short_news` -- LOCK TABLES `network_service_short_news` WRITE; /*!40000 ALTER TABLE `network_service_short_news` DISABLE KEYS */; /*!40000 ALTER TABLE `network_service_short_news` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `network_service_status` -- DROP TABLE IF EXISTS `network_service_status`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `network_service_status` ( `id` int(11) NOT NULL auto_increment, `last_checked` datetime default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `network_service_status` -- LOCK TABLES `network_service_status` WRITE; /*!40000 ALTER TABLE `network_service_status` DISABLE KEYS */; INSERT INTO `network_service_status` VALUES (1,'2010-02-09 09:35:30'); /*!40000 ALTER TABLE `network_service_status` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2010-02-09 18:43:25