Versions Compared

Old Version 4

changes.mady.by.user Mark Unwin

Saved on

compared with

New Version 5

changes.mady.by.user Mark Unwin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

As per all new items, they are also viewable and usable via the JSON API at /scripts.

What are the changes to the system table?

Here are the old and new table definitions. Note the column order is different as shown here compared to the actual table. Here I have sorted by name so you can more directly compare them.

Major items of note.

  • There is no system_id column. It has been renamed id. You can imagine the work here. The entire application revolves around system_id. This is the largest single change.
  • The man_* fields have been removed. We now have a routine that runs whenever an attribute has data posted to it. It "weighs" the importance of the thing performing the data push and if it's not less than what it already has, does not update the data. More details on the below.
  • Fields stick to a format of:
    • Anything ending in id, size or count (or being id, size or count) is an integer.
    • Enum fields are 'y' or 'n' only instead or string true or false or some other variation.
  • Access Details has been removed. We now have credential sets and store device specific credentials in the credential table (more details below).
  • Instead of only hostname and sysName columns, we now have name, hostname, dns_hostname and sysName (more details below). Name has been initially populated (for upgrades) by the existing value for hostname.
  • timestamp has been replaced by last_seen.
  • fiirst_timestamp has been replaced by first_seen.
  • man_ip_address has been replaced by ip.

 

Nmap Open Ports and Programs

Are now stored when Discovery is run. They are stored and updated as per any other attribute within Open-AudIT. The database tabel is nmap.

Bootstrap Theme

We are steadily progressing towards retheming Open-AudIT to use Bootstrap. Going along with that is the ability to update and streamline both our code and our libraries. For example the old Tango theme prevented us from updating to a newer version of jQuery (javascript framework). All Bootstrap pages are being validated as w3c compliant. Work is not complete so you will see some pages in Bootstrap and some in Tango. We're planning to replace all Tango pages eventually. Please bear with us in this time of transition.

What are the changes to the system table?

Here are the old and new table definitions. Note the column order is different as shown here compared to the actual table. Here I have sorted by name so you can more directly compare them.

Major items of note.

  • There is no system_id column. It has been renamed id. You can imagine the work here. The entire application revolves around system_id. This is the largest single change.
  • The man_* fields have been removed. We now have a routine that runs whenever an attribute has data posted to it. It "weighs" the importance of the thing performing the data push and if it's not less than what it already has, does not update the data. More details on the below.
  • Fields stick to a format of:
    • Anything ending in id, size or count (or being id, size or count) is an integer.
    • Enum fields are 'y' or 'n' only instead or string true or false or some other variation.
  • Access Details has been removed. We now have credential sets and store device specific credentials in the credential table (more details below).
  • Instead of only hostname and sysName columns, we now have name, hostname, dns_hostname and sysName (more details below). Name has been initially populated (for upgrades) by the existing value for hostname.
  • timestamp has been replaced by last_seen.
  • fiirst_timestamp has been replaced by first_seen.
  • man_ip_address has been replaced by ip.

 

