/*!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),(892,207380589022,'00:1E:4C:77:75:F3','Atheros AR5007 802.11b/g WiFi Adapter',1,'192.168.101.113'),(892,207380589022,'00:1B:24:F4:83:97','NVIDIA nForce Networking Controller',1,NULL),(893,207380589022,'00:1B:24:C2:0A:47','NVIDIA nForce Networking Controller',1,'192.168.101.213'),(893,207380589022,'00:1A:73:AE:B0:11','Broadcom 802.11 Multiband Network Adapter',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),(897,207380589022,'00:1F:3C:95:D2:36','Intel(R) PRO/Wireless 3945ABG Network Connection',1,'192.168.101.82'),(894,207380589022,'00:23:5A:AE:B0:83','Realtek RTL8102E/8103E Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,NULL),(896,207380589022,'00:26:9E:03:F9:A3','Realtek PCIe FE Family Controller',1,NULL),(894,207380589022,'00:21:00:EE:A1:E4','Broadcom 802.11b/g WLAN',1,'164.113.45.29'),(896,207380589022,'00:26:5E:49:97:5D','Broadcom 802.11b/g WLAN',1,'192.168.101.118'),(901,207380589022,'00:90:4B:E9:50:42','Dell Wireless 1370 WLAN Mini-PCI Card - Packet Scheduler Miniport',1,'192.168.101.206'),(895,207380589022,'00:26:BB:01:01:91','en1',1,'198.248.75.146'),(895,207380589022,'00:26:4A:13:9E:06','en0',1,NULL),(897,207380589022,'00:E0:B8:F9:60:24','Realtek RTL8101 Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,NULL),(898,207380589022,'00:1B:63:C2:2D:21','en1',1,'192.168.101.84'),(898,207380589022,'00:19:E3:3C:71:05','en0',1,NULL),(899,207380589022,'00:22:FA:0A:31:02','Intel(R) Wireless WiFi Link 5100',1,'192.168.101.99'),(899,207380589022,'00:1E:33:8E:40:A0','Realtek RTL8102E Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,NULL),(899,207380589022,'00:25:9C:00:42:2D','Linksys RangePlus Wireless USB Adapter #3',1,NULL),(900,207380589022,'70:1A:04:BE:A1:0E','Atheros AR5B93 Wireless Network Adapter',1,'192.168.101.136'),(900,207380589022,'70:5A:B6:17:63:1C','Broadcom NetLink (TM) Gigabit Ethernet',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 (896,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(896,207380589022,1,'Operating-System','Windows Vista x64',4,1),(894,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(894,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(894,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(894,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(894,207380589022,1,'Operating-System','Windows Vista x64',4,1),(893,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(893,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(893,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(893,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(893,207380589022,1,'Operating-System','Windows 7',4,1),(892,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(892,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(892,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(892,207380589022,1,'Operating-System','Vista Service Pack',4,1),(904,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(892,207380589022,1,'Operating-System','Windows Vista',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),(897,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(897,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(897,207380589022,1,'Operating-System','Vista Service Pack',4,1),(897,207380589022,1,'Operating-System','Windows Vista',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),(895,207380589022,1,'Operating-System','OS X Leopard Update',4,1),(895,207380589022,1,'Operating-System','OS X Version 10.5 (Leopard)',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),(896,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(896,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(896,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(897,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(898,207380589022,1,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(898,207380589022,1,'Operating-System','OS X Snow Leopard Update',4,1),(899,207380589022,1,'Operating-System','Windows Vista',4,1),(899,207380589022,1,'Operating-System','Vista Service Pack',4,1),(899,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(899,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(899,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(900,207380589022,1,'Operating-System','Windows 7 x64',4,1),(900,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(900,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(900,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(900,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',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 (896,207380589022,1,'creason.christina','Owner-PC','Windows (TM) Vista Home Premium 6.0 Service Pack 2','HCC-users',1270469075781,4,1,NULL),(894,207380589022,1,'greub.sarah','Paula-PC','Windows (TM) Vista Home Premium 6.0 Service Pack 2','HCC-users',1269981877189,4,1,NULL),(893,207380589022,1,'copeland.mashawn','reneacopeland','Windows 7 Ultimate 6.1','HCC-users',1269880075465,4,1,'Heritage-MDF1 30'),(892,207380589022,1,'tharman.laura','Laura-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 1','HCC-users',1269862286231,4,1,'Library-AP VLAN Registration'),(897,207380589022,1,'jordan.valeria','Jordan-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 1','HCC-users',1270502555131,4,1,NULL),(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'),(895,207380589022,1,'chess.glen','glen-chesss-macbook-pro','Mac OS X 10.5.8','HCC-users',1270465740303,4,1,NULL),(898,207380589022,1,'Barmby.Mallory','mallory-barmbys-computer','Mac OS X 10.6.3','HCC-users',1270593972756,4,1,NULL),(899,207380589022,1,'jones.jennifer01','ClioDale-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-users',1270860016759,4,1,NULL),(900,207380589022,1,'dunkin.matthew','owner-PC','Windows 7 Home Premium 6.1','HCC-users',1271010951662,4,1,NULL);
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 (5399,'DHCP_FINGERPRINT_CHANGED',8,2837,3,1270581379088,0,'227com.bsc.api.alarm.YamsAlarm131.2145399224DHCP_FINGERPRINT_CHANGED142837113213127058137908811015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host221com.bsc.api.NameValue131.0213ParameterList2121,3,67,43,60219java.util.ArrayList1117165413821220738058902215false',207380589022),(5401,'DHCP_FINGERPRINT_CHANGED',8,2837,3,1270667474171,0,'227com.bsc.api.alarm.YamsAlarm131.2145401224DHCP_FINGERPRINT_CHANGED142837113213127066747417111015false219java.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.ArrayList1117166185121220738058902215false',207380589022),(5412,'DHCP_FINGERPRINT_CHANGED',9,6818,3,1270775881014,0,'227com.bsc.api.alarm.YamsAlarm131.2145412224DHCP_FINGERPRINT_CHANGED 146818113213127077588101411015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC217F4:CE:46:54:64:04221com.bsc.api.NameValue131.014Host18HP546404221com.bsc.api.NameValue131.0213ParameterList2236,3,1,15,66,67,13,44,12219java.util.ArrayList1117167305121220738058902215false',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),(5378,'READ_CLIENTS_FAILURE',1,1643,1,1270573767216,0,'227com.bsc.api.alarm.YamsAlarm131.2145378220READ_CLIENTS_FAILURE141643111213127057376721611015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName213Enterprise AP219java.util.ArrayList1517165305617165306517165309217165321117173716521220738058902215false',207380589022),(5373,'READ_CLIENTS_FAILURE',1,1650,1,1270573491749,0,'227com.bsc.api.alarm.YamsAlarm131.2145373220READ_CLIENTS_FAILURE141650111213127057349174911015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName211Claymont AP219java.util.ArrayList1717165297217165307417165310317165314617165322517168672717168677721220738058902215false',207380589022),(5402,'DHCP_FINGERPRINT_CHANGED',8,2837,3,1270667521088,0,'227com.bsc.api.alarm.YamsAlarm131.2145402224DHCP_FINGERPRINT_CHANGED142837113213127066752108811015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host221com.bsc.api.NameValue131.0213ParameterList2121,3,67,43,60219java.util.ArrayList1117166186121220738058902215false',207380589022),(5398,'DHCP_FINGERPRINT_CHANGED',8,2837,3,1270581324682,0,'227com.bsc.api.alarm.YamsAlarm131.2145398224DHCP_FINGERPRINT_CHANGED142837113213127058132468211015false219java.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.ArrayList1117165412621220738058902215false',207380589022),(5371,'READ_CLIENTS_FAILURE',1,1653,1,1270573371552,0,'227com.bsc.api.alarm.YamsAlarm131.2145371220READ_CLIENTS_FAILURE141653111213127057337155211015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName210Rubeti1 AP219java.util.ArrayList1517165295417165296617165314317165325217168668121220738058902215false',207380589022),(5372,'READ_CLIENTS_FAILURE',1,1654,1,1270573462050,0,'227com.bsc.api.alarm.YamsAlarm131.2145372220READ_CLIENTS_FAILURE141654111213127057346205011015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName19Kansas AP219java.util.ArrayList21717165296317165297817165298317165304417165307217165310817165312017165313417165317417165318717165320417165324217165325817165327917165329317165330017168673621220738058902215false',207380589022),(5374,'READ_CLIENTS_FAILURE',1,1642,1,1270573513314,0,'227com.bsc.api.alarm.YamsAlarm131.2145374220READ_CLIENTS_FAILURE141642111213127057351331411015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName212Sunflower AP219java.util.ArrayList22217165297617165298217165302417165304517165305317165306117165307317165310217165311017165311317165313317165316517165318617165323417165324717165325317165326517165328217165329117165329617168660717168673721220738058902215false',207380589022),(5359,'READ_CLIENTS_FAILURE',1,1649,1,1270573021133,0,'227com.bsc.api.alarm.YamsAlarm131.2145359220READ_CLIENTS_FAILURE141649111213127057302113311015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName212Crestview AP219java.util.ArrayList1617165288617165319217168669217168677817169079017173417421220738058902215false',207380589022),(5360,'READ_CLIENTS_FAILURE',1,1655,1,1270573088581,0,'227com.bsc.api.alarm.YamsAlarm131.2145360220READ_CLIENTS_FAILURE141655111213127057308858111015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName18Piper AP219java.util.ArrayList21217165290017165298017165303417165305217165305817165307017165307917165310617165311117165313617165319317168668521220738058902215false',207380589022),(5361,'READ_CLIENTS_FAILURE',1,1644,1,1270573088613,0,'227com.bsc.api.alarm.YamsAlarm131.2145361220READ_CLIENTS_FAILURE141644111213127057308861311015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName210Hampton AP219java.util.ArrayList1517165290217165296517165297517165314417165329521220738058902215false',207380589022),(5358,'READ_CLIENTS_FAILURE',1,1641,1,1270572991092,0,'227com.bsc.api.alarm.YamsAlarm131.2145358220READ_CLIENTS_FAILURE141641111213127057299109211015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName211HollyOak AP219java.util.ArrayList1717165287817165299017165310517165314717165323117165324317165324921220738058902215false',207380589022),(5357,'READ_CLIENTS_FAILURE',1,1651,1,1270572941064,0,'227com.bsc.api.alarm.YamsAlarm131.2145357220READ_CLIENTS_FAILURE141651111213127057294106411015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName19Kiltie AP219java.util.ArrayList21617165287217165293117165298117165302717165304817165305517165306417165307517165310717165312117165313017165320717168668017168668717168679417173366321220738058902215false',207380589022),(5356,'READ_CLIENTS_FAILURE',1,1648,1,1270572907330,0,'227com.bsc.api.alarm.YamsAlarm131.2145356220READ_CLIENTS_FAILURE141648111213127057290733011015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName214CornerStone AP219java.util.ArrayList21217165286517165287117165290417165298917165313117165316217165318017165326317165328017165334317168669517168678221220738058902215false',207380589022),(5354,'CLIENT_INVALID_MAC',8,7173,1,1270572811494,0,'227com.bsc.api.alarm.YamsAlarm131.2145354218CLIENT_INVALID_MAC147173111213127057281149411015false219java.util.ArrayList13221com.bsc.api.NameValue131.0211ElementName21702:1A:80:FA:6F:16221com.bsc.api.NameValue131.013MAC21702:1A:80:FA:6F:16221com.bsc.api.NameValue131.018Location216Heritage-MDF1 40219java.util.ArrayList1117165285421220738058902215false',207380589022),(5355,'MULTI_CLIENTS_DETECTED',2,713,1,1270572811641,0,'227com.bsc.api.alarm.YamsAlarm131.2145355222MULTI_CLIENTS_DETECTED13713111213127057281164111015false219java.util.ArrayList14221com.bsc.api.NameValue131.0211ElementName213Heritage-MDF1221com.bsc.api.NameValue131.018PortName216Heritage-MDF1 40221com.bsc.api.NameValue131.017Clients112221com.bsc.api.NameValue131.014Macs23600:1A:80:FA:6F:16\n02:1A:80:FA:6F:16\n219java.util.ArrayList21317165285917165291417165306917165315617165316017165316917165317817165318517165319117165319817168676217168679617168679721220738058902215false',207380589022),(5350,'READ_CLIENTS_FAILURE',1,1646,1,1270533370962,0,'227com.bsc.api.alarm.YamsAlarm131.2145350220READ_CLIENTS_FAILURE141646111213127053337096211015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName210Rubeti6 AP219java.util.ArrayList22217164842817165293017165297117165297917165298817165302617165304717165307117165309317165310917165311217165313217165316417165318117165323517165324817165325917165327017165328317165329417165329817168668621220738058902215false',207380589022),(5351,'DHCP_FINGERPRINT_CHANGED',9,6658,3,1270553631510,0,'227com.bsc.api.alarm.YamsAlarm131.2145351224DHCP_FINGERPRINT_CHANGED 146658113213127055363151011015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:21:9B:47:32:A4221com.bsc.api.NameValue131.014Host17IT-0006221com.bsc.api.NameValue131.0213ParameterList2301,15,3,6,44,46,47,31,33,249,43219java.util.ArrayList1117165034421220738058902215false',207380589022),(5347,'CONTACT_LOST',1,1949,1,1270499495986,0,'227com.bsc.api.alarm.YamsAlarm131.2145347212CONTACT_LOST141949111213127049949598611015false219java.util.ArrayList12221com.bsc.api.NameValue131.018protocol14Snmp221com.bsc.api.NameValue131.017element15Perry219java.util.ArrayList1117164540421220738058902215false',207380589022),(5346,'DHCP_FINGERPRINT_CHANGED',8,2837,3,1270494849659,0,'227com.bsc.api.alarm.YamsAlarm131.2145346224DHCP_FINGERPRINT_CHANGED142837113213127049484965911015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host221com.bsc.api.NameValue131.0213ParameterList2121,3,67,43,60219java.util.ArrayList1117164480821220738058902215false',207380589022),(5345,'DHCP_FINGERPRINT_CHANGED',8,2837,3,1270494799101,0,'227com.bsc.api.alarm.YamsAlarm131.2145345224DHCP_FINGERPRINT_CHANGED142837113213127049479910111015false219java.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.ArrayList1117164478221220738058902215false',207380589022),(5344,'DHCP_FINGERPRINT_CHANGED',8,2837,3,1270474561630,0,'227com.bsc.api.alarm.YamsAlarm131.2145344224DHCP_FINGERPRINT_CHANGED142837113213127047456163011015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:16:CB:C9:4F:B7221com.bsc.api.NameValue131.014Host221com.bsc.api.NameValue131.0213ParameterList2121,3,67,43,60219java.util.ArrayList1117164257121220738058902215false',207380589022),(5343,'DHCP_FINGERPRINT_CHANGED',8,2837,3,1270474488645,0,'227com.bsc.api.alarm.YamsAlarm131.2145343224DHCP_FINGERPRINT_CHANGED142837113213127047448864511015false219java.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.ArrayList1117164256921220738058902215false',207380589022),(5342,'CLIENT_REGISTRATION_FAILURE',7,2,1,1270471501542,0,'227com.bsc.api.alarm.YamsAlarm131.2145342227CLIENT_REGISTRATION_FAILURE112111213127047150154211015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient238Registered Client Not Found Mcarpenter221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117164221121220738058902215false',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),(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),(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.ArrayList1217170565817170747821220738058902215false',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),(5341,'FREQUENCY_VIOLATION',7,2,1,1270466102738,0,'227com.bsc.api.alarm.YamsAlarm131.2145341219FREQUENCY_VIOLATION112111213127046610273811015false219java.util.ArrayList13221com.bsc.api.NameValue131.019Frequency113221com.bsc.api.NameValue131.017Seconds1290221com.bsc.api.NameValue131.014name16cparks219java.util.ArrayList1317164151917164153817164154521220738058902215false',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.ArrayList1417170184117171980917173717117174663821220738058902215false',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.ArrayList310017173633817173634317173634817173637917173642817173643417173643917173644617173645117173645617173646117173646617173647117173647617173648117173648617173649117173649817173652017173652917173658417173667917173682117173691517173699017173700917173702117173703217173704417173706317173743017173748317174040917174044217174045017174045517174046017174046817174048817174049317174049817174743617174744117174744617174745117174745617174746117174747017174754517174755117174758917174761917174763117174769817174774017174778117174784917174785517174786117174786617174787117174787617174788117174788617174789117174790417174792417174792917174793417174794517174795017174795517174798017174828217174828817174830817174831617174832117174832617174833117174833617174834117174834617174835117174835617174836817174838317174847217174847817174851417174857217174859017174870317174876217174879517174880617174889317174897317174897917174902221220738058902215false',207380589022),(5340,'DHCP_FINGERPRINT_CHANGED',8,5603,3,1270465515801,0,'227com.bsc.api.alarm.YamsAlarm131.2145340224DHCP_FINGERPRINT_CHANGED145603113213127046551580111015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC21700:1D:4F:19:BB:21221com.bsc.api.NameValue131.014Host221com.bsc.api.NameValue131.0213ParameterList2281,3,6,15,119,95,252,44,46,47219java.util.ArrayList1117164139221220738058902215false',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),(5437,'READ_CLIENTS_FAILURE',1,2079,1,1270984520274,0,'227com.bsc.api.alarm.YamsAlarm131.2145437220READ_CLIENTS_FAILURE142079111213127098452027411015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName213Enterprise AP219java.util.ArrayList1317168766017170986217173954121220738058902215false',207380589022),(5438,'READ_CLIENTS_FAILURE',1,2082,1,1270988704679,0,'227com.bsc.api.alarm.YamsAlarm131.2145438220READ_CLIENTS_FAILURE142082111213127098870467911015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName213Enterprise AP219java.util.ArrayList1117168785221220738058902215false',207380589022),(5439,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271024641301,0,'227com.bsc.api.alarm.YamsAlarm131.2145439227CLIENT_REGISTRATION_FAILURE112111213127102464130111015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient236Authentication Failure Larney.joshua221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117168998321220738058902215false',207380589022),(5413,'DHCP_FINGERPRINT_CHANGED',9,6818,3,1270776181038,0,'227com.bsc.api.alarm.YamsAlarm131.2145413224DHCP_FINGERPRINT_CHANGED 146818113213127077618103811015false219java.util.ArrayList13221com.bsc.api.NameValue131.013MAC217F4:CE:46:54:64:04221com.bsc.api.NameValue131.014Host18HP546404221com.bsc.api.NameValue131.0213ParameterList2236,3,1,15,66,67,13,44,12219java.util.ArrayList1117167310921220738058902215false',207380589022),(5408,'CLIENT_INVALID_MAC',8,7226,1,1270753869486,0,'227com.bsc.api.alarm.YamsAlarm131.2145408218CLIENT_INVALID_MAC147226111213127075386948611015false219java.util.ArrayList13221com.bsc.api.NameValue131.0211ElementName217E1:6C:D6:AE:52:90221com.bsc.api.NameValue131.013MAC217E1:6C:D6:AE:52:90221com.bsc.api.NameValue131.018Location219java.util.ArrayList1117167074421220738058902215false',207380589022),(5407,'CONTACT_LOST',1,1927,1,1270753175504,0,'227com.bsc.api.alarm.YamsAlarm131.2145407212CONTACT_LOST141927111213127075317550411015false219java.util.ArrayList12221com.bsc.api.NameValue131.018protocol14Snmp221com.bsc.api.NameValue131.017element213198.248.75.66219java.util.ArrayList1117167058521220738058902215false',207380589022),(5406,'READ_CLIENTS_FAILURE',1,2192,1,1270688992522,0,'227com.bsc.api.alarm.YamsAlarm131.2145406220READ_CLIENTS_FAILURE142192111213127068899252211015false219java.util.ArrayList11221com.bsc.api.NameValue131.0211ElementName19ArtDeptHP219java.util.ArrayList22117166467317170268517170385017170491817170607417170706417170810217170922617170922817171021517171131317171242817171353817171453917171600617171702517171788817172561417172632017172714617172813321220738058902215false',207380589022),(5417,'CLIENT_REGISTRATION_FAILURE',7,2,1,1270946295942,0,'227com.bsc.api.alarm.YamsAlarm131.2145417227CLIENT_REGISTRATION_FAILURE112111213127094629594211015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient236Authentication Failure currie.joshua221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117168619121220738058902215false',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),(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.ArrayList1117173868321220738058902215false',207380589022),(5440,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271043380602,0,'227com.bsc.api.alarm.YamsAlarm131.2145440227CLIENT_REGISTRATION_FAILURE112111213127104338060211015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient236Authentication Failure danielson.lan221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117169146521220738058902215false',207380589022),(5441,'CLIENT_REGISTRATION_FAILURE',7,2,1,1271043528135,0,'227com.bsc.api.alarm.YamsAlarm131.2145441227CLIENT_REGISTRATION_FAILURE112111213127104352813511015false219java.util.ArrayList12221com.bsc.api.NameValue131.0214RegisterClient236Authentication Failure danielson.lan221com.bsc.api.NameValue131.019IPAddress17Unknown219java.util.ArrayList1117169147221220738058902215false',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 */;