Open-AudIT
https://www.open-audit.org/phpBB3/

OAv2
https://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=2855		 Page 2 of 4
Author:  orange_girl [ Sat Sep 20, 2008 5:45 pm ]
Post subject:  Re: OAv2
Great!
I am excited about this...
I hope you'll remain to be generous.. and not selfish as you said...
You've helped a lot of people... Maybe you can just ask for donations :D
Author:  jsteenberge [ Sun Oct 05, 2008 12:03 am ]
Post subject:  Re: OAv2
Hey Mark! Long time no talk! I noticed you said that you don't have any mac's, well it just so happens I have over 300 OSX 10.3.x and 10.4.x boxes. If you need any help to beta this out let me know. I could even possibly put you a machine on a subnet and give remote access to test scripts out. Email me at my registered address if your interested.
Author:  qc_metal [ Thu Oct 09, 2008 6:12 am ]
Post subject:  Re: OAv2
Very excited about v2.0.

Keep us informed, and let us know if you need any assistance. I can help out with any audit vbscripts for PCs...
Author:  jsingh [ Thu Oct 16, 2008 12:49 am ]
Post subject:  Re: OAv2
me too...very excited.
Author:  Mark [ Thu Oct 16, 2008 2:55 pm ]
Post subject:  Re: OAv2
Some updated screenshots....
FYI - on the Summary page, when you click one of the buttons (Purchase, Network, etc) the appropriate section dynamically reveals below what is in the screenshot. works very nicely...

Attachments:
current_summary.png
current_summary.png [ 102.76 KiB | Viewed 14214 times ]
current_list.png
current_list.png [ 40.23 KiB | Viewed 14210 times ]
Author:  sgovind [ Thu Oct 16, 2008 3:28 pm ]
Post subject:  Re: OAv2
mark we are so excited to get hold of it :) is there any tentative date on release of beta or something?
Author:  Mark [ Thu Oct 16, 2008 3:40 pm ]
Post subject:  Re: OAv2
[quote]mark we are so excited to get hold of it :) is there any tentative date on release of beta or something?
I wish !!!
At the moment, I have the audit script running (win + lin), although only recording a subset of info.
You can manually post the info through the web page, and it gets inserted into the DB.
Once that is done, you can view 2 "list" pages (systems and software), and the System Details page.
There are some predefined Groups (as per the screenshot) that auto populate.
Users / Groups / Permissions are integrated, but there are no config pages.

That's pretty much as far as I have got, at the moment.

I have been concentrating on the code structures and formatting, feature set and business case.