1.1.12.61.12.8
Code Block
`access_details` text NOT NULL,
 `comments` text NOT NULL,
 `contact_id` int(10) unsigned NOT NULL DEFAULT '0',
 `contact_name` varchar(50) NOT NULL DEFAULT '',
 `dbus_identifier` varchar(255) NOT NULL DEFAULT '',
 `description` text NOT NULL,
 `domain` varchar(100) NOT NULL DEFAULT '',
 `first_timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 `form_factor` varchar(50) NOT NULL DEFAULT '',
 `fqdn` text NOT NULL,
 `hostname` varchar(100) NOT NULL DEFAULT '',
 `icon` varchar(50) NOT NULL DEFAULT '',
 `invoice_id` int(10) unsigned DEFAULT NULL,
 `last_seen_by` varchar(150) NOT NULL DEFAULT '',
 `last_seen` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 `last_user` varchar(150) NOT NULL DEFAULT '',
 `linked_sys` int(10) NOT NULL DEFAULT '0',
 `man_asset_number` varchar(50) NOT NULL DEFAULT '',
 `man_class` enum('desktop','laptop','tablet','workstation','server','virtual server','virtual desktop','','hypervisor') NOT NULL DEFAULT '',
 `man_cluster_name` varchar(150) NOT NULL DEFAULT '',
 `man_criticality` enum('critical','normal','low') NOT NULL DEFAULT 'normal',
 `man_description` text NOT NULL,
 `man_domain` varchar(100) NOT NULL DEFAULT '',
 `man_environment` enum('production','dev','dr','eval','pre-prod','test','train','uat') NOT NULL DEFAULT 'production',
 `man_form_factor` varchar(50) NOT NULL DEFAULT '',
 `man_function` varchar(100) NOT NULL DEFAULT '',
 `man_ip_address` varchar(30) NOT NULL DEFAULT '',
 `man_lease_expiry_date` date NOT NULL DEFAULT '0000-00-00',
 `man_location_id` int(10) unsigned NOT NULL DEFAULT '0',
 `man_location_latitude` float(10,6) NOT NULL,
 `man_location_level` varchar(100) NOT NULL DEFAULT '',
 `man_location_longitude` float(10,6) NOT NULL,
 `man_location_rack_position` varchar(100) NOT NULL DEFAULT '',
 `man_location_rack_size` int(10) unsigned NOT NULL DEFAULT '0',
 `man_location_rack` varchar(100) NOT NULL DEFAULT '',
 `man_location_room` varchar(100) NOT NULL DEFAULT '',
 `man_location_suite` varchar(100) NOT NULL DEFAULT '',
 `man_manufacturer` varchar(50) NOT NULL DEFAULT '',
 `man_model` varchar(50) NOT NULL DEFAULT '',
 `man_oae_manage` enum('y','n') NOT NULL DEFAULT 'y',
 `man_org_id` int(10) unsigned NOT NULL DEFAULT '0',
 `man_os_family` varchar(50) NOT NULL DEFAULT '',
 `man_os_group` varchar(50) NOT NULL DEFAULT '',
 `man_os_name` varchar(100) NOT NULL DEFAULT '',
 `man_owner` varchar(100) NOT NULL DEFAULT '',
 `man_patch_panel_port` varchar(45) NOT NULL DEFAULT '',
 `man_patch_panel` varchar(45) NOT NULL DEFAULT '',
 `man_picture` varchar(100) NOT NULL DEFAULT '',
 `man_purchase_amount` varchar(50) NOT NULL DEFAULT '',
 `man_purchase_cost_center` varchar(50) NOT NULL DEFAULT '',
 `man_purchase_date` date NOT NULL DEFAULT '0000-00-00',
 `man_purchase_invoice` varchar(50) NOT NULL DEFAULT '',
 `man_purchase_order_number` varchar(50) NOT NULL DEFAULT '',
 `man_purchase_service_contract_number` varchar(255) NOT NULL DEFAULT '',
 `man_purchase_vendor` varchar(100) NOT NULL DEFAULT '',
 `man_serial_imei` varchar(100) NOT NULL DEFAULT '',
 `man_serial_sim` varchar(100) NOT NULL DEFAULT '',
 `man_serial` varchar(250) NOT NULL DEFAULT '',
 `man_service_network` varchar(100) NOT NULL DEFAULT '',
 `man_service_number` varchar(100) NOT NULL DEFAULT '',
 `man_service_plan` varchar(100) NOT NULL DEFAULT '',
 `man_service_provider` varchar(100) NOT NULL DEFAULT '',
 `man_service_type` varchar(100) NOT NULL DEFAULT '',
 `man_status` enum('production','deleted','lost','maintenance','retired','unallocated') NOT NULL DEFAULT 'production',
 `man_switch_id` varchar(100) NOT NULL DEFAULT '',
 `man_switch_port` varchar(100) NOT NULL DEFAULT '',
 `man_terminal_number` int(10) NOT NULL DEFAULT '0',
 `man_type` varchar(100) NOT NULL DEFAULT '',
 `man_unlock_pin` varchar(100) NOT NULL DEFAULT '',
 `man_vm_group` varchar(150) NOT NULL DEFAULT '',
 `man_vm_server_name` varchar(150) NOT NULL DEFAULT '',
 `man_vm_system_id` varchar(150) NOT NULL DEFAULT '',
 `man_wall_port` varchar(100) 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 '',
 `manufacturer` varchar(50) NOT NULL DEFAULT '',
 `model` varchar(200) NOT NULL DEFAULT '',
 `nmap_type` varchar(50) NOT NULL DEFAULT '',
 `nmis_export` enum('true','false') NOT NULL DEFAULT 'false',
 `nmis_group` varchar(50) NOT NULL DEFAULT '',
 `nmis_name` varchar(50) NOT NULL DEFAULT '',
 `nmis_role` varchar(50) NOT NULL DEFAULT '',
 `os_family` varchar(50) NOT NULL DEFAULT '',
 `os_group` varchar(50) NOT NULL DEFAULT '',
 `os_name` varchar(100) NOT NULL DEFAULT '',
 `os_version` varchar(50) NOT NULL DEFAULT '',
 `pc_date_os_installation` date NOT NULL DEFAULT '0000-00-00',
 `pc_memory` int(10) NOT NULL DEFAULT '0',
 `pc_num_processor` int(10) NOT NULL DEFAULT '0',
 `pc_os_bit` varchar(3) NOT NULL DEFAULT '',
 `printer_color` varchar(5) NOT NULL DEFAULT '',
 `printer_duplex` varchar(5) NOT NULL DEFAULT '',
 `printer_port_name` varchar(50) NOT NULL DEFAULT '',
 `printer_shared_name` varchar(50) NOT NULL DEFAULT '',
 `printer_shared` varchar(50) NOT NULL DEFAULT '',
 `serial` varchar(250) NOT NULL DEFAULT '',
 `snmp_oid` text NOT NULL,
 `sysContact` varchar(255) NOT NULL DEFAULT '',
 `sysDescr` text NOT NULL,
 `sysLocation` varchar(255) NOT NULL DEFAULT '',
 `sysName` varchar(255) NOT NULL DEFAULT '',
 `sysObjectID` varchar(255) NOT NULL DEFAULT '',
 `system_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `system_key_type` varchar(4) NOT NULL DEFAULT '',
 `system_key` varchar(200) NOT NULL DEFAULT '',
 `sysUpTime` varchar(255) NOT NULL DEFAULT '',
 `timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 `type` varchar(50) NOT NULL DEFAULT '',
 `uptime` varchar(50) NOT NULL DEFAULT '',
 `uuid` varchar(100) NOT NULL DEFAULT '',

 

 

Code Block
`asset_number` varchar(50) NOT NULL DEFAULT '',
 `attached_system_id` int(10) DEFAULT NULL,
 `class` enum('desktop','laptop','tablet','workstation','server','virtual server','virtual desktop','hypervisor','') NOT NULL DEFAULT '',
 `cluster_name` varchar(150) NOT NULL DEFAULT '',
 `cluster_type` varchar(150) NOT NULL DEFAULT '',
 `comments` text NOT NULL,
 `contact_name` varchar(50) NOT NULL DEFAULT '',
 `dbus_identifier` varchar(255) NOT NULL DEFAULT '',
 `description` text NOT NULL,
 `dns_domain` varchar(100) NOT NULL DEFAULT '',
 `dns_hostname` varchar(100) NOT NULL DEFAULT '',
 `domain` varchar(100) NOT NULL DEFAULT '',
 `environment` enum('production','dev','dr','eval','pre-prod','test','train','uat') NOT NULL DEFAULT 'production',
 `first_seen` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 `form_factor` varchar(50) NOT NULL DEFAULT '',
 `fqdn` text NOT NULL,
 `function` varchar(100) NOT NULL DEFAULT '',
 `hostname` varchar(100) NOT NULL DEFAULT '',
 `icon` varchar(50) NOT NULL DEFAULT '',
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `invoice_id` int(10) unsigned DEFAULT NULL,
 `ip` varchar(45) NOT NULL DEFAULT '',
 `last_seen_by` varchar(150) NOT NULL DEFAULT '',
 `last_seen` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 `last_user` varchar(150) NOT NULL DEFAULT '',
 `lease_expiry_date` date NOT NULL DEFAULT '0000-00-00',
 `location_id` int(10) unsigned NOT NULL DEFAULT '0',
 `location_latitude` float(10,6) NOT NULL,
 `location_level` varchar(100) NOT NULL DEFAULT '',
 `location_longitude` float(10,6) NOT NULL,
 `location_rack_position` varchar(100) NOT NULL DEFAULT '',
 `location_rack_size` int(10) unsigned NOT NULL DEFAULT '0',
 `location_rack` varchar(100) NOT NULL DEFAULT '',
 `location_room` varchar(100) NOT NULL DEFAULT '',
 `location_suite` varchar(100) NOT NULL DEFAULT '',
 `manufacturer` varchar(100) NOT NULL DEFAULT '',
 `memory_count` int(10) unsigned NOT NULL DEFAULT '0',
 `model` varchar(200) NOT NULL DEFAULT '',
 `name` varchar(100) NOT NULL DEFAULT '',
 `nmis_export` enum('y','n') NOT NULL DEFAULT 'n',
 `nmis_group` varchar(50) NOT NULL DEFAULT '',
 `nmis_name` varchar(50) NOT NULL DEFAULT '',
 `nmis_role` varchar(50) NOT NULL DEFAULT '',
 `oae_manage` enum('y','n') NOT NULL DEFAULT 'y',
 `org_id` int(10) unsigned NOT NULL DEFAULT '0',
 `os_bit` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `os_family` varchar(50) NOT NULL DEFAULT '',
 `os_group` varchar(50) NOT NULL DEFAULT '',
 `os_installation_date` date NOT NULL DEFAULT '0000-00-00',
 `os_name` varchar(100) NOT NULL DEFAULT '',
 `os_version` varchar(50) NOT NULL DEFAULT '',
 `owner` varchar(100) NOT NULL DEFAULT '',
 `patch_panel_port` int(10) unsigned NOT NULL DEFAULT '0',
 `patch_panel` varchar(45) NOT NULL DEFAULT '',
 `printer_color` enum('y','n','') NOT NULL DEFAULT '',
 `printer_duplex` enum('y','n','') NOT NULL DEFAULT '',
 `printer_port_name` varchar(50) NOT NULL DEFAULT '',
 `printer_shared_name` varchar(50) NOT NULL DEFAULT '',
 `printer_shared` varchar(50) NOT NULL DEFAULT '',
 `processor_count` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `purchase_amount` varchar(50) NOT NULL DEFAULT '',
 `purchase_cost_center` varchar(50) NOT NULL DEFAULT '',
 `purchase_date` date NOT NULL DEFAULT '0000-00-00',
 `purchase_invoice` varchar(50) NOT NULL DEFAULT '',
 `purchase_order_number` varchar(50) NOT NULL DEFAULT '',
 `purchase_service_contract_number` varchar(255) NOT NULL DEFAULT '',
 `purchase_vendor` varchar(100) NOT NULL DEFAULT '',
 `serial_imei` varchar(100) NOT NULL DEFAULT '',
 `serial_sim` varchar(100) NOT NULL DEFAULT '',
 `serial` varchar(200) NOT NULL DEFAULT '',
 `service_network` varchar(100) NOT NULL DEFAULT '',
 `service_number` varchar(100) NOT NULL DEFAULT '',
 `service_plan` varchar(100) NOT NULL DEFAULT '',
 `service_provider` varchar(100) NOT NULL DEFAULT '',
 `service_type` varchar(100) NOT NULL DEFAULT '',
 `snmp_oid` text NOT NULL,
 `status` enum('production','deleted','lost','maintenance','retired','unallocated') NOT NULL DEFAULT 'production',
 `switch_port` int(10) unsigned NOT NULL DEFAULT '0',
 `switch_system_id` int(10) DEFAULT NULL,
 `sysContact` varchar(255) NOT NULL DEFAULT '',
 `sysDescr` text NOT NULL,
 `sysLocation` varchar(255) NOT NULL DEFAULT '',
 `sysName` varchar(255) NOT NULL DEFAULT '',
 `sysObjectID` varchar(255) NOT NULL DEFAULT '',
 `sysUpTime` varchar(255) NOT NULL DEFAULT '',
 `type` varchar(50) NOT NULL DEFAULT '',
 `unlock_pin` varchar(100) NOT NULL DEFAULT '',
 `uptime` varchar(50) NOT NULL DEFAULT '',
 `uuid` varchar(100) NOT NULL DEFAULT '',
 `vm_group` varchar(150) NOT NULL DEFAULT '',
 `vm_server_name` varchar(150) NOT NULL DEFAULT '',
 `vm_system_id` int(10) unsigned DEFAULT NULL,
 `wall_port` varchar(100) NOT NULL DEFAULT '',
 `warranty_duration` int(5) unsigned NOT NULL DEFAULT '0',
 `warranty_expires` date NOT NULL DEFAULT '0000-00-00',
 `warranty_type` enum('','24x7x365','9x5x5','Next Business Day') NOT NULL DEFAULT '',

 

Change Notes

Open-AudIT - Bugfix - Disk size calculation incorrect when processing SAN details.
Open-AudIT - Bugfix - Using # or $ in a password fails logon to OAC from OAE.
Open-AudIT - Bugfix - When creating a group and assigning a user, application breaks.
Open-AudIT - Improvement - Add a /30 blessed subnet when a user points discovery at a single device.
Open-AudIT - improvement - audit_windows.vbs Win32_Printer.CapabilityDescriptions on Windows 2003 now works.
Open-AudIT - Improvement - PHP7 now works. This means Ubuntu 16.04 should be functional with Open-AudIT.
Open-AudIT - New feature - Store Nmap detected open ports.
Open-AudIT Enterprise - Bugfix - Specific Software installed on a specific date not working.
Open-AudIT Enterprise - Feature - Search All Attributes from Dashboard.
Open-AudIT Enterprise - New Feature - Export a Baseline Result ordered by Device or Policy.