Open-AudIT

What's on your network?
It is currently Thu Apr 19, 2018 9:48 pm

All times are UTC + 10 hours




Post new topic Reply to topic  [ 51 posts ]  Go to page Previous  1, 2, 3, 4  Next
Author Message
 Post subject: Re: OAv2
PostPosted: Sat Sep 20, 2008 5:45 pm 
Offline
Newbie

Joined: Sat Sep 20, 2008 5:05 pm
Posts: 1
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


Top
 Profile  
Reply with quote  
 Post subject: Re: OAv2
PostPosted: Sun Oct 05, 2008 12:03 am 
Offline
Newbie

Joined: Tue Dec 14, 2004 12:05 am
Posts: 2
Location: NY
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.


Top
 Profile  
Reply with quote  
 Post subject: Re: OAv2
PostPosted: Thu Oct 09, 2008 6:12 am 
Offline
Helper

Joined: Sat Sep 17, 2005 7:15 am
Posts: 71
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...

_________________
Server Info:
OS : Windows Server 2003
Auditing: ~300 machines
LDAP: Windows Server 2003 Active Directory


Top
 Profile  
Reply with quote  
 Post subject: Re: OAv2
PostPosted: Thu Oct 16, 2008 12:49 am 
Offline
Contributor

Joined: Fri Sep 28, 2007 12:07 am
Posts: 189
me too...very excited.

_________________
OA Deployment:
Windows 2003 with XAMPP install
80 Windows Servers
250 Windows workstations (mixed XP and 2000)
5 MACs
Multiple printers, switches, routers, firewalls, and other servers (ESX, AIX etc.)


Top
 Profile  
Reply with quote  
 Post subject: Re: OAv2
PostPosted: Thu Oct 16, 2008 2:55 pm 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1944
Location: Brisbane, Australia
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 4130 times ]
current_list.png
current_list.png [ 40.23 KiB | Viewed 4126 times ]

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.
Top
 Profile  
Reply with quote  
 Post subject: Re: OAv2
PostPosted: Thu Oct 16, 2008 3:28 pm 
Offline
Helper

Joined: Fri Jun 06, 2008 3:02 pm
Posts: 79
Location: Singapore
mark we are so excited to get hold of it :) is there any tentative date on release of beta or something?

_________________
**---((( SGR )))---****
Server Info:
OS : CentoS 5
Auditing: 1143 machines
LDAP: Active Directory
Support Open-Audit : http://www.open-audit.org/phpBB3/viewtopic.php?f=5&t=2990#p13523


Top
 Profile  
Reply with quote  
 Post subject: Re: OAv2
PostPosted: Thu Oct 16, 2008 3:40 pm 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1944
Location: Brisbane, Australia
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.

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
 Post subject: Re: OAv2
PostPosted: Thu Oct 16, 2008 3:43 pm 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1944
Location: Brisbane, Australia
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;

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
 Post subject: Re: OAv2
PostPosted: Thu Oct 16, 2008 3:44 pm 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1944
Location: Brisbane, Australia
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 */;


_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
 Post subject: Re: OAv2
PostPosted: Fri Oct 17, 2008 12:51 am 
Offline
Helper

Joined: Sat Sep 17, 2005 7:15 am
Posts: 71
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.


Top
 Profile  
Reply with quote  
 Post subject: Re: OAv2
PostPosted: Fri Oct 17, 2008 12:52 am 
Offline
Helper

Joined: Sat Sep 17, 2005 7:15 am
Posts: 71
You know..."groups" looks suspiciously like "keywords" or "tags"...

_________________
Server Info:
OS : Windows Server 2003
Auditing: ~300 machines
LDAP: Windows Server 2003 Active Directory


Top
 Profile  
Reply with quote  
 Post subject: Re: OAv2
PostPosted: Fri Oct 17, 2008 7:28 am 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1944
Location: Brisbane, Australia
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... :-)

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
 Post subject: Re: OAv2
PostPosted: Wed Oct 22, 2008 3:22 am 
Offline
Helper

Joined: Fri Nov 16, 2007 1:32 am
Posts: 73
Location: Dallas,Texas
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?

_________________
1400 Servers Audited (1 hour interval) Applied via a local scheduler, deployed via GPO.
Running OA on IIS6 Web Server
90% Windows 2k3 Server (std,ent)
5% Windows XP
5% Windows 2000


Top
 Profile  
Reply with quote  
 Post subject: Re: OAv2
PostPosted: Wed Oct 22, 2008 3:54 am 
Offline
Newbie

Joined: Wed Oct 22, 2008 3:25 am
Posts: 1
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


Top
 Profile  
Reply with quote  
 Post subject: Re: OAv2
PostPosted: Fri Oct 24, 2008 11:26 am 
Offline
Contributor

Joined: Fri Jul 04, 2008 6:46 am
Posts: 153
Location: USA - WI
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.

_________________
OA Server: Debian Squeeze w/ Apache2
Auditing: 700 Workstations, 250 or so Retail Terminals, about 75 Servers
OS's: Windows XP/2003/2008/2008 R2/Vista/7, Debian
LDAP: Active Directory 2008 R2


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 51 posts ]  Go to page Previous  1, 2, 3, 4  Next

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group