/*!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 `AAAMAPS`
--
DROP TABLE IF EXISTS `AAAMAPS`;
CREATE TABLE `AAAMAPS` (
`id` int(11) NOT NULL,
`authServerName` varchar(255) NOT NULL,
`priority` int(11) NOT NULL,
`elemId` int(11) default NULL,
`domain` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `AAAMAPS`
--
/*!40000 ALTER TABLE `AAAMAPS` DISABLE KEYS */;
LOCK TABLES `AAAMAPS` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `AAAMAPS` ENABLE KEYS */;
--
-- Table structure for table `AAASERVERS`
--
DROP TABLE IF EXISTS `AAASERVERS`;
CREATE TABLE `AAASERVERS` (
`id` int(11) NOT NULL,
`landscape` double(20,0) default NULL,
`name` varchar(255) NOT NULL,
`netAddr` varchar(255) NOT NULL,
`authPort` int(11) default '1812',
`acctPort` int(11) default NULL,
`secret` varchar(255) default NULL,
`checkUser` varchar(255) default NULL,
`checkPassword` varchar(255) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `AAASERVERS`
--
/*!40000 ALTER TABLE `AAASERVERS` DISABLE KEYS */;
LOCK TABLES `AAASERVERS` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `AAASERVERS` ENABLE KEYS */;
--
-- Table structure for table `ADMINPROFILE`
--
DROP TABLE IF EXISTS `ADMINPROFILE`;
CREATE TABLE `ADMINPROFILE` (
`id` int(11) NOT NULL,
`name` varchar(255) default NULL,
`landscape` double(20,0) default NULL,
`canCreateBulk` tinyint(4) default NULL,
`canCreateConference` tinyint(4) default NULL,
`canCreateIndividual` tinyint(4) default NULL,
`canSendMessages` tinyint(4) default NULL,
`isKioskMode` tinyint(4) default NULL,
`isAlwaysOn` tinyint(4) default NULL,
`manageAccounts` int(11) default NULL,
`adminProfileObj` longblob,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ADMINPROFILE`
--
/*!40000 ALTER TABLE `ADMINPROFILE` DISABLE KEYS */;
LOCK TABLES `ADMINPROFILE` WRITE;
INSERT INTO `ADMINPROFILE` VALUES (1,'Profile_Sample',207380589022,1,1,1,0,0,1,-1,'226com.bsc.guest.AdminProfile131.2111214Profile_Sample14true14true14true15false15false14true121012-112-112-112-112451215219java.util.ArrayList1211111211\014true219java.util.Hashtable10');
UNLOCK TABLES;
/*!40000 ALTER TABLE `ADMINPROFILE` ENABLE KEYS */;
--
-- Table structure for table `AGENTMAC`
--
DROP TABLE IF EXISTS `AGENTMAC`;
CREATE TABLE `AGENTMAC` (
`id` int(11) default NULL,
`landscape` double(20,0) default NULL,
`mac` varchar(255) default NULL,
`description` varchar(255) default NULL,
`version` double(20,0) default NULL,
`ip` varchar(255) default NULL,
KEY `idx_id` (`id`),
KEY `idx_mac` (`mac`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `AGENTMAC`
--
/*!40000 ALTER TABLE `AGENTMAC` DISABLE KEYS */;
LOCK TABLES `AGENTMAC` WRITE;
INSERT INTO `AGENTMAC` VALUES (904,207380589022,'00:23:5A:94:84:E6','Atheros AR8132 PCI-E Fast Ethernet Controller',1,NULL),(903,207380589022,'00:1E:68:6B:3A:47','NVIDIA nForce 10/100 Mbps Ethernet',1,NULL),(904,207380589022,'00:24:2C:59:FF:E4','Broadcom 802.11g Network Adapter',1,'192.168.101.250'),(903,207380589022,'00:1F:E1:42:32:DA','Atheros AR5007 802.11b/g WiFi Adapter',1,'192.168.101.155'),(902,207380589022,'00:16:D4:C4:F3:1F','Intel(R) PRO/100 VE Network Connection - Packet Scheduler Miniport',1,NULL),(902,207380589022,'00:16:6F:C4:93:5D','Intel(R) PRO/Wireless 2200BG Network Connection - Packet Scheduler Miniport',1,'198.248.76.184'),(901,207380589022,'00:12:3F:F4:E8:19','Intel(R) PRO/100 VE Network Connection #3 - Packet Scheduler Miniport',1,NULL),(908,207380589022,'00:25:B3:74:38:82','Broadcom NetLink (TM) Gigabit Ethernet - Packet Scheduler Miniport',1,NULL),(908,207380589022,'00:1E:65:10:8C:A8','Intel(R) WiFi Link 5100 AGN - Packet Scheduler Miniport',1,'198.248.74.101'),(901,207380589022,'00:90:4B:E9:50:42','Dell Wireless 1370 WLAN Mini-PCI Card - Packet Scheduler Miniport',1,'192.168.101.206'),(907,207380589022,'00:1B:63:9F:DE:41','en0',1,NULL),(907,207380589022,'00:1D:4F:90:42:B9','en2',1,NULL),(907,207380589022,'00:1C:B3:C2:3A:84','en1',1,'192.168.101.224'),(906,207380589022,'00:21:9B:E1:A8:8D','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,NULL),(906,207380589022,'00:22:69:3E:66:6B','Dell Wireless 1395 WLAN Mini-Card',1,'192.168.101.39'),(905,207380589022,'00:1E:EC:EA:7D:B4','Realtek RTL8102E Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,NULL),(905,207380589022,'00:22:69:25:A1:12','Atheros AR5007 802.11b/g WiFi Adapter',1,'198.248.77.118'),(909,207380589022,'00:17:F2:C6:5B:94','en0',1,'192.168.101.42'),(909,207380589022,'00:1B:63:06:78:8A','en1',1,NULL),(910,207380589022,'00:1E:68:E4:D7:63','Realtek RTL8102E Family PCI-E Fast Ethernet NIC - Packet Scheduler Miniport',1,'192.168.101.153'),(910,207380589022,'00:23:4D:10:2F:1B','Atheros AR5007EG Wireless Network Adapter - Packet Scheduler Miniport',1,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `AGENTMAC` ENABLE KEYS */;
--
-- Table structure for table `AGENTTEST`
--
DROP TABLE IF EXISTS `AGENTTEST`;
CREATE TABLE `AGENTTEST` (
`id` int(11) default NULL,
`landscape` double(20,0) default NULL,
`status` int(11) default NULL,
`category` varchar(255) default NULL,
`test` varchar(255) default NULL,
`type` int(11) default NULL,
`version` double(20,0) default NULL,
KEY `idx_status` (`status`),
KEY `idx_id` (`id`),
KEY `idx_test` (`test`),
KEY `idx_category` (`category`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `AGENTTEST`
--
/*!40000 ALTER TABLE `AGENTTEST` DISABLE KEYS */;
LOCK TABLES `AGENTTEST` WRITE;
INSERT INTO `AGENTTEST` VALUES (904,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(904,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(904,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(904,207380589022,1,'Operating-System','Vista Service Pack',4,1),(904,207380589022,1,'Operating-System','Windows Vista',4,1),(903,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(908,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(903,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(903,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(903,207380589022,1,'Operating-System','Vista Service Pack',4,1),(903,207380589022,1,'Operating-System','Windows Vista',4,1),(902,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(902,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(902,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(908,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(902,207380589022,1,'Operating-System','Windows XP',4,1),(901,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(901,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(901,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(901,207380589022,1,'Operating-System','Windows XP',4,1),(908,207380589022,1,'Operating-System','Windows XP',4,1),(908,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(907,207380589022,1,'Operating-System','OS X Version 10.5 (Leopard)',4,1),(907,207380589022,1,'Operating-System','OS X Leopard Update',4,1),(906,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(906,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(906,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(906,207380589022,1,'Operating-System','Vista Service Pack',4,1),(906,207380589022,1,'Operating-System','Windows Vista',4,1),(905,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(905,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(905,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(905,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(905,207380589022,1,'Operating-System','Windows Vista x64',4,1),(909,207380589022,1,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(909,207380589022,1,'Operating-System','OS X Snow Leopard Update',4,1),(910,207380589022,1,'Operating-System','Windows XP',4,1),(910,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(910,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(910,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `AGENTTEST` ENABLE KEYS */;
--
-- Table structure for table `AGENTTESTRESULT`
--
DROP TABLE IF EXISTS `AGENTTESTRESULT`;
CREATE TABLE `AGENTTESTRESULT` (
`id` int(11) NOT NULL,
`landscape` double(20,0) default NULL,
`status` int(11) default NULL,
`userID` varchar(255) default NULL,
`hostName` varchar(255) default NULL,
`os` varchar(255) default NULL,
`policy` varchar(255) default NULL,
`time` double(20,0) default NULL,
`type` int(11) default NULL,
`version` double(20,0) default NULL,
`location` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `AGENTTESTRESULT`
--
/*!40000 ALTER TABLE `AGENTTESTRESULT` DISABLE KEYS */;
LOCK TABLES `AGENTTESTRESULT` WRITE;
INSERT INTO `AGENTTESTRESULT` VALUES (904,207380589022,1,'weis.ashley','user-PC','Windows Vista (TM) Home Basic 6.0 Service Pack 1','HCC-users',1271612475596,4,1,'Hampton AP VLAN Registration'),(903,207380589022,1,'schmitz.brittany','Brittany-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-users',1271358844238,4,1,NULL),(902,207380589022,1,'brown.nathan','FAMILY','Microsoft Windows XP 5.1 Service Pack 3','HCC-users',1271242997911,4,1,NULL),(901,207380589022,1,'pdonaldson','CHKPT','Microsoft Windows XP 5.1 Service Pack 3','HCC-users',1271164622385,4,1,'Library-AP VLAN Registration'),(907,207380589022,1,'tyler.george','Tys-MacBook-Pro','Mac OS X 10.5.8','HCC-users',1271858743747,4,1,NULL),(908,207380589022,1,'ssmith','MAR-0019','Microsoft Windows XP 5.1 Service Pack 3','HCC-users',1271864612591,4,1,NULL),(906,207380589022,1,'child.mitchell','mitchell-PC','Windows Vista (TM) Ultimate 6.0 Service Pack 2','HCC-users',1271795966696,4,1,NULL),(905,207380589022,1,'saunders.trevor','TrevorSaunde-PC','Windows (TM) Vista Home Premium 6.0 Service Pack 1','HCC-users',1271767859356,4,1,'ColonyPoint AP VLAN Registration'),(909,207380589022,1,'anderson.callene','admins-MacBook-Pro-17','Mac OS X 10.6.3','HCC-users',1272245269323,4,1,'Kiltie-MDF1 12'),(910,207380589022,1,'davis.cody01','Courtney','Microsoft Windows XP 5.1 Service Pack 3','HCC-users',1272247866637,4,1,'Rubeti-MDF1 22');
UNLOCK TABLES;
/*!40000 ALTER TABLE `AGENTTESTRESULT` ENABLE KEYS */;
--
-- Table structure for table `AGENTUPDATE`
--
DROP TABLE IF EXISTS `AGENTUPDATE`;
CREATE TABLE `AGENTUPDATE` (
`hostId` int(11) NOT NULL,
`attempts` int(11) NOT NULL,
`lastKnownVersion` varchar(255) default NULL,
PRIMARY KEY (`hostId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `AGENTUPDATE`
--
/*!40000 ALTER TABLE `AGENTUPDATE` DISABLE KEYS */;
LOCK TABLES `AGENTUPDATE` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `AGENTUPDATE` ENABLE KEYS */;
--
-- Table structure for table `ALARMS`
--
DROP TABLE IF EXISTS `ALARMS`;
CREATE TABLE `ALARMS` (
`id` int(11) NOT NULL,
`name` varchar(255) default NULL,
`elementType` int(11) default NULL,
`elementID` int(11) default NULL,
`severity` int(11) default NULL,
`time` double(20,0) default NULL,
`acknowledge` int(11) default NULL,
`alarmObj` longblob,
`landscape` double(20,0) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ALARMS`
--
/*!40000 ALTER TABLE `ALARMS` DISABLE KEYS */;
LOCK TABLES `ALARMS` WRITE;
INSERT INTO `ALARMS` VALUES (5543,'READ_CLIENTS_FAILURE',1,40,1,1271869709736,0,'227com.bsc.api.alarm.YamsAlarm131.2145543220READ_CLIENTS_FAILURE1240111213127186970973611015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName18LSU-IDF1219java.util.ArrayList1317176836317176839217176863621220738058902215false',207380589022),(5510,'DHCP_FINGERPRINT_CHANGED',8,7378,3,1271445528295,0,'227com.bsc.api.alarm.YamsAlarm131.2145510224DHCP_FINGERPRINT_CHANGED147378113213127144552829511015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host18IT-0004m221com.bsc.api.NameValue131.0213ParameterList2281,3,6,15,119,95,252,44,46,47219java.util.ArrayList1117174006821220738058902215false',207380589022),(5511,'DHCP_FINGERPRINT_CHANGED',8,7378,3,1271445529396,0,'227com.bsc.api.alarm.YamsAlarm131.2145511224DHCP_FINGERPRINT_CHANGED147378113213127144552939611015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host18IT-0004m221com.bsc.api.NameValue131.0213ParameterList2281,3,6,15,119,95,252,44,46,47219java.util.ArrayList1117174007021220738058902215false',207380589022),(5502,'DHCP_FINGERPRINT_CHANGED',9,6620,3,1271435091715,0,'227com.bsc.api.alarm.YamsAlarm131.2145502224DHCP_FINGERPRINT_CHANGED 146620113213127143509171511015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:1C:23:E0:17:5E221com.bsc.api.NameValue131.014Host17IT-0002221com.bsc.api.NameValue131.0213ParameterList2341,15,3,6,44,46,47,31,33,121,249,43219java.util.ArrayList1117173772721220738058902215false',207380589022),(5501,'READ_CLIENTS_FAILURE',1,1647,1,1271432514387,0,'227com.bsc.api.alarm.YamsAlarm131.2145501220READ_CLIENTS_FAILURE141647111213127143251438711015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName214ColonyPoint AP219java.util.ArrayList1217173721917174509921220738058902215false',207380589022),(5512,'DHCP_FINGERPRINT_CHANGED',8,7378,3,1271445577058,0,'227com.bsc.api.alarm.YamsAlarm131.2145512224DHCP_FINGERPRINT_CHANGED147378113213127144557705811015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host221com.bsc.api.NameValue131.0213ParameterList2121,3,67,43,60219java.util.ArrayList1117174008821220738058902215false',207380589022),(5527,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271612012777,0,'227com.bsc.api.alarm.YamsAlarm131.2145527227CLIENT_REGISTRATION_FAILURE112111213127161201277711015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient234Authentication Failure weis.ashley221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117174683421220738058902215false',207380589022),(5517,'CONTACT_LOST',1,1945,1,1271525435491,0,'227com.bsc.api.alarm.YamsAlarm131.2145517212CONTACT_LOST141945111213127152543549111015false219java.util.ArrayList12221com.bsc.api.NameValue131.018protocol14Snmp221com.bsc.api.NameValue131.017element225D-link Corp. Access Point219java.util.ArrayList1117174361621220738058902215false',207380589022),(5518,'DHCP_FINGERPRINT_CHANGED',9,7348,3,1271551193011,0,'227com.bsc.api.alarm.YamsAlarm131.2145518224DHCP_FINGERPRINT_CHANGED 147348113213127155119301111015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:1F:29:F3:E2:DD221com.bsc.api.NameValue131.014Host18HPF3E2DD221com.bsc.api.NameValue131.0213ParameterList2206,3,1,15,66,67,13,44219java.util.ArrayList1117174478621220738058902215false',207380589022),(5519,'DHCP_FINGERPRINT_CHANGED',9,7390,3,1271551208013,0,'227com.bsc.api.alarm.YamsAlarm131.2145519224DHCP_FINGERPRINT_CHANGED 147390113213127155120801311015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:0D:3A:1F:79:CD221com.bsc.api.NameValue131.014Host16MN-740221com.bsc.api.NameValue131.0213ParameterList181,3,6,15219java.util.ArrayList1117174479221220738058902215false',207380589022),(5522,'DHCP_FINGERPRINT_CHANGED',9,7348,3,1271551487682,0,'227com.bsc.api.alarm.YamsAlarm131.2145522224DHCP_FINGERPRINT_CHANGED 147348113213127155148768211015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:1F:29:F3:E2:DD221com.bsc.api.NameValue131.014Host18HPF3E2DD221com.bsc.api.NameValue131.0213ParameterList2206,3,1,15,66,67,13,44219java.util.ArrayList1117174484221220738058902215false',207380589022),(5523,'DHCP_FINGERPRINT_CHANGED',9,7390,3,1271551508467,0,'227com.bsc.api.alarm.YamsAlarm131.2145523224DHCP_FINGERPRINT_CHANGED 147390113213127155150846711015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:0D:3A:1F:79:CD221com.bsc.api.NameValue131.014Host16MN-740221com.bsc.api.NameValue131.0213ParameterList181,3,6,15219java.util.ArrayList1117174484421220738058902215false',207380589022),(5524,'DHCP_FINGERPRINT_CHANGED',9,7390,3,1271559314013,0,'227com.bsc.api.alarm.YamsAlarm131.2145524224DHCP_FINGERPRINT_CHANGED 147390113213127155931401311015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:0D:3A:1F:79:CD221com.bsc.api.NameValue131.014Host16MN-740221com.bsc.api.NameValue131.0213ParameterList181,3,6,15219java.util.ArrayList1117174514021220738058902215false',207380589022),(5525,'DHCP_FINGERPRINT_CHANGED',9,7390,3,1271559614524,0,'227com.bsc.api.alarm.YamsAlarm131.2145525224DHCP_FINGERPRINT_CHANGED 147390113213127155961452411015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:0D:3A:1F:79:CD221com.bsc.api.NameValue131.014Host16MN-740221com.bsc.api.NameValue131.0213ParameterList181,3,6,15219java.util.ArrayList1117174516221220738058902215false',207380589022),(5444,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271076967748,0,'227com.bsc.api.alarm.YamsAlarm131.2145444227CLIENT_REGISTRATION_FAILURE112111213127107696774811015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient234Authentication Failure gray_shalon221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117169374921220738058902215false',207380589022),(5583,'READ_CLIENTS_FAILURE',1,1648,1,1271870790818,0,'227com.bsc.api.alarm.YamsAlarm131.2145583220READ_CLIENTS_FAILURE141648111213127187079081811015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName214CornerStone AP219java.util.ArrayList1117176859821220738058902215false',207380589022),(5584,'READ_CLIENTS_FAILURE',1,1650,1,1271870820862,0,'227com.bsc.api.alarm.YamsAlarm131.2145584220READ_CLIENTS_FAILURE141650111213127187082086211015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName211Claymont AP219java.util.ArrayList1117176861121220738058902215false',207380589022),(5602,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271913098141,0,'227com.bsc.api.alarm.YamsAlarm131.2145602227CLIENT_REGISTRATION_FAILURE112111213127191309814111015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient239Authentication Failure stanford.michael221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117177237021220738058902215false',207380589022),(5604,'DHCP_FINGERPRINT_CHANGED',8,7378,3,1271974275821,0,'227com.bsc.api.alarm.YamsAlarm131.2145604224DHCP_FINGERPRINT_CHANGED147378113213127197427582111015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host221com.bsc.api.NameValue131.0213ParameterList2121,3,67,43,60219java.util.ArrayList1117177697621220738058902215false',207380589022),(5609,'CLIENT_REGISTRATION_FAILURE',7,2,1,1272032217593,0,'227com.bsc.api.alarm.YamsAlarm131.2145609227CLIENT_REGISTRATION_FAILURE112111213127203221759311015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient238Registered Client Not Found Gray.shane221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117178117821220738058902215false',207380589022),(5606,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271990650669,0,'227com.bsc.api.alarm.YamsAlarm131.2145606227CLIENT_REGISTRATION_FAILURE112111213127199065066911015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient239Authentication Failure michael.stanford221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117177874421220738058902215false',207380589022),(5582,'READ_CLIENTS_FAILURE',1,30,1,1271870765778,0,'227com.bsc.api.alarm.YamsAlarm131.2145582220READ_CLIENTS_FAILURE1230111213127187076577811015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName17CT-MDF1219java.util.ArrayList1217176859317176863521220738058902215false',207380589022),(5577,'READ_CLIENTS_FAILURE',1,1588,1,1271870495918,0,'227com.bsc.api.alarm.YamsAlarm131.2145577220READ_CLIENTS_FAILURE141588111213127187049591811015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName17MS-MDF1219java.util.ArrayList1317176854317176860017176866121220738058902215false',207380589022),(5613,'CLIENT_REGISTRATION_FAILURE',7,2,1,1272170365212,0,'227com.bsc.api.alarm.YamsAlarm131.2145613227CLIENT_REGISTRATION_FAILURE112111213127217036521211015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient235Authentication Failure jones.victor221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117178829721220738058902215false',207380589022),(5614,'CLIENT_REGISTRATION_FAILURE',7,2,1,1272170376038,0,'227com.bsc.api.alarm.YamsAlarm131.2145614227CLIENT_REGISTRATION_FAILURE112111213127217037603811015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient235Authentication Failure jones.victor221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117178830021220738058902215false',207380589022),(5615,'CLIENT_REGISTRATION_FAILURE',7,2,1,1272170389671,0,'227com.bsc.api.alarm.YamsAlarm131.2145615227CLIENT_REGISTRATION_FAILURE112111213127217038967111015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient240Registered Client Not Found jones.victor221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117178830221220738058902215false',207380589022),(5573,'READ_CLIENTS_FAILURE',1,2192,1,1271870245263,0,'227com.bsc.api.alarm.YamsAlarm131.2145573220READ_CLIENTS_FAILURE142192111213127187024526311015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName19ArtDeptHP219java.util.ArrayList1217176850717176866321220738058902215false',207380589022),(5572,'READ_CLIENTS_FAILURE',1,2162,1,1271870065103,0,'227com.bsc.api.alarm.YamsAlarm131.2145572220READ_CLIENTS_FAILURE142162111213127187006510311015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName19Snack Bar219java.util.ArrayList1417176848917176857417176863117176868921220738058902215false',207380589022),(5619,'CLIENT_REGISTRATION_FAILURE',7,2,1,1272255649906,0,'227com.bsc.api.alarm.YamsAlarm131.2145619227CLIENT_REGISTRATION_FAILURE112111213127225564990611015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient236Authentication Failure megastorm1000221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117179192921220738058902215false',207380589022),(5617,'CLIENT_REGISTRATION_FAILURE',7,2,1,1272255397412,0,'227com.bsc.api.alarm.YamsAlarm131.2145617227CLIENT_REGISTRATION_FAILURE112111213127225539741211015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient236Authentication Failure Megastorm1000221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117179190021220738058902215false',207380589022),(5618,'CLIENT_REGISTRATION_FAILURE',7,2,1,1272255555818,0,'227com.bsc.api.alarm.YamsAlarm131.2145618227CLIENT_REGISTRATION_FAILURE112111213127225555581811015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient236Authentication Failure Megastorm1000221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117179192621220738058902215false',207380589022),(5560,'READ_CLIENTS_FAILURE',1,1642,1,1271869824875,0,'227com.bsc.api.alarm.YamsAlarm131.2145560220READ_CLIENTS_FAILURE141642111213127186982487511015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName212Sunflower AP219java.util.ArrayList1317176842517176853517176862721220738058902215false',207380589022),(5592,'DHCP_FINGERPRINT_CHANGED',9,7390,3,1271882742012,0,'227com.bsc.api.alarm.YamsAlarm131.2145592224DHCP_FINGERPRINT_CHANGED 147390113213127188274201211015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:0D:3A:1F:79:CD221com.bsc.api.NameValue131.014Host16MN-740221com.bsc.api.NameValue131.0213ParameterList181,3,6,15219java.util.ArrayList1117176868721220738058902215false',207380589022),(5563,'READ_CLIENTS_FAILURE',1,2079,1,1271869889949,0,'227com.bsc.api.alarm.YamsAlarm131.2145563220READ_CLIENTS_FAILURE142079111213127186988994911015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName213Enterprise AP219java.util.ArrayList1517176844117176845717176854817176863217177726521220738058902215false',207380589022),(5594,'DHCP_FINGERPRINT_CHANGED',8,7378,3,1271888113945,0,'227com.bsc.api.alarm.YamsAlarm131.2145594224DHCP_FINGERPRINT_CHANGED147378113213127188811394511015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host18IT-0004m221com.bsc.api.NameValue131.0213ParameterList2281,3,6,15,119,95,252,44,46,47219java.util.ArrayList1117176996921220738058902215false',207380589022),(5595,'DHCP_FINGERPRINT_CHANGED',8,7378,3,1271888167409,0,'227com.bsc.api.alarm.YamsAlarm131.2145595224DHCP_FINGERPRINT_CHANGED147378113213127188816740911015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host221com.bsc.api.NameValue131.0213ParameterList2121,3,67,43,60219java.util.ArrayList1117176998121220738058902215false',207380589022),(5601,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271912236934,0,'227com.bsc.api.alarm.YamsAlarm131.2145601227CLIENT_REGISTRATION_FAILURE112111213127191223693411015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient234Authentication Failure highland123221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117177224221220738058902215false',207380589022),(5492,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271368295869,0,'227com.bsc.api.alarm.YamsAlarm131.2145492227CLIENT_REGISTRATION_FAILURE112111213127136829586911015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient252Authentication Failure riddick.marvin@highlandcc.edu221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117173210021220738058902215false',207380589022),(5491,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271368270159,0,'227com.bsc.api.alarm.YamsAlarm131.2145491227CLIENT_REGISTRATION_FAILURE112111213127136827015911015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient252Authentication Failure riddick.marvin@highlandcc.edu221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117173209721220738058902215false',207380589022),(5494,'DHCP_FINGERPRINT_CHANGED',8,2837,3,1271432080329,0,'227com.bsc.api.alarm.YamsAlarm131.2145494224DHCP_FINGERPRINT_CHANGED142837113213127143208032911015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host221com.bsc.api.NameValue131.0213ParameterList2121,3,67,43,60219java.util.ArrayList1117173706721220738058902215false',207380589022),(5486,'READ_CLIENTS_FAILURE',1,38,1,1271358594272,0,'227com.bsc.api.alarm.YamsAlarm131.2145486220READ_CLIENTS_FAILURE1238111213127135859427211015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName213Heritage-MDF1219java.util.ArrayList1117173107021220738058902215false',207380589022),(5611,'DHCP_FINGERPRINT_CHANGED',9,7568,3,1272089030105,0,'227com.bsc.api.alarm.YamsAlarm131.2145611224DHCP_FINGERPRINT_CHANGED 147568113213127208903010511015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:1B:9E:28:D9:1E221com.bsc.api.NameValue131.014Host17lamptop221com.bsc.api.NameValue131.0213ParameterList2301,15,3,6,44,46,47,31,33,249,43219java.util.ArrayList1117178510421220738058902215false',207380589022),(5489,'DHCP_FINGERPRINT_CHANGED',8,2837,3,1271359645347,0,'227com.bsc.api.alarm.YamsAlarm131.2145489224DHCP_FINGERPRINT_CHANGED142837113213127135964534711015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host221com.bsc.api.NameValue131.0213ParameterList2121,3,67,43,60219java.util.ArrayList1117173134821220738058902215false',207380589022),(5488,'DHCP_FINGERPRINT_CHANGED',8,2837,3,1271359593150,0,'227com.bsc.api.alarm.YamsAlarm131.2145488224DHCP_FINGERPRINT_CHANGED142837113213127135959315011015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host18IT-0004m221com.bsc.api.NameValue131.0213ParameterList2281,3,6,15,119,95,252,44,46,47219java.util.ArrayList1117173131721220738058902215false',207380589022),(5476,'DHCP_FINGERPRINT_CHANGED',8,2837,3,1271274608233,0,'227com.bsc.api.alarm.YamsAlarm131.2145476224DHCP_FINGERPRINT_CHANGED142837113213127127460823311015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host221com.bsc.api.NameValue131.0213ParameterList2121,3,67,43,60219java.util.ArrayList1117172221521220738058902215false',207380589022),(5475,'DHCP_FINGERPRINT_CHANGED',8,2837,3,1271274556512,0,'227com.bsc.api.alarm.YamsAlarm131.2145475224DHCP_FINGERPRINT_CHANGED142837113213127127455651211015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host18IT-0004m221com.bsc.api.NameValue131.0213ParameterList2281,3,6,15,119,95,252,44,46,47219java.util.ArrayList1117172220221220738058902215false',207380589022),(5474,'DHCP_FINGERPRINT_CHANGED',8,2837,3,1271274555412,0,'227com.bsc.api.alarm.YamsAlarm131.2145474224DHCP_FINGERPRINT_CHANGED142837113213127127455541211015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host18IT-0004m221com.bsc.api.NameValue131.0213ParameterList2281,3,6,15,119,95,252,44,46,47219java.util.ArrayList1117172219921220738058902215false',207380589022),(5473,'DHCP_FINGERPRINT_CHANGED',9,7344,3,1271262144491,0,'227com.bsc.api.alarm.YamsAlarm131.2145473224DHCP_FINGERPRINT_CHANGED 147344113213127126214449111015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:19:C5:E6:F1:64221com.bsc.api.NameValue131.014Host221com.bsc.api.NameValue131.0213ParameterList181,3,15,6219java.util.ArrayList1117172083621220738058902215false',207380589022),(5529,'DHCP_FINGERPRINT_CHANGED',8,7378,3,1271684440103,0,'227com.bsc.api.alarm.YamsAlarm131.2145529224DHCP_FINGERPRINT_CHANGED147378113213127168444010311015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host18IT-0004m221com.bsc.api.NameValue131.0213ParameterList2281,3,6,15,119,95,252,44,46,47219java.util.ArrayList1117175209921220738058902215false',207380589022),(5472,'DHCP_FINGERPRINT_CHANGED',9,7344,3,1271262017012,0,'227com.bsc.api.alarm.YamsAlarm131.2145472224DHCP_FINGERPRINT_CHANGED 147344113213127126201701211015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:19:C5:E6:F1:64221com.bsc.api.NameValue131.014Host221com.bsc.api.NameValue131.0213ParameterList2111,3,28,6,15219java.util.ArrayList1117172083021220738058902215false',207380589022),(5470,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271242192200,0,'227com.bsc.api.alarm.YamsAlarm131.2145470227CLIENT_REGISTRATION_FAILURE112111213127124219220011015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient234Authentication Failure Mabe.Taylor221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117171869821220738058902215false',207380589022),(5466,'DHCP_FINGERPRINT_CHANGED',8,2837,3,1271186314469,0,'227com.bsc.api.alarm.YamsAlarm131.2145466224DHCP_FINGERPRINT_CHANGED142837113213127118631446911015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host221com.bsc.api.NameValue131.0213ParameterList2121,3,67,43,60219java.util.ArrayList1117170608421220738058902215false',207380589022),(5465,'DHCP_FINGERPRINT_CHANGED',8,2837,3,1271186262378,0,'227com.bsc.api.alarm.YamsAlarm131.2145465224DHCP_FINGERPRINT_CHANGED142837113213127118626237811015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host18IT-0004m221com.bsc.api.NameValue131.0213ParameterList2281,3,6,15,119,95,252,44,46,47219java.util.ArrayList1117170606221220738058902215false',207380589022),(5464,'READ_CLIENTS_FAILURE',1,1895,1,1271185067299,0,'227com.bsc.api.alarm.YamsAlarm131.2145464220READ_CLIENTS_FAILURE141895111213127118506729911015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName213Highlander AP219java.util.ArrayList1417170565817170747817176861317177789521220738058902215false',207380589022),(5471,'DHCP_FINGERPRINT_CHANGED',8,2837,3,1271247959718,0,'227com.bsc.api.alarm.YamsAlarm131.2145471224DHCP_FINGERPRINT_CHANGED142837113213127124795971811015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host221com.bsc.api.NameValue131.0213ParameterList2121,3,67,43,60219java.util.ArrayList1117171940021220738058902215false',207380589022),(5559,'READ_CLIENTS_FAILURE',1,1653,1,1271869814857,0,'227com.bsc.api.alarm.YamsAlarm131.2145559220READ_CLIENTS_FAILURE141653111213127186981485711015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName210Rubeti1 AP219java.util.ArrayList1417176841617176850617176861517176862621220738058902215false',207380589022),(5459,'READ_CLIENTS_FAILURE',1,1640,1,1271173052335,0,'227com.bsc.api.alarm.YamsAlarm131.2145459220READ_CLIENTS_FAILURE141640111213127117305233511015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName213Hearthford AP219java.util.ArrayList1717170184117171980917173717117174663817175021117175084717175088121220738058902215false',207380589022),(5457,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271164182655,0,'227com.bsc.api.alarm.YamsAlarm131.2145457227CLIENT_REGISTRATION_FAILURE112111213127116418265511015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient241Registered Client Not Found brianejohnson221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117170103721220738058902215false',207380589022),(5455,'MULTI_CLIENTS_DETECTED',2,893,1,1271157001372,0,'227com.bsc.api.alarm.YamsAlarm131.2145455222MULTI_CLIENTS_DETECTED13893111213127115700137211015false219java.util.ArrayList14221com.bsc.api.NameValue131.0211ElementName210Ellis-MDF1221com.bsc.api.NameValue131.018PortName213Ellis-MDF1 44221com.bsc.api.NameValue131.017Clients112221com.bsc.api.NameValue131.014Macs310100:11:09:3E:23:06 - Mabe, Taylor\n00:17:FA:4D:CD:50 - Erdmann, Karl - Please select your game console\n219java.util.ArrayList310017178313917178315117178319117178320517178321817178324117178324817178325317178326917178327817178330517178332417178333317178333817178334317178335417178335917178336417178336917178338017178338517178339017178339517178340017178341017178342417178343617178350517178351717178352917178353417178353917178354417178354917178355717178356217178357317178359517178363017178363517178364317178364817178365317178366117178366617178370717178383117178383217178383317178383517178383917178384117178384217178390417179078317179081117179090117179092217179100117179102217179103517179104017179104617179112917179115917179118217179121017179123817179126817179128617179133517179137817179146717179148417179149217179149817179156717179157217179157717179165717179166217179166717179167217179167717179169017179169517179170517179172217179173117179174317179177417179181917179192417179195517179198617179200317179202717179205517179205917179208321220738058902215false',207380589022),(5452,'DHCP_FINGERPRINT_CHANGED',8,2837,3,1271099962686,0,'227com.bsc.api.alarm.YamsAlarm131.2145452224DHCP_FINGERPRINT_CHANGED142837113213127109996268611015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host221com.bsc.api.NameValue131.0213ParameterList2121,3,67,43,60219java.util.ArrayList1117169653321220738058902215false',207380589022),(5451,'DHCP_FINGERPRINT_CHANGED',8,2837,3,1271099910436,0,'227com.bsc.api.alarm.YamsAlarm131.2145451224DHCP_FINGERPRINT_CHANGED142837113213127109991043611015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host18IT-0004m221com.bsc.api.NameValue131.0213ParameterList2281,3,6,15,119,95,252,44,46,47219java.util.ArrayList1117169653121220738058902215false',207380589022),(5450,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271087333400,0,'227com.bsc.api.alarm.YamsAlarm131.2145450227CLIENT_REGISTRATION_FAILURE112111213127108733340011015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient232Authentication Failure smith3434221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117169494221220738058902215false',207380589022),(5448,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271087250250,0,'227com.bsc.api.alarm.YamsAlarm131.2145448227CLIENT_REGISTRATION_FAILURE112111213127108725025011015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient232Authentication Failure smith3434221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117169493121220738058902215false',207380589022),(5449,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271087302405,0,'227com.bsc.api.alarm.YamsAlarm131.2145449227CLIENT_REGISTRATION_FAILURE112111213127108730240511015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient249Authentication Failure michgan_rules_25@yahoo.com221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117169493921220738058902215false',207380589022),(5447,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271087223559,0,'227com.bsc.api.alarm.YamsAlarm131.2145447227CLIENT_REGISTRATION_FAILURE112111213127108722355911015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient232Authentication Failure smith3434221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117169492821220738058902215false',207380589022),(5446,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271078949246,0,'227com.bsc.api.alarm.YamsAlarm131.2145446227CLIENT_REGISTRATION_FAILURE112111213127107894924611015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient242Registered Client Not Found sutton.whitney221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117169398621220738058902215false',207380589022),(5445,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271078941827,0,'227com.bsc.api.alarm.YamsAlarm131.2145445227CLIENT_REGISTRATION_FAILURE112111213127107894182711015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient242Registered Client Not Found sutton.whitney221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117169398021220738058902215false',207380589022),(5443,'DHCP_FINGERPRINT_CHANGED',9,6555,3,1271057982776,0,'227com.bsc.api.alarm.YamsAlarm131.2145443224DHCP_FINGERPRINT_CHANGED 146555113213127105798277611015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:1F:29:F3:E2:DD221com.bsc.api.NameValue131.014Host18HPF3E2DD221com.bsc.api.NameValue131.0213ParameterList2206,3,1,15,66,67,13,44219java.util.ArrayList1117169233621220738058902215false',207380589022),(5442,'DHCP_FINGERPRINT_CHANGED',9,6555,3,1271057688012,0,'227com.bsc.api.alarm.YamsAlarm131.2145442224DHCP_FINGERPRINT_CHANGED 146555113213127105768801211015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:1F:29:F3:E2:DD221com.bsc.api.NameValue131.014Host18HPF3E2DD221com.bsc.api.NameValue131.0213ParameterList2206,3,1,15,66,67,13,44219java.util.ArrayList1117169232321220738058902215false',207380589022),(5593,'DHCP_FINGERPRINT_CHANGED',9,7390,3,1271883042187,0,'227com.bsc.api.alarm.YamsAlarm131.2145593224DHCP_FINGERPRINT_CHANGED 147390113213127188304218711015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:0D:3A:1F:79:CD221com.bsc.api.NameValue131.014Host16MN-740221com.bsc.api.NameValue131.0213ParameterList181,3,6,15219java.util.ArrayList1117176877221220738058902215false',207380589022),(5603,'DHCP_FINGERPRINT_CHANGED',8,7378,3,1271974222542,0,'227com.bsc.api.alarm.YamsAlarm131.2145603224DHCP_FINGERPRINT_CHANGED147378113213127197422254211015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host18IT-0004m221com.bsc.api.NameValue131.0213ParameterList2281,3,6,15,119,95,252,44,46,47219java.util.ArrayList1117177694321220738058902215false',207380589022),(5598,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271905824140,0,'227com.bsc.api.alarm.YamsAlarm131.2145598227CLIENT_REGISTRATION_FAILURE112111213127190582414011015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient234Registered Client Not Found bdixon221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117177152121220738058902215false',207380589022),(5599,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271905833849,0,'227com.bsc.api.alarm.YamsAlarm131.2145599227CLIENT_REGISTRATION_FAILURE112111213127190583384911015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient234Registered Client Not Found bdixon221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117177153321220738058902215false',207380589022),(5600,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271905853041,0,'227com.bsc.api.alarm.YamsAlarm131.2145600227CLIENT_REGISTRATION_FAILURE112111213127190585304111015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient234Registered Client Not Found bdixon221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117177153521220738058902215false',207380589022),(5458,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271164323991,0,'227com.bsc.api.alarm.YamsAlarm131.2145458227CLIENT_REGISTRATION_FAILURE112111213127116432399111015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient238Registered Client Not Found pdonaldson221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117170104221220738058902215false',207380589022),(5612,'CONTACT_LOST',1,1952,1,1272133851804,0,'227com.bsc.api.alarm.YamsAlarm131.2145612212CONTACT_LOST141952111213127213385180411015false219java.util.ArrayList12221com.bsc.api.NameValue131.018protocol14Snmp221com.bsc.api.NameValue131.017element214198.248.75.137219java.util.ArrayList1117178650721220738058902215false',207380589022),(5581,'READ_CLIENTS_FAILURE',1,1646,1,1271870680765,0,'227com.bsc.api.alarm.YamsAlarm131.2145581220READ_CLIENTS_FAILURE141646111213127187068076511015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName210Rubeti6 AP219java.util.ArrayList1117176858321220738058902215false',207380589022),(5508,'READ_CLIENTS_FAILURE',1,2177,1,1271439881651,0,'227com.bsc.api.alarm.YamsAlarm131.2145508220READ_CLIENTS_FAILURE142177111213127143988165111015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName210Library-AP219java.util.ArrayList1517173868317176830017176850517176861017176863021220738058902215false',207380589022),(5538,'DHCP_FINGERPRINT_CHANGED',8,1385,3,1271774534242,0,'227com.bsc.api.alarm.YamsAlarm131.2145538224DHCP_FINGERPRINT_CHANGED141385113213127177453424211015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:1D:4F:C3:A6:47221com.bsc.api.NameValue131.014Host14iPod221com.bsc.api.NameValue131.0213ParameterList2281,3,6,15,119,95,252,44,46,47219java.util.ArrayList1117176010021220738058902215false',207380589022),(5528,'READ_CLIENTS_FAILURE',1,1645,1,1271671081267,0,'227com.bsc.api.alarm.YamsAlarm131.2145528220READ_CLIENTS_FAILURE141645111213127167108126711015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName213Huntington AP219java.util.ArrayList1117175020821220738058902215false',207380589022),(5530,'DHCP_FINGERPRINT_CHANGED',8,7378,3,1271684495451,0,'227com.bsc.api.alarm.YamsAlarm131.2145530224DHCP_FINGERPRINT_CHANGED147378113213127168449545111015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host221com.bsc.api.NameValue131.0213ParameterList2121,3,67,43,60219java.util.ArrayList1117175211721220738058902215false',207380589022),(5533,'DHCP_FINGERPRINT_CHANGED',8,7378,3,1271704920343,0,'227com.bsc.api.alarm.YamsAlarm131.2145533224DHCP_FINGERPRINT_CHANGED147378113213127170492034311015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host18IT-0004m221com.bsc.api.NameValue131.0213ParameterList2281,3,6,15,119,95,252,44,46,47219java.util.ArrayList1117175476621220738058902215false',207380589022),(5534,'DHCP_FINGERPRINT_CHANGED',8,7378,3,1271704974580,0,'227com.bsc.api.alarm.YamsAlarm131.2145534224DHCP_FINGERPRINT_CHANGED147378113213127170497458011015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host221com.bsc.api.NameValue131.0213ParameterList2121,3,67,43,60219java.util.ArrayList1117175478221220738058902215false',207380589022),(5535,'READ_CLIENTS_FAILURE',1,2082,1,1271707066214,0,'227com.bsc.api.alarm.YamsAlarm131.2145535220READ_CLIENTS_FAILURE142082111213127170706621411015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName213Enterprise AP219java.util.ArrayList1117175496521220738058902215false',207380589022),(5586,'READ_CLIENTS_FAILURE',1,1652,1,1271882676597,0,'227com.bsc.api.alarm.YamsAlarm131.2145586220READ_CLIENTS_FAILURE141652111213127188267659711015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName212Degginger AP219java.util.ArrayList1317176862817176869517177040921220738058902215false',207380589022),(5587,'READ_CLIENTS_FAILURE',1,39,1,1271882677435,0,'227com.bsc.api.alarm.YamsAlarm131.2145587220READ_CLIENTS_FAILURE1239111213127188267743511015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName18LSU-MDF1219java.util.ArrayList1117176863321220738058902215false',207380589022),(5588,'READ_CLIENTS_FAILURE',1,43,1,1271882681925,0,'227com.bsc.api.alarm.YamsAlarm131.2145588220READ_CLIENTS_FAILURE1243111213127188268192511015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName210Irvin-IDF1219java.util.ArrayList1117176863821220738058902215false',207380589022),(5589,'READ_CLIENTS_FAILURE',1,42,1,1271882683453,0,'227com.bsc.api.alarm.YamsAlarm131.2145589220READ_CLIENTS_FAILURE1242111213127188268345311015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName210Irvin-MDF1219java.util.ArrayList1117176864121220738058902215false',207380589022),(5590,'READ_CLIENTS_FAILURE',1,1147,1,1271882686708,0,'227com.bsc.api.alarm.YamsAlarm131.2145590220READ_CLIENTS_FAILURE141147111213127188268670811015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName216Cornerstone-MDF1219java.util.ArrayList1117176864821220738058902215false',207380589022),(5591,'READ_CLIENTS_FAILURE',1,1145,1,1271882687450,0,'227com.bsc.api.alarm.YamsAlarm131.2145591220READ_CLIENTS_FAILURE141145111213127188268745011015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName214Sunflower-MDF1219java.util.ArrayList1117176865021220738058902215false',207380589022);
UNLOCK TABLES;
/*!40000 ALTER TABLE `ALARMS` ENABLE KEYS */;
--
-- Table structure for table `CONNECTIONLOG`
--
DROP TABLE IF EXISTS `CONNECTIONLOG`;
CREATE TABLE `CONNECTIONLOG` (
`connectionTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`disconnectTime` timestamp NOT NULL default '0000-00-00 00:00:00',
`userID` varchar(32) NOT NULL default '',
`ip` varchar(24) default NULL,
`mac` char(17) default NULL,
`location` varchar(254) default NULL,
`bytesIn` int(10) unsigned NOT NULL,
`bytesOut` int(10) unsigned NOT NULL,
`loadIn` float NOT NULL,
`loadOut` float NOT NULL,
`peakLoadIn` float NOT NULL,
`peakLoadOut` float NOT NULL,
KEY `userIndex` (`userID`),
KEY `connectIndex` (`connectionTime`),
KEY `ipIndex` (`ip`),
KEY `locationIndex` (`location`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `CONNECTIONLOG`
--
/*!40000 ALTER TABLE `CONNECTIONLOG` DISABLE KEYS */;