/*!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 (2078,207380589022,'78:92:9C:62:EC:5E','Intel(R) Centrino(R) Wireless-N 100',1,'192.168.101.210'),(2073,207380589022,'00:23:15:4B:DE:34','Intel(R) Centrino(R) Advanced-N 6250 AGN #2',1,'192.168.101.214'),(2073,207380589022,'00:23:15:4B:DE:35','Microsoft Virtual WiFi Miniport Adapter #4',1,NULL),(2073,207380589022,'20:CF:30:75:10:FF','Atheros AR8131 PCI-E Gigabit Ethernet Controller (NDIS 6.20) #5',1,NULL),(2073,207380589022,'64:D4:DA:05:D8:9E','Intel(R) Centrino(R) WiMAX 6250',1,NULL),(2074,207380589022,'78:92:9C:22:9B:56','Intel(R) Centrino(R) Wireless-N 100',1,'192.168.101.86'),(2074,207380589022,'14:DA:E9:BD:A1:F8','Realtek PCIe GBE Family Controller',1,NULL),(2074,207380589022,'78:92:9C:22:9B:57','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(2075,207380589022,'E4:D5:3D:79:8E:76','Killer Wireless-N 1103 Network Adapter',1,'192.168.101.205'),(2075,207380589022,'D4:BE:D9:0A:B7:9E','Atheros AR8151 PCI-E Gigabit Ethernet Controller (NDIS 6.20)',1,NULL),(2076,207380589022,'70:F1:A1:38:BB:96','Realtek RTL8191SE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.219'),(2077,207380589022,'D0:DF:9A:17:FF:F1','Bluetooth Device (Personal Area Network)',1,NULL),(2077,207380589022,'2C:27:D7:02:A0:2B','Realtek PCIe FE Family Controller',1,NULL),(2076,207380589022,'00:26:6C:68:89:E0','Realtek PCIe FE Family Controller',1,NULL),(2077,207380589022,'D0:DF:9A:17:9E:49','Atheros AR9285 802.11b/g/n WiFi Adapter',1,'192.168.101.33'),(2069,207380589022,'00:40:45:2D:55:CA','Realtek RTL8139/810x Family Fast Ethernet NIC',1,NULL),(2063,207380589022,'C8:0A:A9:DC:C1:32','Atheros AR8152 PCI-E Fast Ethernet Controller',1,NULL),(2064,207380589022,'B8:70:F4:A9:79:62','Atheros AR8152/8158 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,'192.168.101.154'),(2064,207380589022,'D0:DF:9A:65:7C:69','Atheros AR5B95 Wireless Network Adapter',1,'169.254.79.7'),(2065,207380589022,'00:22:5F:EA:4E:39','Atheros AR5B91 Wireless Network Adapter',1,'192.168.101.95'),(2065,207380589022,'00:1F:16:B3:9C:BA','Broadcom NetLink (TM) Gigabit Ethernet',1,NULL),(2066,207380589022,'74:2F:68:56:7F:F3','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.68'),(2066,207380589022,'14:DA:E9:AF:06:88','Realtek PCIe GBE Family Controller',1,NULL),(2067,207380589022,'00:1F:E1:18:64:F5','Broadcom 802.11g Network Adapter',1,'192.168.101.45'),(2067,207380589022,'00:1E:EC:41:F4:CC','Broadcom 590x 10/100 Ethernet',1,NULL),(2068,207380589022,'74:DE:2B:3F:20:5F','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.192'),(2068,207380589022,'B8:70:F4:42:D4:55','Atheros AR8152 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(2072,207380589022,'BC:77:37:D5:5B:FC','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(2072,207380589022,'14:FE:B5:B5:87:71','Realtek PCIe FE Family Controller',1,NULL),(2072,207380589022,'BC:77:37:D5:5B:FB','Intel(R) Centrino(R) Wireless-N 1030',1,'192.168.101.14'),(2071,207380589022,'F0:4D:A2:C8:99:E6','Atheros AR8152 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(2070,207380589022,'68:A8:6D:3A:96:E2','en1',1,'192.168.101.115'),(2071,207380589022,'00:1B:B1:EC:19:31','Atheros AR9285 802.11b/g/n WiFi Adapter',1,'192.168.101.70'),(2057,207380589022,'00:22:FA:ED:F8:66','Intel(R) WiFi Link 5100 AGN - Packet Scheduler Miniport',1,'198.248.75.231'),(2069,207380589022,'00:19:DB:07:B1:79','802.11g Mini Card Wireless Adapter',1,'192.168.101.16'),(2058,207380589022,'D0:DF:9A:E4:92:91','Realtek RTL8188CE 802.11b/g/n WiFi Adapter',1,'192.168.101.246'),(2070,207380589022,'3C:07:54:5D:4F:54','en0',1,'192.168.101.188'),(2061,207380589022,'C4:2C:03:14:46:63','en0',1,NULL),(2061,207380589022,'58:B0:35:9D:B0:A0','en2',1,NULL),(2060,207380589022,'3C:07:54:4E:9C:68','en0',1,NULL),(2061,207380589022,'D8:A2:5E:8C:16:96','en1',1,'192.168.101.212'),(2060,207380589022,'B8:8D:12:35:85:9E','en1',1,'192.168.101.196'),(2059,207380589022,'2C:76:8A:E2:A7:10','Realtek PCIe FE Family Controller',1,NULL),(2058,207380589022,'2C:76:8A:D9:3C:CD','Realtek PCIe FE Family Controller',1,NULL),(2059,207380589022,'D0:DF:9A:F4:CA:51','Realtek RTL8188CE 802.11b/g/n WiFi Adapter',1,'192.168.101.98'),(2056,207380589022,'00:23:8B:F3:2F:CF','Realtek RTL8102E Family PCI-E Fast Ethernet NIC (NDIS 6.0)',1,NULL),(2056,207380589022,'00:26:5E:0D:60:EA','Broadcom 802.11b/g WLAN',1,'192.168.101.35'),(2087,207380589022,'38:59:F9:0A:EC:52','Atheros AR5B95 Wireless Network Adapter',1,'192.168.101.117'),(2086,207380589022,'E8:9A:8F:4B:CA:37','Realtek PCIe FE Family Controller',1,NULL),(2086,207380589022,'CC:AF:78:46:1B:52','Atheros AR5B95 Wireless Network Adapter',1,'192.168.101.29'),(2063,207380589022,'20:7C:8F:21:57:81','Realtek RTL8191SE Wireless LAN 802.11n PCI-E NIC',1,'198.248.77.55'),(2062,207380589022,'00:1D:E0:3F:80:53','Intel(R) Wireless WiFi Link 4965AGN',1,'198.248.76.154'),(2062,207380589022,'00:1E:68:71:7A:E5','Realtek RTL8168B/8111B Family PCI-E GBE NIC',1,NULL),(2078,207380589022,'E8:9A:8F:E5:32:92','Realtek PCIe FE Family Controller',1,NULL),(2079,207380589022,'00:25:D3:BF:67:AE','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.200'),(2079,207380589022,'90:E6:BA:94:9C:8E','Atheros AR8121/AR8113/AR8114 PCI-E Ethernet Controller',1,NULL),(2080,207380589022,'EC:55:F9:9D:40:2E','DW1520 Wireless-N WLAN Half-Mini Card',1,'192.168.101.163'),(2080,207380589022,'5C:26:0A:50:09:93','Atheros AR8132 PCI-E Fast Ethernet Controller',1,NULL),(2081,207380589022,'00:04:23:6E:5A:04','Intel(R) PRO/Wireless 2100 LAN 3B Mini PCI Adapter - Packet Scheduler Miniport',1,'192.168.101.211'),(2081,207380589022,'00:A0:D1:D6:A3:8B','Intel(R) PRO/100 VE Network Connection - Packet Scheduler Miniport',1,NULL),(2082,207380589022,'C0:CB:38:2A:11:CA','Broadcom 4313 802.11b/g/n',1,'192.168.101.187'),(2083,207380589022,'D0:DF:9A:98:C0:15','Atheros AR5B97 Wireless Network Adapter',1,'192.168.101.237'),(2083,207380589022,'B8:70:F4:B3:44:6A','Atheros AR8151 PCI-E Gigabit Ethernet Controller (NDIS 6.20)',1,NULL),(2084,207380589022,'D0:DF:9A:0A:87:4A','Realtek RTL8188CE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.118'),(2084,207380589022,'00:26:6C:C3:C6:D6','Atheros AR8152/8158 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(2085,207380589022,'88:53:2E:5F:00:C8','Intel(R) Centrino(R) Advanced-N 6230',1,'192.168.101.246'),(2085,207380589022,'88:53:2E:5F:00:C9','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(2085,207380589022,'E8:11:32:92:D4:9E','Realtek PCIe GBE Family Controller',1,NULL),(2087,207380589022,'E8:9A:8F:6D:60:82','Atheros AR8152/8158 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(2088,207380589022,'C4:17:FE:92:37:F7','Broadcom 802.11g Network Adapter',1,'192.168.101.151'),(2088,207380589022,'70:5A:B6:29:0D:77','Atheros AR8132 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(2089,207380589022,'00:25:4B:8C:23:D0','en1',1,'198.248.78.120'),(2089,207380589022,'00:25:4B:AB:F1:18','en0',1,NULL),(2090,207380589022,'00:22:68:8F:3B:DB','Atheros AR9285 802.11b/g/n WiFi Adapter',1,'192.168.101.137'),(2090,207380589022,'00:26:9E:55:1B:89','Realtek PCIe FE Family Controller',1,NULL),(2091,207380589022,'78:E4:00:F2:86:BC','Atheros AR9285 802.11b/g/n WiFi Adapter',1,'192.168.101.143'),(2091,207380589022,'C8:0A:A9:B5:41:69','Realtek PCIe FE Family Controller',1,NULL),(2092,207380589022,'F0:B4:79:1D:8B:38','en1',1,'192.168.101.113'),(2092,207380589022,'10:9A:DD:4C:E3:6C','en0',1,NULL),(2092,207380589022,'F0:B4:79:0F:DD:6A','en2',1,NULL),(2093,207380589022,'7C:4F:B5:F5:FA:E6','Realtek RTL8188CE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.21'),(2093,207380589022,'B8:70:F4:C5:A2:9D','Realtek PCIe FE Family Controller',1,NULL),(2094,207380589022,'B4:82:FE:C9:20:19','Realtek RTL8191SE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.27'),(2094,207380589022,'00:26:6C:6D:DF:99','Realtek PCIe FE Family Controller',1,NULL),(2095,207380589022,'8C:A9:82:95:55:9E','Intel(R) WiFi Link 1000 BGN',1,'192.168.101.66'),(2095,207380589022,'2C:27:D7:BC:44:BD','Realtek PCIe GBE Family Controller',1,NULL),(2095,207380589022,'8C:A9:82:95:55:9F','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(2096,207380589022,'C4:17:FE:B9:00:70','Broadcom 802.11n Network Adapter',1,'192.168.101.228'),(2096,207380589022,'70:5A:B6:DB:1A:83','Broadcom NetLink (TM) Gigabit Ethernet',1,NULL),(2097,207380589022,'00:21:6B:1C:0A:BE','Intel(R) Wireless WiFi Link 5100',1,'192.168.101.40'),(2097,207380589022,'00:1E:33:72:40:81','Realtek PCIe FE Family Controller',1,NULL),(2098,207380589022,'00:22:FB:64:59:C8','Intel(R) WiFi Link 5100 AGN',1,'198.248.78.125'),(2098,207380589022,'00:26:9E:0C:63:4F','Atheros AR8131 PCI-E Gigabit Ethernet Controller',1,NULL),(2099,207380589022,'00:11:24:9D:CD:7D','en1',1,'192.168.101.165'),(2099,207380589022,'00:14:51:06:4F:E8','en0',1,NULL),(2100,207380589022,'88:9F:FA:1B:91:E5','Broadcom 802.11n Network Adapter',1,'192.168.101.96'),(2100,207380589022,'1C:75:08:C1:64:C7','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 (2077,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2077,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2076,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2076,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2076,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2076,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2076,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2075,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2075,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2075,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2075,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2075,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2074,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2074,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2074,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2072,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2072,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2074,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2074,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2073,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2073,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2073,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2073,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2073,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2072,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2067,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(2067,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(2067,207380589022,1,'Operating-System','Vista Service Pack',4,1),(2066,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2066,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2067,207380589022,1,'Operating-System','Windows Vista',4,1),(2066,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2066,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2066,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2065,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(2065,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(2065,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(2065,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(2065,207380589022,1,'Operating-System','Windows Vista x64',4,1),(2064,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2063,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2063,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2063,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2063,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2063,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2064,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2064,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2064,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2064,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2072,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2072,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2071,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2071,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2071,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2071,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2071,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2070,207380589022,2,'Operating-System','OS X Snow Leopard Update',4,1),(2070,207380589022,2,'Operating-System','OS X Leopard Update',4,1),(2070,207380589022,2,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(2070,207380589022,2,'Operating-System','OS X Version 10.5 (Leopard)',4,1),(2070,207380589022,2,'Operating-System','OS X Tiger Update',4,1),(2069,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(2070,207380589022,2,'Operating-System','OS X Version 10.4 (Tiger)',4,1),(2069,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(2069,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(2069,207380589022,1,'Operating-System','Vista Service Pack',4,1),(2058,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2058,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2058,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2058,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2057,207380589022,1,'Operating-System','Windows XP',4,1),(2057,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(2057,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(2057,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(2069,207380589022,1,'Operating-System','Windows Vista',4,1),(2068,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2068,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2068,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2068,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2068,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2067,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(2061,207380589022,1,'Operating-System','OS X Snow Leopard Update',4,1),(2061,207380589022,1,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(2060,207380589022,2,'Operating-System','OS X Snow Leopard Update',4,1),(2060,207380589022,2,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(2060,207380589022,2,'Operating-System','OS X Leopard Update',4,1),(2060,207380589022,2,'Operating-System','OS X Version 10.5 (Leopard)',4,1),(2060,207380589022,2,'Operating-System','OS X Tiger Update',4,1),(2060,207380589022,2,'Operating-System','OS X Version 10.4 (Tiger)',4,1),(2059,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2059,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2059,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2059,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2059,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2058,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2056,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(2056,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(2056,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(2056,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(2056,207380589022,1,'Operating-System','Windows Vista x64',4,1),(2087,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2086,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(2086,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(2086,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(2086,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(2062,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(2086,207380589022,1,'Operating-System','Windows 7',4,1),(2062,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(2062,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(2062,207380589022,1,'Operating-System','Vista Service Pack',4,1),(2062,207380589022,1,'Operating-System','Windows Vista',4,1),(2077,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2077,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2077,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2078,207380589022,1,'Operating-System','Windows 7',4,1),(2078,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(2078,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(2078,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(2078,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(2079,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2079,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2079,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2079,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2079,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2080,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2080,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2080,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2080,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2080,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2081,207380589022,1,'Operating-System','Windows XP',4,1),(2081,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(2081,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(2081,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(2082,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2082,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2082,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2082,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2082,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2083,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2083,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2083,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2083,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2083,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2084,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2084,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2084,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2084,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2084,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2085,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2085,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2085,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2085,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2085,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2087,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2087,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2087,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2087,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2088,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2088,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2088,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2088,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2088,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2089,207380589022,1,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(2089,207380589022,1,'Operating-System','OS X Snow Leopard Update',4,1),(2090,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2090,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2090,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2090,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2090,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2091,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2091,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2091,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2091,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2091,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2092,207380589022,1,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(2092,207380589022,1,'Operating-System','OS X Snow Leopard Update',4,1),(2093,207380589022,1,'Operating-System','Windows 7',4,1),(2093,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(2093,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(2093,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(2093,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(2094,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2094,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2094,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2094,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2094,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2095,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2095,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2095,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2095,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2095,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2096,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2096,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2096,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2096,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2096,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(2097,207380589022,1,'Operating-System','Windows Vista x64',4,1),(2097,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(2097,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(2097,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(2097,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(2098,207380589022,1,'Operating-System','Windows Vista',4,1),(2098,207380589022,1,'Operating-System','Vista Service Pack',4,1),(2098,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(2098,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(2098,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(2099,207380589022,1,'Operating-System','OS X Version 10.5 (Leopard)',4,1),(2099,207380589022,1,'Operating-System','OS X Leopard Update',4,1),(2100,207380589022,1,'Operating-System','Windows 7 x64',4,1),(2100,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(2100,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(2100,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(2100,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 (2077,207380589022,1,'larrison.daniel','daniels_toy','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1326051031348,4,1,'Highlander AP VLAN Registration'),(2075,207380589022,1,'Harden.clinton','Clint-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1326015118308,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2076,207380589022,1,'Houston.Tyler','SandMComputerV2','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1326044716116,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2074,207380589022,1,'adams.hunter','Hunter-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1326014407678,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2073,207380589022,1,'mccarter.zachary','Zachary-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1326014083994,4,1,'Degginger AP VLAN Registration'),(2071,207380589022,1,'Capps.Michael','Michael-PC','Windows 7 Home Premium 6.1','HCC-Users',1326003679924,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2069,207380589022,1,'edwards.demetrius','Owner-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-Users',1326001043426,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2070,207380589022,2,'stanton.andrew','Drews-MacBook-Pro','Mac OS X 10.7.2','HCC-Users',1326001720112,4,1,'Piper-MDF1 13'),(2064,207380589022,1,'Rohnke.Derek','Rohnke-1-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1325736222306,4,1,'ScottiePlace-MDF1 12'),(2065,207380589022,1,'walker.antonio','Jessica-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-Users',1325823369940,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2066,207380589022,1,'horigan.kelly','KellyAnn-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1325971988514,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2067,207380589022,1,'hawkins.skylar','S-PC','Windows Vista (TM) Home Basic 6.0 Service Pack 1','HCC-Users',1325993171782,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2068,207380589022,1,'everett.deandre','Owner-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1325996606264,4,1,'Highlander AP VLAN Registration'),(2061,207380589022,1,'mayer.gannon','Gannon-Mayers-MacBook-Pro','Mac OS X 10.6.8','HCC-Users',1325237280892,4,1,'Huntington AP VLAN Registration'),(2072,207380589022,1,'cheatom.james','Bizzie-PC','Windows 7 Home Premium 6.1','HCC-Users',1326008012518,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2057,207380589022,1,'dpeters','HOL-0012','Microsoft Windows XP 5.1 Service Pack 3','HCC-Users',1324939132083,4,1,NULL),(2058,207380589022,1,'nightingale.jerell','jerellLauren','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1325046017293,4,1,'Highlander AP VLAN Registration'),(2059,207380589022,1,'nightingale.gale','galenightingale','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1325064362944,4,1,'Highlander AP VLAN Registration'),(2060,207380589022,2,'blaser.randi','randis-MacBook-Pro','Mac OS X 10.7.2','HCC-Users',1325105585720,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2086,207380589022,1,'thomas.kathryn','sheranThomas-PC','Windows 7 Starter 6.1 Service Pack 1','HCC-Users',1326094538035,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2056,207380589022,1,'zeit.bethani','bethani-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-Users',1324588077614,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2062,207380589022,1,'rkarn','Russell-Mobile','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-Users',1325639309292,4,1,NULL),(2063,207380589022,1,'gallegoskoons.kathle','Kathy-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1325728640579,4,1,NULL),(2078,207380589022,1,'tisdel.jeremy','snagz11-PC','Windows 7 Starter 6.1 Service Pack 1','HCC-Users',1326055168055,4,1,'Degginger AP VLAN Registration'),(2079,207380589022,1,'Norris.Caylor','Duffy-PC','Windows 7 Home Premium 6.1','HCC-Users',1326062234521,4,1,'Hearthford AP VLAN Registration'),(2080,207380589022,1,'Ramsay.Nathan','alienware-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1326068212381,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2081,207380589022,1,'Garvin.Aniqueia','OGDRMLABSL1','Microsoft Windows XP 5.1 Service Pack 3','HCC-Users',1326073603522,4,1,'Hampton AP VLAN Registration'),(2082,207380589022,1,'griffiths.molly','Molly-HP','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1326073889836,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2083,207380589022,1,'norful.bobby','kimber-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1326076797366,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2084,207380589022,1,'Zimmer.James','James-PC','Windows 7 Professional 6.1 Service Pack 1','HCC-Users',1326082161032,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2085,207380589022,1,'potter.allison','Andrew-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1326083071719,4,1,'ColonyPoint AP VLAN Registration'),(2087,207380589022,1,'white.kyle','owner-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1326109798795,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2088,207380589022,1,'wheat.alex','Wheat-PC','Windows 7 Home Premium 6.1','HCC-Users',1326134084338,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2089,207380589022,1,'jrushing','ct109-0014','Mac OS X 10.6.8','HCC-Users',1326151020812,4,1,NULL),(2090,207380589022,1,'mcnutt.coty','Ina-PC','Windows 7 Home Premium 6.1','HCC-Users',1326161388142,4,1,'Crestview AP VLAN Registration'),(2091,207380589022,1,'Norris.Brett','Owner-PC','Windows 7 Home Premium 6.1','HCC-Users',1326164243318,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2092,207380589022,1,'medina.kody','Adrian-goldens-MacBook-Pro','Mac OS X 10.6.6','HCC-Users',1326168789790,4,1,'Rubeti6 AP VLAN Registration'),(2093,207380589022,1,'Nance.Aris','Aris-PC','Windows 7 Starter 6.1 Service Pack 1','HCC-Users',1326173691710,4,1,'Highlander AP VLAN Registration'),(2094,207380589022,1,'Knott.Matthew','Matt-PC','Windows 7 Home Premium 6.1','HCC-Users',1326227070280,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2095,207380589022,1,'shaffer.taylor','Tshaff-HP','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1326234861239,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2096,207380589022,1,'Lambrecht.Cody','Cody-PC','Windows 7 Home Premium 6.1','HCC-Users',1326240524598,4,1,'Rubeti6 AP VLAN Registration'),(2097,207380589022,1,'Hoskins.Ambrose','dorothy-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-Users',1326263080688,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2098,207380589022,1,'glover.devonta','TayWright-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-Users',1326312993189,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2099,207380589022,1,'gray.shane','shane-ibook-g4','Mac OS X 10.5.8','HCC-Users',1326394883768,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(2100,207380589022,1,'Gibson.taryn','DavidFulcherJr','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1326447587182,4,1,'MSM760.Highland.cc.ks.us VLAN 30');
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 */;