/*!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 (1947,207380589022,'78:E4:00:B7:AD:14','Broadcom 802.11n Network Adapter',1,'169.254.48.196'),(1947,207380589022,'70:5A:B6:FA:B1:94','Atheros AR8132 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,'164.113.45.105'),(1946,207380589022,'E8:39:DF:45:6D:F7','Bluetooth Device (Personal Area Network)',1,NULL),(1946,207380589022,'4C:0F:6E:48:A1:05','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.27'),(1946,207380589022,'8C:73:6E:A9:51:1B','Realtek PCIe GBE Family Controller',1,NULL),(1945,207380589022,'B8:AC:6F:6F:C1:C1','Realtek PCIe GBE Family Controller',1,NULL),(1945,207380589022,'00:23:14:86:8A:D5','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(1945,207380589022,'00:23:14:86:8A:D4','Intel(R) Centrino(R) Advanced-N 6200 AGN',1,'192.168.101.65'),(1944,207380589022,'BC:77:37:C0:B3:62','Bluetooth Device (Personal Area Network)',1,NULL),(1944,207380589022,'BC:77:37:C0:B3:5F','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(1944,207380589022,'BC:77:37:C0:B3:5E','Intel(R) Centrino(R) Wireless-N 1030',1,'192.168.101.117'),(1944,207380589022,'18:03:73:5D:FA:3F','Realtek PCIe FE Family Controller',1,NULL),(1942,207380589022,'00:22:41:1F:03:E4','en0',1,NULL),(1943,207380589022,'70:F3:95:B2:EF:64','Broadcom 4313 802.11b/g/n',1,'192.168.101.172'),(1943,207380589022,'70:F3:95:D4:E2:19','Bluetooth Device (Personal Area Network)',1,NULL),(1942,207380589022,'00:21:E9:D9:78:2C','en1',1,'192.168.101.160'),(1941,207380589022,'70:5A:B6:6A:83:4E','Broadcom NetLink (TM) Fast Ethernet',1,NULL),(1941,207380589022,'00:26:82:82:66:DB','Broadcom 802.11g Network Adapter',1,'192.168.101.67'),(1940,207380589022,'00:25:64:69:11:20','Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller',1,NULL),(1940,207380589022,'70:1A:04:5E:71:8B','Dell Wireless 1397 WLAN Mini-Card',1,'198.248.77.204'),(1939,207380589022,'00:26:22:E1:F2:EE','Atheros AR8132 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(1938,207380589022,'00:1D:09:AF:7D:D5','Broadcom 440x 10/100 Integrated Controller',1,NULL),(1939,207380589022,'90:4C:E5:8D:58:A2','Atheros AR5B93 Wireless Network Adapter',1,'198.248.76.44'),(1938,207380589022,'00:1E:4C:4B:32:00','Dell Wireless 1390 WLAN Mini-Card',1,'192.168.101.204'),(1937,207380589022,'10:1F:74:C2:20:20','Realtek PCIe FE Family Controller',1,NULL),(1936,207380589022,'00:1D:09:A7:3F:28','Broadcom 440x 10/100 Integrated Controller',1,NULL),(1937,207380589022,'AC:81:12:A5:B9:99','Realtek RTL8188CE 802.11b/g/n WiFi Adapter',1,'192.168.101.182'),(1936,207380589022,'00:1D:E0:50:D0:67','Intel(R) Wireless WiFi Link 4965AGN',1,'192.168.101.44'),(1935,207380589022,'70:F1:A1:A6:F9:B9','802.11n Wireless LAN Card',1,'192.168.101.244'),(1935,207380589022,'70:F1:A1:A6:F9:B8','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(1935,207380589022,'1C:C1:DE:50:95:2A','Realtek PCIe GBE Family Controller',1,'192.168.101.250'),(1932,207380589022,'88:AE:1D:0C:22:F1','Atheros AR8132 PCI-E Fast Ethernet Controller',1,NULL),(1932,207380589022,'78:E4:00:FC:89:36','Atheros AR5B93 Wireless Network Adapter',1,'198.248.78.65'),(1931,207380589022,'2C:27:D7:AF:A9:EB','Realtek PCIe GBE Family Controller',1,NULL),(1930,207380589022,'3C:D9:2B:27:50:C4','Realtek PCIe FE Family Controller',1,NULL),(1931,207380589022,'D0:DF:9A:29:68:53','Ralink RT5390 802.11b/g/n WiFi Adapter',1,'192.168.101.176'),(1930,207380589022,'68:A3:C4:FF:17:8F','Realtek RTL8188CE 802.11b/g/n WiFi Adapter',1,'192.168.101.90'),(1929,207380589022,'98:4B:E1:9D:8F:8A','Realtek PCIe FE Family Controller',1,NULL),(1928,207380589022,'00:26:18:A5:DC:99','Atheros AR8132 PCI-E Fast Ethernet Controller - Packet Scheduler Miniport',1,NULL),(1929,207380589022,'68:A3:C4:0C:00:90','Realtek RTL8191SE 802.11b/g/n WiFi Adapter',1,'192.168.101.249'),(1928,207380589022,'00:25:D3:5F:9D:0A','Atheros AR9285 Wireless Network Adapter - Packet Scheduler Miniport',1,'192.168.101.65'),(1927,207380589022,'68:A3:C4:A4:BD:3F','Realtek RTL8188CE 802.11b/g/n WiFi Adapter',1,'192.168.101.117'),(1927,207380589022,'9C:8E:99:38:B8:69','Realtek PCIe FE Family Controller',1,NULL),(1926,207380589022,'1C:65:9D:17:A6:9F','Realtek RTL8191SE 802.11b/g/n WiFi Adapter',1,'169.254.97.61'),(1925,207380589022,'C8:0A:A9:DC:C1:32','Atheros AR8152 PCI-E Fast Ethernet Controller',1,NULL),(1926,207380589022,'60:EB:69:0D:A9:9F','Realtek PCIe FE Family Controller',1,'192.168.101.225'),(1925,207380589022,'20:7C:8F:21:57:81','Realtek RTL8191SE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.42'),(1924,207380589022,'B8:AC:6F:6A:AC:B7','Realtek PCIe GBE Family Controller',1,NULL),(1924,207380589022,'C4:46:19:EE:E5:CC','Bluetooth Device (Personal Area Network)',1,NULL),(1924,207380589022,'00:1D:E1:33:AE:FB','Intel(R) Centrino(R) WiMAX 6250',1,NULL),(1924,207380589022,'00:23:15:2A:76:0D','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(1924,207380589022,'00:23:15:2A:76:0C','Intel(R) Centrino(R) Advanced-N 6250 AGN',1,'192.168.101.121'),(1963,207380589022,'00:26:6C:C7:4E:97','Atheros AR8152/8158 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(1963,207380589022,'B4:74:9F:B8:6E:76','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.144'),(1962,207380589022,'C4:17:FE:AB:AE:23','Atheros AR5B93 Wireless Network Adapter',1,'192.168.101.169'),(1962,207380589022,'00:26:2D:7E:5A:28','Broadcom NetLink (TM) Gigabit Ethernet',1,NULL),(1961,207380589022,'B8:70:F4:DD:2E:41','Broadcom NetLink (TM) Ethernet',1,NULL),(1961,207380589022,'38:59:F9:23:3C:67','Atheros AR5B95 Wireless Network Adapter',1,'192.168.101.211'),(1960,207380589022,'00:1E:33:96:F3:37','Realtek PCIe FE Family Controller',1,NULL),(1960,207380589022,'00:21:63:FC:59:61','Atheros AR5007EG Wireless Network Adapter',1,'192.168.101.149'),(1959,207380589022,'D0:DF:9A:43:E7:2F','Realtek RTL8188CE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.233'),(1959,207380589022,'00:26:6C:CC:12:55','Atheros AR8152/8158 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(1958,207380589022,'D0:DF:9A:7F:05:C1','Realtek RTL8188CE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.244'),(1958,207380589022,'E8:9A:8F:88:65:A5','Atheros AR8152/8158 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(1957,207380589022,'BC:77:37:C0:43:69','Bluetooth Device (Personal Area Network)',1,NULL),(1957,207380589022,'18:03:73:5D:F2:4B','Realtek PCIe FE Family Controller',1,NULL),(1957,207380589022,'BC:77:37:C0:43:66','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(1956,207380589022,'E8:9A:8F:5D:90:D2','Atheros AR8152/8158 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(1957,207380589022,'BC:77:37:C0:43:65','Intel(R) Centrino(R) Wireless-N 1030',1,'192.168.101.2'),(1956,207380589022,'D0:DF:9A:20:51:5E','Realtek RTL8188CE Wireless LAN 802.11n PCI-E NIC',1,'192.168.101.222'),(1955,207380589022,'00:1B:B1:89:CE:07','Atheros AR9285 802.11b/g/n WiFi Adapter',1,'192.168.101.41'),(1955,207380589022,'F0:4D:A2:C2:59:E9','Atheros AR8152 PCI-E Fast Ethernet Controller (NDIS 6.20)',1,NULL),(1954,207380589022,'BC:77:37:C0:B8:FD','Bluetooth Device (Personal Area Network)',1,NULL),(1954,207380589022,'18:03:73:5E:DA:15','Realtek PCIe FE Family Controller',1,NULL),(1954,207380589022,'BC:77:37:C0:B8:FA','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(1953,207380589022,'00:25:4B:8B:03:68','en1',1,'198.248.78.81'),(1953,207380589022,'00:25:4B:AA:11:3C','en0',1,NULL),(1954,207380589022,'BC:77:37:C0:B8:F9','Intel(R) Centrino(R) Wireless-N 1030',1,'192.168.101.58'),(1952,207380589022,'00:22:19:CF:52:94','Broadcom NetLink (TM) Fast Ethernet',1,NULL),(1952,207380589022,'00:22:5F:31:F0:95','Dell Wireless 1395 WLAN Mini-Card',1,'172.16.50.100'),(1951,207380589022,'00:23:4D:0A:A7:7E','Atheros AR5009 802.11a/g/n WiFi Adapter',1,'192.168.101.171'),(1951,207380589022,'00:1E:68:E0:5D:EB','Realtek RTL8102E/RTL8103E Family PCI-E Fast Ethernet NIC (NDIS 6.20)',1,NULL),(1950,207380589022,'00:26:6C:44:89:AA','Realtek PCIe FE Family Controller',1,NULL),(1950,207380589022,'B4:82:FE:18:2C:B9','Realtek RTL8191SE Wireless LAN 802.11n PCI-E NIC',1,'198.248.78.37'),(1949,207380589022,'78:84:3C:93:F6:0D','Atheros AR8151 PCI-E Gigabit Ethernet Controller (NDIS 6.20)',1,NULL),(1948,207380589022,'64:D4:DA:56:F2:87','Intel(R) Centrino(R) WiMAX 6150',1,NULL),(1949,207380589022,'90:00:4E:C0:9A:0D','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.89'),(1948,207380589022,'40:25:C2:38:E6:6D','Microsoft Virtual WiFi Miniport Adapter',1,NULL),(1934,207380589022,'20:CF:30:2D:15:E7','Atheros AR8131 PCI-E Gigabit Ethernet Controller (NDIS 6.20)',1,NULL),(1933,207380589022,'00:1E:65:10:8C:A8','Intel(R) WiFi Link 5100 AGN - Packet Scheduler Miniport',1,'198.248.74.47'),(1934,207380589022,'74:F0:6D:79:3D:2F','Atheros AR9285 Wireless Network Adapter',1,'192.168.101.2'),(1923,207380589022,'64:31:50:63:95:14','Realtek PCIe FE Family Controller',1,NULL),(1923,207380589022,'4C:0F:6E:38:3C:C2','Atheros AR9285 802.11b/g/n WiFi Adapter',1,'192.168.101.191'),(1948,207380589022,'2C:41:38:01:95:DD','Atheros AR8151 PCI-E Gigabit Ethernet Controller (NDIS 6.20)',1,NULL),(1948,207380589022,'40:25:C2:38:E6:6C','Intel(R) Centrino(R) Wireless-N 6150',1,'192.168.101.45');
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 (1947,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(1947,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(1947,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(1947,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(1947,207380589022,1,'Operating-System','Windows 7',4,1),(1946,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1946,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1946,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1946,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1946,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1945,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1945,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1945,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1945,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1945,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1944,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1944,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1944,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1944,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1944,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1943,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1943,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1943,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1943,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1943,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1942,207380589022,2,'Operating-System','OS X Snow Leopard Update',4,1),(1942,207380589022,2,'Operating-System','OS X Version 10.6 (Snow Leopard)',4,1),(1942,207380589022,2,'Operating-System','OS X Leopard Update',4,1),(1942,207380589022,2,'Operating-System','OS X Version 10.5 (Leopard)',4,1),(1942,207380589022,2,'Operating-System','OS X Tiger Update',4,1),(1942,207380589022,2,'Operating-System','OS X Version 10.4 (Tiger)',4,1),(1941,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1941,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1941,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1941,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1941,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1940,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1940,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1940,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1940,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1940,207380589022,1,'Operating-System','Windows Vista',4,1),(1939,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1939,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1939,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1939,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1939,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1938,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1938,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1938,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1938,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1938,207380589022,1,'Operating-System','Windows Vista',4,1),(1937,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1937,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1937,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1937,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1937,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1936,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1936,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1936,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1936,207380589022,1,'Operating-System','Windows Vista',4,1),(1936,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1935,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1935,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1935,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1935,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1935,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1934,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1934,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1934,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1934,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1934,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1932,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1932,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1932,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1932,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1931,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1932,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1931,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1931,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1931,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1931,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1930,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1930,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1930,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1930,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1929,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1930,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1929,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1929,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1929,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1929,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1928,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1928,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1928,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1928,207380589022,1,'Operating-System','Windows XP',4,1),(1927,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1927,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1927,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1927,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1926,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1927,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1926,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1926,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1926,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1925,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1926,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1925,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1925,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1925,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1925,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1924,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1924,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1924,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1924,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1924,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1923,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1923,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1923,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1923,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1923,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1963,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1963,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1963,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1963,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1963,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1962,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1962,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1962,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1962,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1961,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1962,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1961,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1961,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1961,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1961,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1960,207380589022,1,'Operating-System','Windows Vista x64 AutoUpdates Label',4,1),(1960,207380589022,1,'Operating-System','Vista x64 Critical and Security Updates',4,1),(1960,207380589022,1,'Operating-System','Windows Vista x64 Edition',4,1),(1960,207380589022,1,'Operating-System','Vista x64 Service Pack',4,1),(1960,207380589022,1,'Operating-System','Windows Vista x64',4,1),(1959,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1959,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1959,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1959,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1958,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1959,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1958,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1958,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1958,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1957,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1958,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1957,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1957,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1957,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1957,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1956,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1956,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1956,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1956,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1955,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1956,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1955,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1955,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1955,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1955,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1954,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1954,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1954,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1954,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1954,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1953,207380589022,1,'Operating-System','OS X Version 10.5 (Leopard)',4,1),(1953,207380589022,1,'Operating-System','OS X Leopard Update',4,1),(1952,207380589022,1,'Operating-System','Vista Critical and Security Updates',4,1),(1952,207380589022,1,'Operating-System','Windows Vista AutoUpdates Label',4,1),(1952,207380589022,1,'Operating-System','Windows Vista Edition',4,1),(1952,207380589022,1,'Operating-System','Vista Service Pack',4,1),(1952,207380589022,1,'Operating-System','Windows Vista',4,1),(1951,207380589022,1,'Operating-System','Windows 7 AutoUpdates Label',4,1),(1951,207380589022,1,'Operating-System','Windows 7 Critical and Security Updates',4,1),(1951,207380589022,1,'Operating-System','Windows 7 Edition',4,1),(1951,207380589022,1,'Operating-System','Windows 7',4,1),(1951,207380589022,1,'Operating-System','Windows 7 Service Pack',4,1),(1950,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1950,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1950,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1950,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1950,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1949,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1949,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1949,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1949,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1949,207380589022,1,'Operating-System','Windows 7 x64',4,1),(1933,207380589022,1,'Operating-System','Windows XP AutoUpdate',4,1),(1933,207380589022,1,'Operating-System','Windows XP Service Pack',4,1),(1933,207380589022,1,'Operating-System','XP Critical and Security Updates',4,1),(1933,207380589022,1,'Operating-System','Windows XP',4,1),(1948,207380589022,1,'Operating-System','Windows 7 x64 Critical and Security Updates',4,1),(1948,207380589022,1,'Operating-System','Windows 7 x64 AutoUpdates Label',4,1),(1948,207380589022,1,'Operating-System','Windows 7 x64 Edition',4,1),(1948,207380589022,1,'Operating-System','Windows 7 x64 Service Pack',4,1),(1948,207380589022,1,'Operating-System','Windows 7 x64',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 (1947,207380589022,1,'smith.ryan1','Smith-PC','Windows 7 Starter 6.1','HCC-Users',1316385415257,4,1,NULL),(1946,207380589022,1,'balderas.omar','Angie-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1316372463115,4,1,'Rubeti6 AP VLAN Registration'),(1945,207380589022,1,'gentry.skyler','SkylerGentry-PC','Windows 7 Home Premium 6.1','HCC-Users',1316326405093,4,1,'HollyOak AP VLAN Registration'),(1944,207380589022,1,'cheatom.james','Devin-PC','Windows 7 Home Premium 6.1','HCC-Users',1316324916044,4,1,'Heritage-MDF1 66'),(1942,207380589022,2,'montes.eruviel','ITMacAdmins-MacBook','Mac OS X 10.7.1','HCC-Users',1316133770486,4,1,'Piper AP VLAN Registration'),(1943,207380589022,1,'perkins.brady','charlotte-HP','Windows 7 Home Premium 6.1','HCC-Users',1316153421139,4,1,'Highlander AP VLAN Registration'),(1941,207380589022,1,'howard.dain','Dain-PC','Windows 7 Home Premium 6.1','HCC-Users',1316071680145,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(1940,207380589022,1,'alderson.tori','tori-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 1','HCC-Users',1316056541597,4,1,NULL),(1939,207380589022,1,'mkendricks','junejune-PC','Windows 7 Home Premium 6.1','HCC-Users',1316041014557,4,1,'Admin-MDF1 B9'),(1938,207380589022,1,'mccann.hayley','HAYLEY','Windows Vista (TM) Home Basic 6.0','HCC-Users',1316037892410,4,1,'Hampton AP VLAN Registration'),(1937,207380589022,1,'cole.alison','Alison-HP','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1315974357432,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(1935,207380589022,1,'berry.danielle','Owner-HP','Windows 7 Home Premium 6.1','HCC-Users',1315901117611,4,1,'Sunflower-MDF1 1'),(1936,207380589022,1,'wood.aaron','Aaron-Laptop','Windows Vista (TM) Home Premium 6.0','HCC-Users',1315974355880,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(1932,207380589022,1,'helmstetter.morgan','Morgan-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1315801777041,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(1931,207380589022,1,'nightingale.gale','Owner-HP','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1315730310964,4,1,'Highlander AP VLAN Registration'),(1930,207380589022,1,'upchurch.deandre','DeAndre','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1315648573081,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(1929,207380589022,1,'Hobbs.Jessica','ColbyDale-PC','Windows 7 Home Premium 6.1','HCC-Users',1315631374883,4,1,'Hearthford AP VLAN Registration'),(1928,207380589022,1,'berry.danielle','YOUR-BIX95J1IL3','Microsoft Windows XP 5.1 Service Pack 3','HCC-Users',1315459949460,4,1,'Piper AP VLAN Registration'),(1927,207380589022,1,'furman.dustin','Dustin-HP','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1315455827081,4,1,'Highlander AP VLAN Registration'),(1926,207380589022,1,'proffitt.mason','Mason-HP','Windows 7 Home Premium 6.1','HCC-Users',1315443025534,4,1,'Rubeti-MDF1 15'),(1925,207380589022,1,'gallegoskoons.kathle','Kathy-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1315295608076,4,1,'Sunflower AP VLAN Registration'),(1924,207380589022,1,'cunningham.mariah','Mariah-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1315292847120,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(1923,207380589022,1,'Clayter.Antonio','tonio-HP','Windows 7 Home Premium 6.1','HCC-Users',1315282381132,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(1963,207380589022,1,'griffin.blair','Owner-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1317012490040,4,1,'Crestview AP VLAN Registration'),(1962,207380589022,1,'Volle.Martin','Chris-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1317011093044,4,1,'Rubeti6 AP VLAN Registration'),(1961,207380589022,1,'banks.stacey','banks-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1316993736115,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(1959,207380589022,1,'caw.brittany','Brittany-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1316984870474,4,1,'Hampton AP VLAN Registration'),(1960,207380589022,1,'eberly.bryce','Owner-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 1','HCC-Users',1316992862995,4,1,'Highlander AP VLAN Registration'),(1958,207380589022,1,'Krull.Kacy','KacyJo-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1316937392693,4,1,'Hampton AP VLAN Registration'),(1957,207380589022,1,'Adams.derrick','Awsomeepictus','Windows 7 Home Premium 6.1','HCC-Users',1316934836550,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(1955,207380589022,1,'cadue.jerrid','allison-PC','Windows 7 Home Premium 6.1','HCC-Users',1316728677905,4,1,'Degginger AP VLAN Registration'),(1956,207380589022,1,'wills.deandre','SWAGGG','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1316929406072,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(1954,207380589022,1,'houston.chloe','CCMH','Windows 7 Home Premium 6.1','HCC-Users',1316660579152,4,1,'Huntington AP VLAN Registration'),(1953,207380589022,1,'benard.jarvis','localhost','Mac OS X 10.5.8','HCC-Users',1316581107044,4,1,NULL),(1952,207380589022,1,'caudle.anna','Anna-PC','Windows Vista (TM) Home Premium 6.0 Service Pack 2','HCC-Users',1316553326024,4,1,NULL),(1951,207380589022,1,'hoffman.staje','Staje-PC','Windows 7 Ultimate 6.1 Service Pack 1','HCC-Users',1316550254621,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(1949,207380589022,1,'davis.cody','Cody-VAIO','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1316516261988,4,1,'Piper AP VLAN Registration'),(1950,207380589022,1,'hirsch.steven','Owner-PC','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1316542602473,4,1,NULL),(1933,207380589022,1,'ssmith','MAR-0019','Microsoft Windows XP 5.1 Service Pack 3','HCC-Users',1315854770056,4,1,NULL),(1934,207380589022,1,'emberton.derek','Derek-PC','Windows 7 Home Premium 6.1','HCC-Users',1315883870444,4,1,'MSM760.Highland.cc.ks.us VLAN 30'),(1948,207380589022,1,'simmons.nakia','owner-HP','Windows 7 Home Premium 6.1 Service Pack 1','HCC-Users',1316504705184,4,1,'Huntington AP VLAN Registration');
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 */;