I want this version to be technically "best of breed". Not just thrown together. It is going well (I've restarted twice), just slowly. I have a full time position (at the moment), and between that and my family (wife + 2 kids - 2yo and 5mo) I haven't got enough time.... I wish I had more, I really do. I think I could "finish" it with about 3 month fulltime work. I would even finance it myself, if I had enough money to support my family and make the mortgage payment. I really think that when OAv2 is complete, it will blow a lot of people away. I am hoping that will translate into "sales". Yes, I intend on keeping the code GPL, but I have a few "use cases" that (I think) could be a nice earner. If I am really lucky, I hope to be able to make my living from OAv2 - yes, I think it will be THAT good....

If you _really_ want, I could throw the code up somewhere, but honestly, it's more in the planning stage and not very useful at the moment. I suppose peer review of the database structure would be nice... Will post the DB structure after this post.
Author:  Mark [ Thu Oct 16, 2008 3:43 pm ]
Post subject:  Re: OAv2
This my MySQL setup file - split across two posts...

[code]-- MySQL dump 10.11
--
-- Host: localhost Database: oanew
-- ------------------------------------------------------
-- Server version 5.0.51a-3ubuntu5.2

/*!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 `oa_alert_log`
--

DROP TABLE IF EXISTS `oa_alert_log`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_alert_log` (
`alert_id` int(10) NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`alert_table` varchar(50) NOT NULL,
`alert_foreign_row` int(10) NOT NULL,
`alert_details` varchar(200) NOT NULL,
`user_id` int(10) unsigned default '0',
`alert_ack_time` datetime NOT NULL default '0000-00-00 00:00:00',
`alert_note` varchar(200) NOT NULL,
`system_change_id` int(10) unsigned NOT NULL default '0',
`alert_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`alert_id`),
KEY `system_id` (`system_id`),
KEY `oa_alert_log_user_id` (`user_id`),
KEY `oa_alert_change_id` (`system_change_id`),
CONSTRAINT `oa_alert_log_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`),
CONSTRAINT `oa_alert_log_user_id` FOREIGN KEY (`user_id`) REFERENCES `oa_user` (`user_id`),
CONSTRAINT `oa_alert_change_id` FOREIGN KEY (`system_change_id`) REFERENCES `sys_man_change` (`system_change_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `oa_audit_log`
--

DROP TABLE IF EXISTS `oa_audit_log`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_audit_log` (
`audit_log_id` int(10) NOT NULL auto_increment,
`user_id` int(10) unsigned default '0',
`audit_log_event_type` varchar(50) NOT NULL,
`audit_log_event_details` varchar(200) NOT NULL,
`audit_log_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`audit_log_id`),
KEY `user_id` (`user_id`),
CONSTRAINT `oa_audit_log_user_id` FOREIGN KEY (`user_id`) REFERENCES `oa_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `oa_config`
--

DROP TABLE IF EXISTS `oa_config`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_config` (
`config_name` varchar(45) NOT NULL default '',
`config_value` varchar(45) NOT NULL default '',
PRIMARY KEY (`config_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `oa_group`
--

DROP TABLE IF EXISTS `oa_group`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_group` (
`group_id` int(10) unsigned NOT NULL auto_increment,
`group_name` varchar(100) NOT NULL,
`group_type` varchar(1) NOT NULL,
`group_dynamic_select` text NOT NULL,
`group_parent` int(10) NOT NULL default '1',
`group_contact` varchar(50) NOT NULL,
`group_description` varchar(255) NOT NULL,
`group_category` varchar(50) NOT NULL,
`group_phone` varchar(20) NOT NULL,
`group_fax` varchar(20) NOT NULL,
`group_address` varchar(200) NOT NULL,
`group_city` varchar(50) NOT NULL,
`group_state` varchar(3) NOT NULL,
`group_postcode` int(6) NOT NULL,
PRIMARY KEY (`group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `oa_group_gateway`
--

DROP TABLE IF EXISTS `oa_group_gateway`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_group_gateway` (
`group_gateway_id` int(10) NOT NULL auto_increment,
`group_id` int(10) NOT NULL,
`system_id` int(10) unsigned default NULL,
`group_gateway_link_type` varchar(100) NOT NULL,
`group_gateway_ip_address_internal` varchar(30) NOT NULL,
`group_gateway_ip_address_external` varchar(30) NOT NULL,
`group_gateway_connecting_group` int(10) NOT NULL,
PRIMARY KEY (`group_gateway_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `oa_group_gateway_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `oa_group_sys`
--

DROP TABLE IF EXISTS `oa_group_sys`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_group_sys` (
`group_sys_id` int(10) NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`group_id` int(10) unsigned default NULL,
`group_sys_type` varchar(20) NOT NULL,
PRIMARY KEY (`group_sys_id`),
KEY `system_id` (`system_id`),
KEY `group_id` (`group_id`),
CONSTRAINT `oa_group_sys_group_id` FOREIGN KEY (`group_id`) REFERENCES `oa_group` (`group_id`),
CONSTRAINT `oa_group_sys_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `oa_group_user`
--

DROP TABLE IF EXISTS `oa_group_user`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_group_user` (
`group_user_id` int(10) NOT NULL auto_increment,
`user_id` int(10) unsigned NOT NULL,
`group_id` int(10) unsigned NOT NULL,
`group_user_access_level` int(10) NOT NULL,
PRIMARY KEY (`group_user_id`),
KEY `user_id` (`user_id`),
KEY `group_id` (`group_id`),
CONSTRAINT `oa_group_user_group_id` FOREIGN KEY (`group_id`) REFERENCES `oa_group` (`group_id`),
CONSTRAINT `oa_group_user_user_id` FOREIGN KEY (`user_id`) REFERENCES `oa_user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `oa_net_nmap_ports`
--

DROP TABLE IF EXISTS `oa_net_nmap_ports`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_net_nmap_ports` (
`nmap_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`nmap_port_number` int(10) unsigned NOT NULL default '0',
`nmap_port_proto` varchar(10) NOT NULL default '',
`nmap_port_name` varchar(45) NOT NULL default '',
`nmap_port_version` varchar(100) NOT NULL default '',
`nmap_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`nmap_id`),
KEY `system_id` (`system_id`),
KEY `id2` (`nmap_port_number`),
KEY `id3` (`nmap_port_proto`),
CONSTRAINT `oa_net_nmap_ports_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `oa_net_scan_latest`
--

DROP TABLE IF EXISTS `oa_net_scan_latest`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_net_scan_latest` (
`scan_latest_id` int(10) NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`scan_latest_ip_address` varchar(30) NOT NULL,
`scan_latest_type` varchar(10) NOT NULL,
`scan_latest_detail` varchar(100) NOT NULL,
`scan_latest_frequency` tinyint(4) NOT NULL,
`scan_latest_date_time` datetime NOT NULL default '0000-00-00 00:00:00',
`scan_latest_result` varchar(20) NOT NULL,
`scan_latest_success` varchar(2) NOT NULL,
PRIMARY KEY (`scan_latest_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `oa_net_scan_latest_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `oa_net_scan_log`
--

DROP TABLE IF EXISTS `oa_net_scan_log`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_net_scan_log` (
`scan_log_id` int(10) NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`scan_log_ip_address` varchar(30) NOT NULL,
`scan_log_type` varchar(10) NOT NULL,
`scan_log_detail` varchar(100) NOT NULL,
`scan_log_frequency` tinyint(4) NOT NULL,
`scan_log_date_time` datetime NOT NULL default '0000-00-00 00:00:00',
`scan_log_result` varchar(20) NOT NULL,
`scan_log_success` varchar(2) NOT NULL,
PRIMARY KEY (`scan_log_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `oa_net_scan_log_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `oa_net_scan_type`
--

DROP TABLE IF EXISTS `oa_net_scan_type`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_net_scan_type` (
`scan_type_id` int(10) NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`scan_type_ip_address` varchar(30) NOT NULL,
`scan_type` varchar(10) NOT NULL,
`scan_type_detail` varchar(100) NOT NULL,
`scan_type_frequency` tinyint(4) NOT NULL,
PRIMARY KEY (`scan_type_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `oa_net_scan_type_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `oa_spare`
--

DROP TABLE IF EXISTS `oa_spare`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_spare` (
`spare_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`spare_field_1` varchar(45) NOT NULL default '',
`spare_field_2` varchar(100) NOT NULL default '',
`spare_field_3` varchar(200) NOT NULL default '',
`spare_field_4` varchar(200) NOT NULL default '',
`spare_field_5` varchar(200) NOT NULL default '',
`spare_field_6` varchar(200) NOT NULL default '',
`spare_field_7` varchar(200) NOT NULL default '',
`spare_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`spare_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `oa_spare_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `oa_switch_ports`
--

DROP TABLE IF EXISTS `oa_switch_ports`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_switch_ports` (
`switch_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`switch_system_id` int(10) unsigned default NULL,
`switch_port` varchar(100) NOT NULL default '',
`switch_timestamp` varchar(200) NOT NULL default '',
`switch_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`switch_id`),
KEY `system_id` (`system_id`),
KEY `switch_system_id` (`switch_system_id`),
CONSTRAINT `oa_switch_ports_switch_switch_id` FOREIGN KEY (`switch_system_id`) REFERENCES `system` (`system_id`),
CONSTRAINT `oa_switch_ports_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `oa_user`
--

DROP TABLE IF EXISTS `oa_user`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_user` (
`user_id` int(10) unsigned NOT NULL auto_increment,
`user_name` varchar(100) NOT NULL,
`user_password` varchar(100) NOT NULL,
`user_full_name` varchar(100) NOT NULL,
`user_email` varchar(100) default NULL,
`user_lang` varchar(100) default NULL,
`user_display_number` smallint(6) NOT NULL default '10',
`user_theme` varchar(100) default NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Definition of table `oa_user_sessions`
--

DROP TABLE IF EXISTS `oa_user_sessions`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_user_sessions` (
`session_id` varchar(40) NOT NULL default '0',
`ip_address` varchar(16) NOT NULL default '0',
`user_agent` varchar(50) NOT NULL,
`last_activity` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `sys_hw_battery`
--

DROP TABLE IF EXISTS `sys_hw_battery`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_battery` (
`bt_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`bt_description` varchar(100) NOT NULL default '',
`bt_device_id` varchar(100) NOT NULL default '',
`bt_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`bt_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`bt_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_battery_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_bios`
--

DROP TABLE IF EXISTS `sys_hw_bios`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_bios` (
`bios_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`bios_description` varchar(200) NOT NULL default '',
`bios_manufacturer` varchar(200) NOT NULL default '',
`bios_serial_number` varchar(100) NOT NULL default '',
`bios_sm_bios_version` varchar(100) NOT NULL default '',
`bios_version` varchar(100) NOT NULL default '',
`bios_asset_tag` varchar(100) NOT NULL default '',
`bios_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`bios_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`bios_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_bios_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_firewire`
--

DROP TABLE IF EXISTS `sys_hw_firewire`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_firewire` (
`fw_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`fw_description` varchar(200) NOT NULL default '',
`fw_manufacturer` varchar(100) NOT NULL default '',
`fw_caption` varchar(200) NOT NULL default '',
`fw_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`fw_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`fw_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_firewire_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_floppy`
--

DROP TABLE IF EXISTS `sys_hw_floppy`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_floppy` (
`floppy_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`floppy_description` varchar(100) NOT NULL default '',
`floppy_device_id` varchar(100) NOT NULL default '',
`floppy_manufacturer` varchar(100) NOT NULL default '',
`floppy_caption` varchar(100) NOT NULL default '',
`floppy_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`floppy_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`floppy_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_floppy_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_graphs_disk`
--

DROP TABLE IF EXISTS `sys_hw_graphs_disk`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_graphs_disk` (
`disk_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`disk_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`disk_letter` varchar(4) NOT NULL default '',
`disk_percent` varchar(3) NOT NULL default '',
PRIMARY KEY (`disk_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_graphs_disk_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_hard_drive`
--

DROP TABLE IF EXISTS `sys_hw_hard_drive`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_hard_drive` (
`hard_drive_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`hard_drive_caption` varchar(100) NOT NULL default '',
`hard_drive_index` varchar(100) NOT NULL default '',
`hard_drive_interface_type` varchar(10) NOT NULL default '',
`hard_drive_manufacturer` varchar(100) NOT NULL default '',
`hard_drive_model` varchar(100) NOT NULL default '',
`hard_drive_serial` varchar(100) NOT NULL default '',
`hard_drive_partitions` int(10) unsigned NOT NULL default '0',
`hard_drive_scsi_bus` varchar(10) NOT NULL default '',
`hard_drive_scsi_logical_unit` varchar(100) NOT NULL default '',
`hard_drive_scsi_port` varchar(10) NOT NULL default '',
`hard_drive_size` int(10) unsigned NOT NULL default '0',
`hard_drive_device_id` varchar(200) NOT NULL default '',
`hard_drive_status` varchar(10) NOT NULL default '',
`hard_drive_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`hard_drive_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`hard_drive_id`),
KEY `hard_drive_index` (`hard_drive_index`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_hard_drive_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_keyboard`
--

DROP TABLE IF EXISTS `sys_hw_keyboard`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_keyboard` (
`keyboard_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`keyboard_description` varchar(100) NOT NULL default '',
`keyboard_caption` varchar(100) NOT NULL default '',
`keyboard_connection` varchar(45) NOT NULL default '',
`keyboard_device_id` varchar(100) NOT NULL default '',
`keyboard_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`keyboard_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`keyboard_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_keyboard_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_memory`
--

DROP TABLE IF EXISTS `sys_hw_memory`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_memory` (
`memory_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`memory_bank` varchar(45) NOT NULL default '',
`memory_type` varchar(45) NOT NULL default '',
`memory_form_factor` varchar(45) NOT NULL default '',
`memory_detail` varchar(45) NOT NULL default '',
`memory_capacity` int(10) NOT NULL,
`memory_speed` varchar(45) NOT NULL default '',
`memory_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`memory_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`memory_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_memory_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_modem`
--

DROP TABLE IF EXISTS `sys_hw_modem`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_modem` (
`modem_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`modem_attached_to` varchar(100) NOT NULL default '',
`modem_country_selected` varchar(100) NOT NULL default '',
`modem_description` varchar(100) NOT NULL default '',
`modem_device_id` varchar(100) NOT NULL default '',
`modem_device_type` varchar(100) NOT NULL default '',
`modem_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`modem_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`modem_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_modem_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_monitor`
--

DROP TABLE IF EXISTS `sys_hw_monitor`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_monitor` (
`monitor_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`monitor_manufacturer` varchar(45) NOT NULL default '',
`monitor_device_id` varchar(45) NOT NULL default '',
`monitor_manufacture_date` varchar(45) NOT NULL default '',
`monitor_model` varchar(45) NOT NULL default '',
`monitor_serial` varchar(45) NOT NULL default '',
`monitor_serial_man` varchar(45) NOT NULL default '',
`monitor_edid` varchar(45) NOT NULL default '',
`monitor_description` varchar(100) NOT NULL default '',
`monitor_value` varchar(45) NOT NULL default '',
`monitor_purchase_order_number` varchar(45) NOT NULL default '',
`monitor_date_purchased` date NOT NULL default '0000-00-00',
`monitor_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`monitor_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`monitor_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_monitor_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_motherboard`
--

DROP TABLE IF EXISTS `sys_hw_motherboard`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_motherboard` (
`motherboard_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`motherboard_manufacturer` varchar(50) NOT NULL default '',
`motherboard_product` varchar(50) NOT NULL default '',
`motherboard_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`motherboard_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`motherboard_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_motherboard_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_mouse`
--

DROP TABLE IF EXISTS `sys_hw_mouse`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_mouse` (
`mouse_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`mouse_description` varchar(100) NOT NULL default '',
`mouse_number_of_buttons` varchar(45) NOT NULL default '',
`mouse_device_id` varchar(100) NOT NULL default '',
`mouse_type` varchar(45) NOT NULL default '',
`mouse_port` varchar(45) NOT NULL default '',
`mouse_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`mouse_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`mouse_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_mouse_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_network_card`
--

DROP TABLE IF EXISTS `sys_hw_network_card`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_network_card` (
`net_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`net_mac_address` varchar(17) NOT NULL default '',
`net_manufacturer` varchar(100) NOT NULL default '',
`net_model` varchar(100) NOT NULL default '',
`net_description` varchar(255) NOT NULL default '',
`net_ip_enabled` varchar(10) NOT NULL default '',
`net_index` varchar(10) NOT NULL default '',
`net_service_name` varchar(30) NOT NULL default '',
`net_dhcp_enabled` varchar(100) NOT NULL default '',
`net_dhcp_server` varchar(30) NOT NULL default '',
`net_dhcp_lease_obtained` varchar(14) NOT NULL default '',
`net_dhcp_lease_expires` varchar(14) NOT NULL default '',
`net_dns_host_name` varchar(100) NOT NULL default '',
`net_dns_server` varchar(30) NOT NULL default '',
`net_dns_server_2` varchar(30) NOT NULL default '',
`net_dns_server_3` varchar(30) NOT NULL default '',
`net_dns_domain` varchar(100) NOT NULL default '',
`net_dns_domain_suffix` varchar(100) NOT NULL default '',
`net_dns_domain_suffix_2` varchar(100) NOT NULL default '',
`net_dns_domain_suffix_3` varchar(100) NOT NULL default '',
`net_dns_domain_reg_enabled` varchar(10) NOT NULL default '',
`net_dns_domain_full_reg_enabled` varchar(10) NOT NULL default '',
`net_wins_primary` varchar(30) NOT NULL default '',
`net_wins_secondary` varchar(30) NOT NULL default '',
`net_wins_lmhosts_enabled` varchar(10) NOT NULL default '',
`net_netbios_options` varchar(10) NOT NULL default '',
`net_adapter_type` varchar(100) NOT NULL default '',
`net_connection_id` varchar(255) NOT NULL default '',
`net_connection_status` varchar(30) NOT NULL default '',
`net_speed` varchar(10) NOT NULL default '',
`net_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`net_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`net_id`),
KEY `net_mac_address` (`net_mac_address`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_network_card_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_network_card_ip`
--

DROP TABLE IF EXISTS `sys_hw_network_card_ip`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_network_card_ip` (
`ip_id` int(10) unsigned NOT NULL auto_increment,
`net_mac_address` varchar(17) NOT NULL default '',
`ip_address` varchar(30) NOT NULL default '',
`ip_address_v6` varchar(30) NOT NULL default '',
`ip_subnet` varchar(30) NOT NULL default '',
`ip_address_version` varchar(10) NOT NULL default '',
`ip_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`ip_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`ip_id`),
KEY `id` (`net_mac_address`),
CONSTRAINT `sys_hw_network_card_ip_net_mac_address` FOREIGN KEY (`net_mac_address`) REFERENCES `sys_hw_network_card` (`net_mac_address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_onboard_device`
--

DROP TABLE IF EXISTS `sys_hw_onboard_device`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_onboard_device` (
`onboard_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`onboard_description` varchar(50) NOT NULL default '',
`onboard_type` varchar(20) NOT NULL default '',
`onboard_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`onboard_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`onboard_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_onboard_device_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_optical_drive`
--

DROP TABLE IF EXISTS `sys_hw_optical_drive`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_optical_drive` (
`optical_drive_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`optical_drive_caption` varchar(100) NOT NULL default '',
`optical_drive_model` varchar(100) NOT NULL default '',
`optical_drive_device_id` varchar(100) NOT NULL default '',
`optical_drive_mount_point` varchar(10) NOT NULL default '',
`optical_drive_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`optical_drive_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`optical_drive_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_optical_drive_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_partition`
--

DROP TABLE IF EXISTS `sys_hw_partition`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_partition` (
`partition_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`hard_drive_index` varchar(100) NOT NULL default '',
`partition_mount_point` varchar(100) NOT NULL default '',
`partition_name` varchar(100) NOT NULL default '',
`partition_size` int(10) unsigned NOT NULL default '1',
`partition_free_space` int(10) unsigned NOT NULL default '1',
`partition_used_space` int(10) unsigned NOT NULL default '1',
`partition_format` varchar(20) NOT NULL default '',
`partition_caption` varchar(100) NOT NULL default '',
`partition_device_id` varchar(100) NOT NULL default '',
`partition_disk_index` varchar(50) NOT NULL default '',
`partition_boot_partition` varchar(10) NOT NULL default '',
`partition_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`partition_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`partition_id`),
KEY `system_id` (`system_id`),
KEY `hard_drive_index` (`hard_drive_index`),
CONSTRAINT `sys_hw_partition_hard_drive_index` FOREIGN KEY (`hard_drive_index`) REFERENCES `sys_hw_hard_drive` (`hard_drive_index`),
CONSTRAINT `sys_hw_partition_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_processor`
--

DROP TABLE IF EXISTS `sys_hw_processor`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_processor` (
`processor_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`processor_cores` int(2) unsigned NOT NULL default '0',
`processor_description` varchar(100) NOT NULL default '',
`processor_speed` int(10) unsigned NOT NULL default '0',
`processor_manufacturer` varchar(100) NOT NULL default '',
`processor_caption` varchar(100) NOT NULL default '',
`processor_device_id` varchar(100) NOT NULL default '',
`processor_name` varchar(100) NOT NULL default '',
`processor_power_management_supported` varchar(20) NOT NULL default '',
`processor_socket_designation` varchar(50) NOT NULL default '',
`processor_current_voltage` int(10) unsigned NOT NULL default '0',
`processor_ext_clock` int(10) unsigned NOT NULL default '0',
`processor_max_clock_speed` int(10) unsigned NOT NULL default '0',
`processor_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`processor_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`processor_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_processor_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_scsi_controller`
--

DROP TABLE IF EXISTS `sys_hw_scsi_controller`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_scsi_controller` (
`scsi_controller_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`scsi_controller_caption` varchar(200) NOT NULL default '',
`scsi_controller_device_id` varchar(200) NOT NULL default '',
`scsi_controller_manufacturer` varchar(100) NOT NULL default '',
`scsi_controller_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`scsi_controller_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`scsi_controller_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_scsi_controller_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_scsi_device`
--

DROP TABLE IF EXISTS `sys_hw_scsi_device`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_scsi_device` (
`scsi_device_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`scsi_device_controller` int(10) unsigned default NULL,
`scsi_device_device` varchar(200) NOT NULL default '',
`scsi_device_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`scsi_device_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`scsi_device_id`),
KEY `system_id` (`system_id`),
KEY `scsi_device_controller` (`scsi_device_controller`),
CONSTRAINT `sys_hw_scsi_device_scsi_device_controller` FOREIGN KEY (`scsi_device_controller`) REFERENCES `sys_hw_scsi_controller` (`scsi_controller_id`),
CONSTRAINT `sys_hw_scsi_device_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_sound`
--

DROP TABLE IF EXISTS `sys_hw_sound`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_sound` (
`sound_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`sound_manufacturer` varchar(100) NOT NULL default '',
`sound_device_id` varchar(100) NOT NULL default '',
`sound_name` varchar(100) NOT NULL default '',
`sound_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`sound_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`sound_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_sound_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_tape_drive`
--

DROP TABLE IF EXISTS `sys_hw_tape_drive`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_tape_drive` (
`tape_drive_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`tape_drive_caption` varchar(100) NOT NULL default '',
`tape_drive_description` varchar(100) NOT NULL default '',
`tape_drive_device_id` varchar(100) NOT NULL default '',
`tape_drive_manufacturer` varchar(100) NOT NULL default '',
`tape_drive_name` varchar(100) NOT NULL default '',
`tape_drive_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`tape_drive_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`tape_drive_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_tape_drive_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_usb`
--

DROP TABLE IF EXISTS `sys_hw_usb`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_usb` (
`usb_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`usb_caption` varchar(100) NOT NULL default '',
`usb_description` varchar(100) NOT NULL default '',
`usb_manufacturer` varchar(100) NOT NULL default '',
`usb_device_id` varchar(120) NOT NULL default '',
`usb_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`usb_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`usb_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_usb_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_hw_video`
--

DROP TABLE IF EXISTS `sys_hw_video`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_video` (
`video_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`video_description` varchar(100) NOT NULL default '',
`video_manufacturer` varchar(100) NOT NULL default '',
`video_current_horizontal_res` varchar(20) NOT NULL default '',
`video_current_vertical_res` varchar(20) NOT NULL default '',
`video_adapter_ram` varchar(100) NOT NULL default '',
`video_caption` varchar(100) NOT NULL default '',
`video_current_number_colours` varchar(20) NOT NULL default '',
`video_current_refresh_rate` varchar(20) NOT NULL default '',
`video_device_id` varchar(100) NOT NULL default '',
`video_driver_date` varchar(20) NOT NULL default '',
`video_driver_version` varchar(20) NOT NULL default '',
`video_max_refresh_rate` varchar(20) NOT NULL default '',
`video_min_refresh_rate` varchar(20) NOT NULL default '',
`video_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`video_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`video_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_video_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
[/code]
Author:  Mark [ Thu Oct 16, 2008 3:44 pm ]
Post subject:  Re: OAv2
Part 2...

[code]--
-- Table structure for table `sys_man_audits`
--

DROP TABLE IF EXISTS `sys_man_audits`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_man_audits` (
`system_audits_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`system_audits_username` varchar(45) NOT NULL default '',
`system_audits_type` varchar(45) NOT NULL default '',
`system_audits_time` varchar(45) NOT NULL default '',
`system_audits_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`system_audits_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_man_audits_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_man_change`
--

DROP TABLE IF EXISTS `sys_man_change`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_man_change` (
`system_change_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`system_change_date` datetime NOT NULL default '0000-00-00 00:00:00',
`system_change_short_desc` varchar(200) NOT NULL default '',
`system_change_detailed_desc` varchar(200) NOT NULL default '',
`system_change_authorising_person` varchar(45) NOT NULL default '',
`system_change_reason` varchar(200) NOT NULL default '',
`system_change_potential_issues` varchar(200) NOT NULL default '',
`system_change_backout_plan` varchar(200) NOT NULL default '',
`system_change_callid` int(10) unsigned NOT NULL default '0',
`system_change_call_techid` int(10) unsigned NOT NULL default '0',
`system_change_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`system_change_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_man_change_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_man_change_log`
--

DROP TABLE IF EXISTS `sys_man_change_log`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_man_change_log` (
`system_change_log_id` int(10) unsigned NOT NULL auto_increment,
`system_change_id` int(10) unsigned NOT NULL default '0',
`system_change_log_attachmentid` int(10) unsigned NOT NULL default '0',
`system_change_log_call_techid` int(10) unsigned NOT NULL default '0',
`system_change_log_date` datetime NOT NULL default '0000-00-00 00:00:00',
`system_change_log_comments` varchar(200) NOT NULL default '',
PRIMARY KEY (`system_change_log_id`),
KEY `system_change_id` (`system_change_id`),
CONSTRAINT `sys_man_change_log_system_change_id` FOREIGN KEY (`system_change_id`) REFERENCES `sys_man_change` (`system_change_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_man_invoice`
--

DROP TABLE IF EXISTS `sys_man_invoice`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_man_invoice` (
`invoice_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`invoice_filename` varchar(100) NOT NULL default '',
`invoice_image` blob,
PRIMARY KEY (`invoice_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_man_invoice_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_man_notes`
--

DROP TABLE IF EXISTS `sys_man_notes`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_man_notes` (
`notes_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`user_id` int(10) unsigned default NULL,
`notes_title` varchar(200) NOT NULL default '',
`notes_text` text NOT NULL default '',
`notes_timestamp` varchar(200) NOT NULL default '',
PRIMARY KEY (`notes_id`),
KEY `system_id` (`system_id`),
KEY `user_id` (`user_id`),
CONSTRAINT `sys_man_notes_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`),
CONSTRAINT `sys_man_notes_user_id` FOREIGN KEY (`user_id`) REFERENCES `oa_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_man_passwords`
--

DROP TABLE IF EXISTS `sys_man_passwords`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_man_passwords` (
`passwords_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`passwords_application` varchar(100) NOT NULL default '',
`passwords_password` varchar(100) NOT NULL default '',
`passwords_user` varchar(100) NOT NULL default '',
PRIMARY KEY (`passwords_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_man_passwords_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_antivirus`
--

DROP TABLE IF EXISTS `sys_sw_antivirus`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_antivirus` (
`virus_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`virus_manufacturer` varchar(150) NOT NULL default '',
`virus_version` varchar(45) NOT NULL default '',
`virus_name` varchar(100) NOT NULL default '',
`virus_uptodate` varchar(45) NOT NULL default '',
`virus_def_date` date NOT NULL default '0000-00-00',
`virus_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`virus_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`virus_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_antivirus_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_environment_variable`
--

DROP TABLE IF EXISTS `sys_sw_environment_variable`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_environment_variable` (
`env_var_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`env_var_name` varchar(50) NOT NULL default '',
`env_var_value` varchar(250) NOT NULL default '',
`env_var_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`env_var_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`env_var_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_environment_variable_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_event_log`
--

DROP TABLE IF EXISTS `sys_sw_event_log`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_event_log` (
`evt_log_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`evt_log_name` varchar(50) NOT NULL default '',
`evt_log_file_name` varchar(100) NOT NULL default '',
`evt_log_file_size` int(10) NOT NULL default '0',
`evt_log_max_file_size` int(10) NOT NULL default '0',
`evt_log_overwrite` varchar(30) NOT NULL default '',
`evt_log_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`evt_log_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`evt_log_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_event_log_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_firewall`
--

DROP TABLE IF EXISTS `sys_sw_firewall`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_firewall` (
`firewall_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`firewall_enabled_domain` varchar(45) NOT NULL default '',
`firewall_disablenotifications_domain` varchar(45) NOT NULL default '',
`firewall_donotallowexceptions_domain` varchar(45) NOT NULL default '',
`firewall_enabled_standard` varchar(45) NOT NULL default '',
`firewall_disablenotifications_standard` varchar(45) NOT NULL default '',
`firewall_donotallowexceptions_standard` varchar(45) NOT NULL default '',
`firewall_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`firewall_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`firewall_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_firewall_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_firewall_auth_app`
--

DROP TABLE IF EXISTS `sys_sw_firewall_auth_app`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_firewall_auth_app` (
`firewall_app_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`firewall_app_name` varchar(100) NOT NULL default '',
`firewall_app_executable` varchar(200) NOT NULL default '',
`firewall_app_remote_address` varchar(45) NOT NULL default '',
`firewall_app_enabled` varchar(45) NOT NULL default '',
`firewall_app_profile` varchar(45) NOT NULL default '',
`firewall_app_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`firewall_app_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`firewall_app_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_firewall_auth_app_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_firewall_ports`
--

DROP TABLE IF EXISTS `sys_sw_firewall_ports`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_firewall_ports` (
`port_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`port_number` int(10) unsigned NOT NULL default '0',
`port_protocol` varchar(45) NOT NULL default '',
`port_scope` varchar(45) NOT NULL default '',
`port_enabled` varchar(45) NOT NULL default '',
`port_profile` varchar(45) NOT NULL default '',
`port_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`port_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`port_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_firewall_ports_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_groups`
--

DROP TABLE IF EXISTS `sys_sw_groups`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_groups` (
`groups_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`groups_description` varchar(200) NOT NULL default '',
`groups_name` varchar(100) NOT NULL default '',
`groups_members` varchar(100) NOT NULL default '',
`groups_sid` varchar(100) NOT NULL default '',
`groups_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`groups_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`groups_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_groups_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_groups_details`
--

DROP TABLE IF EXISTS `sys_sw_groups_details`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_groups_details` (
`gd_name` varchar(100) NOT NULL default '',
`gd_description` varchar(200) NOT NULL default '',
PRIMARY KEY (`gd_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_ip_route`
--

DROP TABLE IF EXISTS `sys_sw_ip_route`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_ip_route` (
`ip_route_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`ip_route_destination` varchar(20) NOT NULL default '',
`ip_route_mask` varchar(20) NOT NULL default '',
`ip_route_metric` varchar(10) NOT NULL default '',
`ip_route_next_hop` varchar(20) NOT NULL default '',
`ip_route_protocol` varchar(10) NOT NULL default '',
`ip_route_type` varchar(10) NOT NULL default '',
`ip_route_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`ip_route_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`ip_route_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_ip_route_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_manual_software`
--

DROP TABLE IF EXISTS `sys_sw_manual_software`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_manual_software` (
`man_soft_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`man_soft_det_id` int(10) unsigned NOT NULL default '0',
`man_soft_version` varchar(45) NOT NULL default '',
`man_soft_filesize` int(10) unsigned NOT NULL default '0',
`man_soft_date_detected` date NOT NULL default '0000-00-00',
`man_soft_date_first_detected` date NOT NULL default '0000-00-00',
PRIMARY KEY (`man_soft_id`),
KEY `sys_sw_manual_software_system_id` (`system_id`),
CONSTRAINT `sys_sw_manual_software_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_manual_software_detection`
--

DROP TABLE IF EXISTS `sys_sw_manual_software_detection`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_manual_software_detection` (
`man_soft_det_id` int(10) unsigned NOT NULL auto_increment,
`man_soft_det_dir` varchar(45) NOT NULL default '',
`man_soft_det_file` varchar(45) NOT NULL default '',
`man_soft_det_name` varchar(45) NOT NULL default '',
`man_soft_det_comments` varchar(45) NOT NULL default '',
PRIMARY KEY (`man_soft_det_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_mapped`
--

DROP TABLE IF EXISTS `sys_sw_mapped`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_mapped` (
`mapped_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`mapped_device_id` varchar(100) NOT NULL default '',
`mapped_file_system` varchar(100) NOT NULL default '',
`mapped_provider_name` varchar(100) NOT NULL default '',
`mapped_free_space` int(10) unsigned NOT NULL default '0',
`mapped_size` int(10) unsigned NOT NULL default '0',
`mapped_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`mapped_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`mapped_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_mapped_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_media`
--

DROP TABLE IF EXISTS `sys_sw_media`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_media` (
`media_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`media_type` varchar(45) NOT NULL default '',
`media_file` varchar(250) NOT NULL default '',
`media_size` int(10) unsigned NOT NULL default '0',
`media_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`media_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_media_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_pagefile`
--

DROP TABLE IF EXISTS `sys_sw_pagefile`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_pagefile` (
`pagefile_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`pagefile_name` varchar(100) NOT NULL default '',
`pagefile_initial_size` int(10) NOT NULL default '0',
`pagefile_max_size` int(10) NOT NULL default '0',
`pagefile_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`pagefile_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`pagefile_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_pagefile_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_scheduled_task`
--

DROP TABLE IF EXISTS `sys_sw_scheduled_task`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_scheduled_task` (
`sched_task_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`sched_task_name` varchar(100) NOT NULL default '',
`sched_task_next_run` varchar(50) NOT NULL default '',
`sched_task_status` varchar(50) NOT NULL default '',
`sched_task_last_run` varchar(50) NOT NULL default '',
`sched_task_last_result` varchar(50) NOT NULL default '',
`sched_task_creator` varchar(50) NOT NULL default '',
`sched_task_schedule` varchar(100) NOT NULL default '',
`sched_task_task` varchar(100) NOT NULL default '',
`sched_task_state` varchar(10) NOT NULL default '',
`sched_task_runas` varchar(50) NOT NULL default '',
`sched_task_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`sched_task_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`sched_task_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_scheduled_task_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_service`
--

DROP TABLE IF EXISTS `sys_sw_service`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_service` (
`service_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`service_display_name` varchar(100) NOT NULL default '',
`service_name` varchar(100) NOT NULL default '',
`service_path_name` varchar(200) NOT NULL default '',
`service_started` varchar(10) NOT NULL default '',
`service_start_mode` varchar(10) NOT NULL default '',
`service_state` varchar(10) NOT NULL default '',
`service_count` varchar(5) NOT NULL default '',
`service_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`service_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`service_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_service_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_service_details`
--

DROP TABLE IF EXISTS `sys_sw_service_details`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_service_details` (
`sd_display_name` varchar(100) NOT NULL default '',
`sd_description` varchar(200) NOT NULL default '',
PRIMARY KEY (`sd_display_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_shares`
--

DROP TABLE IF EXISTS `sys_sw_shares`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_shares` (
`shares_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`shares_caption` varchar(100) NOT NULL default '',
`shares_name` varchar(100) NOT NULL default '',
`shares_path` varchar(100) NOT NULL default '',
`shares_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`shares_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`shares_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_shares_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_software`
--

DROP TABLE IF EXISTS `sys_sw_software`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_software` (
`software_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`software_name` varchar(256) NOT NULL default '',
`software_version` varchar(256) NOT NULL default '',
`software_location` varchar(256) NOT NULL default '',
`software_uninstall` mediumtext NOT NULL,
`software_install_date` varchar(100) NOT NULL default '',
`software_publisher` varchar(256) NOT NULL default '',
`software_install_source` varchar(200) NOT NULL default '',
`software_system_component` varchar(2) NOT NULL default '',
`software_url` varchar(256) NOT NULL default '',
`software_email` varchar(256) NOT NULL default '',
`software_comment` varchar(200) NOT NULL default '',
`software_man_comment` varchar(200) NOT NULL default '',
`software_count` varchar(5) NOT NULL default '',
`software_code_base` varchar(256) NOT NULL default '',
`software_status` varchar(45) NOT NULL default '',
`software_key` varchar(45) NOT NULL default '',
`software_key_release` varchar(45) NOT NULL default '',
`software_key_edition` varchar(45) NOT NULL default '',
`software_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`software_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`software_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_software_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_startup`
--

DROP TABLE IF EXISTS `sys_sw_startup`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_startup` (
`startup_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`startup_caption` varchar(200) NOT NULL default '',
`startup_name` varchar(100) NOT NULL default '',
`startup_command` varchar(200) NOT NULL default '',
`startup_description` varchar(200) NOT NULL default '',
`startup_location` varchar(200) NOT NULL default '',
`startup_user` varchar(100) NOT NULL default '',
`startup_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`startup_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`startup_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_startup_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_system_security`
--

DROP TABLE IF EXISTS `sys_sw_system_security`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_system_security` (
`ss_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`ss_qno` varchar(45) NOT NULL default '',
`ss_status` varchar(45) NOT NULL default '',
`ss_reason` varchar(200) NOT NULL default '',
`ss_product` varchar(45) NOT NULL default '',
`ss_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`ss_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`ss_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_system_security_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_system_security_bulletins`
--

DROP TABLE IF EXISTS `sys_sw_system_security_bulletins`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_system_security_bulletins` (
`ssb_title` varchar(200) NOT NULL default '',
`ssb_description` text NOT NULL,
`ssb_bulletin` varchar(45) NOT NULL default '',
`ssb_qno` varchar(45) NOT NULL default '',
`ssb_url` varchar(100) NOT NULL default '',
PRIMARY KEY (`ssb_qno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_users`
--

DROP TABLE IF EXISTS `sys_sw_users`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_users` (
`users_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`users_disabled` varchar(20) NOT NULL default '',
`users_full_name` varchar(100) NOT NULL default '',
`users_name` varchar(100) NOT NULL default '',
`users_password_changeable` varchar(20) NOT NULL default '',
`users_password_expires` varchar(20) NOT NULL default '',
`users_password_required` varchar(20) NOT NULL default '',
`users_sid` varchar(100) NOT NULL default '',
`users_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`users_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`users_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_users_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_users_detail`
--

DROP TABLE IF EXISTS `sys_sw_users_detail`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_users_detail` (
`ud_name` varchar(100) NOT NULL default '',
`ud_description` varchar(200) NOT NULL default '',
PRIMARY KEY (`ud_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_web_server`
--

DROP TABLE IF EXISTS `sys_sw_web_server`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_web_server` (
`ws_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`ws_site` int(10) unsigned NOT NULL default '0',
`ws_server_type` varchar(100) NOT NULL default '',
`ws_description` varchar(100) NOT NULL default '',
`ws_logging_enabled` varchar(100) NOT NULL default '',
`ws_logging_dir` varchar(100) NOT NULL default '',
`ws_logging_format` varchar(100) NOT NULL default '',
`ws_logging_time_period` varchar(100) NOT NULL default '',
`ws_home_directory` varchar(100) NOT NULL default '',
`ws_directory_browsing` varchar(100) NOT NULL default '',
`ws_default_documents` varchar(100) NOT NULL default '',
`ws_secure_ip` varchar(100) NOT NULL default '',
`ws_secure_port` varchar(100) NOT NULL default '',
`ws_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`ws_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`ws_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_web_server_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_web_server_ip`
--

DROP TABLE IF EXISTS `sys_sw_web_server_ip`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_web_server_ip` (
`ws_ip_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`ws_ip_site` varchar(100) NOT NULL default '',
`ws_ip_address` varchar(30) NOT NULL default '',
`ws_ip_port` varchar(100) NOT NULL default '',
`ws_ip_host_header` varchar(100) NOT NULL default '',
`ws_ip_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`ws_ip_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`ws_ip_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_web_server_ip_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_web_server_vd`
--

DROP TABLE IF EXISTS `sys_sw_web_server_vd`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_web_server_vd` (
`ws_vd_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`ws_vd_site` varchar(100) NOT NULL default '',
`ws_vd_name` varchar(100) NOT NULL default '',
`ws_vd_path` varchar(100) NOT NULL default '',
`ws_vd_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`ws_vd_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`ws_vd_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_web_server_vd_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sys_sw_windows`
--

DROP TABLE IF EXISTS `sys_sw_windows`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_windows` (
`windows_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`windows_build_number` varchar(20) NOT NULL default '',
`windows_user_name` varchar(100) NOT NULL default '',
`windows_client_site_name` varchar(100) NOT NULL default '',
`windows_domain_controller_address` varchar(100) NOT NULL default '',
`windows_domain_controller_name` varchar(100) NOT NULL default '',
`windows_domain_role` varchar(40) NOT NULL default '',
`windows_part_of_domain` varchar(10) NOT NULL default '',
`windows_id_number` varchar(100) NOT NULL default '',
`windows_time_caption` varchar(100) NOT NULL default '',
`windows_time_daylight` varchar(100) NOT NULL default '',
`windows_boot_device` varchar(100) NOT NULL default '',
`windows_country_code` varchar(50) NOT NULL default '',
`windows_organisation` varchar(80) NOT NULL default '',
`windows_language` varchar(50) NOT NULL default '',
`windows_registered_user` varchar(50) NOT NULL default '',
`windows_service_pack` varchar(20) NOT NULL default '',
`windows_version` varchar(20) NOT NULL default '',
`windows_install_directory` varchar(20) NOT NULL default '',
`windows_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`windows_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`windows_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_windows_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `system`
--

DROP TABLE IF EXISTS `system`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `system` (
`system_id` int(10) unsigned NOT NULL auto_increment,
`system_key` varchar(200) NOT NULL default '',
`uuid` varchar(100) NOT NULL default '',
`mac_address` varchar(17) NOT NULL default '',
`ip_address` varchar(30) NOT NULL default '',
`hostname` varchar(100) NOT NULL default '',
`domain` varchar(100) NOT NULL default '',
`description` varchar(100) NOT NULL default '',
`type` varchar(50) NOT NULL default '',
`icon` varchar(50) NOT NULL default '',
`os` varchar(50) NOT NULL default '',
`os_short_name` varchar(50) NOT NULL default '',
`os_full_name` varchar(100) NOT NULL default '',
`os_version` varchar(50) NOT NULL default '',
`linked_sys` int(10) NOT NULL default '0',
`serial` varchar(50) NOT NULL default '',
`model` varchar(50) NOT NULL default '',
`manufacturer` varchar(50) NOT NULL default '',
`form_factor` varchar(50) NOT NULL default '',
`pc_memory` int(10) NOT NULL default '0',
`pc_num_processor` int(10) NOT NULL default '0',
`pc_date_os_installation` date NOT NULL default '1970-01-01',
`printer_port_name` varchar(50) NOT NULL default '',
`printer_shared` varchar(50) NOT NULL default '',
`printer_shared_name` varchar(50) NOT NULL default '',
`man_acting_server` varchar(3) NOT NULL default '',
`man_status` ENUM('production', 'retired', 'maintenance', 'deleted') NOT NULL default 'production',
`man_environment` ENUM('production', 'test', 'uat', 'dev', 'eval', 'DR') NOT NULL default 'production',
`man_criticality` ENUM('critical', 'normal', 'low') NOT NULL default 'critical',
`man_description` varchar(100) NOT NULL default '',
`man_type` varchar(100) NOT NULL default '',
`man_ip_address` varchar(30) NOT NULL default '',
`man_location_name` varchar(100) NOT NULL default '',
`man_location_address` varchar(100) NOT NULL default '',
`man_location_city` varchar(100) NOT NULL default '',
`man_location_state` varchar(100) NOT NULL default '',
`man_location_country` varchar(100) NOT NULL default '',
`man_location_room` varchar(100) NOT NULL default '',
`man_location_rack` varchar(100) NOT NULL default '',
`man_serial` varchar(50) NOT NULL default '',
`man_asset_number` varchar(50) NOT NULL default '',
`man_model` varchar(50) NOT NULL default '',
`man_manufacturer` varchar(50) NOT NULL default '',
`man_form_factor` varchar(50) NOT NULL default '',
`man_icon` varchar(50) NOT NULL default '',
`man_vendor` varchar(150) NOT NULL default '',
`man_vm_server_name` varchar(150) NOT NULL default '',
`man_vm_system_id` varchar(150) NOT NULL default '',
`man_vm_group` varchar(150) NOT NULL default '',
`man_cluster_name` varchar(150) NOT NULL default '',
`man_purchase_order_number` varchar(50) NOT NULL default '',
`man_purchase_vendor` varchar(100) NOT NULL default '',
`man_purchase_invoice` varchar(100) NOT NULL default '',
`man_purchase_date` date NOT NULL default '0000-00-00',
`man_purchase_amount` varchar(50) NOT NULL default '',
`man_warranty_duration` int(5) unsigned NOT NULL default '0',
`man_warranty_expires` date NOT NULL default '0000-00-00',
`man_warranty_type` ENUM('', '24x7x365', '9x5x5', 'Next Business Day') NOT NULL default '',
`man_terminal_number` int(10) NOT NULL default '0',
`man_switch_id` varchar(100) NOT NULL default '',
`man_switch_port` varchar(100) NOT NULL default '',
`man_ethernet_socket` varchar(45) NOT NULL default '',
`man_wall_port` varchar(100) NOT NULL default '',
`man_picture` varchar(100) NOT NULL default '',
`man_contact_name` varchar(100) NOT NULL default '',
`man_contact_organisation` varchar(100) NOT NULL default '',
`man_contact_phone_number` varchar(20) NOT NULL default '',
`man_contact_address` varchar(100) NOT NULL default '',
`man_contact_city` varchar(100) NOT NULL default '',
`man_contact_state` varchar(100) NOT NULL default '',
`man_contact_country` varchar(100) NOT NULL default '',
`timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`system_id`),
KEY `id` (`timestamp`),
KEY `id2` (`system_key`),
KEY `id3` (`ip_address`),
KEY `system_id` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;


LOCK TABLES `oa_config` WRITE;
INSERT INTO `oa_config` VALUES ('oa_debug','off');
UNLOCK TABLES;

LOCK TABLES `oa_group` WRITE;

INSERT INTO `oa_group` VALUES (1,'All','s','',1,'Administrator','All','','','','','','',0);

INSERT INTO `oa_group` VALUES (10,'DNS Servers','d','SELECT distinct(system.system_id) FROM system, sys_sw_software WHERE sys_sw_software.software_name = \'bind9\' AND system.system_id = sys_sw_software.system_id AND system.timestamp = sys_sw_software.software_timestamp AND system.man_status = \'production\'',1,'Administrator','DNS','','','','','','',0);

INSERT INTO `oa_group` VALUES (11,'DHCP Servers','d','SELECT distinct(system.system_id) FROM system, sys_sw_software WHERE sys_sw_software.software_name = \'DHCP\' AND system.system_id = sys_sw_software.system_id AND system.timestamp = sys_sw_software.software_timestamp AND system.man_status = \'production\'',1,'Administrator','DHCP','','','','','','',0);

INSERT INTO `oa_group` VALUES (12,'Web Servers','d','SELECT distinct(system.system_id) FROM system, sys_sw_software WHERE (sys_sw_software.software_name LIKE \'apache%\' OR sys_sw_software.software_name = \'IIS\') AND system.system_id = sys_sw_software.system_id AND system.timestamp = sys_sw_software.software_timestamp AND system.man_status = \'production\'',1,'Administrator','Web','','','','','','',0);

INSERT INTO `oa_group` VALUES (13,'Database Servers','d','SELECT distinct(system.system_id) FROM system, sys_sw_software WHERE (sys_sw_software.software_name LIKE \'SQL Server%\' OR sys_sw_software.software_name LIKE \'mysql-server%\') AND system.system_id = sys_sw_software.system_id AND system.timestamp = sys_sw_software.software_timestamp AND system.man_status = \'production\'',1,'Administrator','Database','','','','','','',0);

INSERT INTO `oa_group` VALUES (14,'SSH Servers','d','SELECT distinct(system.system_id) FROM system, sys_sw_software WHERE sys_sw_software.software_name = \'openssh-server\' AND system.system_id = sys_sw_software.system_id AND system.timestamp = sys_sw_software.software_timestamp AND system.man_status = \'production\'',1,'Administrator','SSH','','','','','','',0);

INSERT INTO `oa_group` VALUES (15,'Windows Systems','d','SELECT distinct(system.system_id) FROM system WHERE system.os = \'windows\' AND system.man_status = \'production\'',1,'Administrator','Windows','','','','','','',0);

INSERT INTO `oa_group` VALUES (16,'Linux Systems','d','SELECT distinct(system.system_id) FROM system WHERE system.os = \'linux\' AND system.man_status = \'production\'',1,'Administrator','Linux','','','','','','',0);

ALTER TABLE `oa_group` AUTO_INCREMENT = 1000;

UNLOCK TABLES;

LOCK TABLES `oa_group_user` WRITE;
INSERT INTO `oa_group_user` VALUES (1,1,1,10);
INSERT INTO `oa_group_user` VALUES (2,1,10,10);
INSERT INTO `oa_group_user` VALUES (3,1,11,10);
INSERT INTO `oa_group_user` VALUES (4,1,12,10);
INSERT INTO `oa_group_user` VALUES (5,1,13,10);
INSERT INTO `oa_group_user` VALUES (6,1,14,10);
INSERT INTO `oa_group_user` VALUES (7,1,15,10);
INSERT INTO `oa_group_user` VALUES (8,1,16,10);
UNLOCK TABLES;

LOCK TABLES `oa_user` WRITE;
INSERT INTO `oa_user` VALUES (1,'admin','5f4dcc3b5aa765d61d8327deb882cf99','Administrator',NULL,'en',10,'default');
UNLOCK TABLES;




/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

[/code]
Author:  qc_metal [ Fri Oct 17, 2008 12:51 am ]
Post subject:  Re: OAv2
Fantastic screenshots, Mark!

I'm glad you opted for not doing the 'fancy-shmancy' Flash/Flex based site...why? My current BlackBerry and maybe some other mobile browsers would not like it so well.

Kudos to you - I think it is important to keep it simple on the rendering end in order to make it compatible with the maximum amount of browsers.
Author:  qc_metal [ Fri Oct 17, 2008 12:52 am ]
Post subject:  Re: OAv2
You know..."groups" looks suspiciously like "keywords" or "tags"...
Author:  Mark [ Fri Oct 17, 2008 7:28 am ]
Post subject:  Re: OAv2
[quote]You know..."groups" looks suspiciously like "keywords" or "tags"...
Very much so. The pre-defined ones, anyway.
There is the ability to set a group based on any field in the DB, as well as simple static groups.
Am debating on adding more pre-defined groups, and having them show as "tags", in one column - with "user defined" groups in another column.
If you check the second post above, containing the SQL, at the end you'll see the pre-defined groups. If anyone would like others, let me know.

That reads like crap, but it's early morning here, and I've not finished my coffee !! You know what I mean... :-)
Author:  jhurd8025 [ Wed Oct 22, 2008 3:22 am ]
Post subject:  Re: OAv2
Hey Mark,

I know OAv2 is down the road quite a bit. Is there any chance at making a OAv1 layout update including the new horizontal nav bar with the search included at the top?
Author:  msthursday [ Wed Oct 22, 2008 3:54 am ]
Post subject:  Re: OAv2
Hi Mark!
I'm a brand new user. I'm really excited about Open-Audit and I can't wait to see the changes in the next version.

Thanks for all the work you do on this.
Amanda
Author:  Chad [ Fri Oct 24, 2008 11:26 am ]
Post subject:  Re: OAv2
Just out of curiousity, how is it that you are auditing windows workstations from a linux box in OAv2?

I started to experiment with winexe and found that I could easily send my audit.vbs and audit.config to the machine I want to audit using smbclient then just run it with winexe. However, it seems kind of messy using smbclient to transfer the files that way. Maybe netcat or even using wmi-client could help make this more elegant? I dunno. However, from this point it's pretty feasible to throw together a script using adtool on linux (or in the case of OAv2, I would gather this is just queried using the ldap functions already in PHP) to gather a list of computers in the domain and then query each one using smbclient and winexe. Full domain audit on linux = awesome :)

Anyways, just curious how you're pulling this off from a technical perspective.
Page 2 of 4 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/