Release Notes for Open-AudIT v3.1.0

Released 2019-06-13

Linux SHA256:  39fc4482b688f8d5e7bf77910be96728318a75377530d5d77bcb730a3e60dc9d

Linux md5sum:  b21c87ae1373db2435a4e1a659553c57


Open-AudIT ProfessionalImprovementAdd last run onto tasks::collection template, along with current date and time. Add last run onto tasks::read template.
Open-AudIT ProfessionalImprovementDisplay local time on tasks create template.
Open-AudIT ProfessionalImprovementRevised welcome page.
Open-AudIT ProfessionalNew FeatureProvide sample devices for import. Menu → Manage → Devices → Import Example Devices (and Delete Imported Example Devices).
Open-AudIT ProfessionalBugWhen generating HTML (usually for an email) if there is no data populated, do not break. Same when generating the JSON.
Open-AudIT ProfessionalImprovementRevised template for software on a device.
Open-AudIT ProfessionalBugFix 'assign devices to org' in discovery GUI.
Open-AudIT ProfessionalBugFix Exporting to HTML table.
Open-AudIT ProfessionalImprovementAdd SNMP Version to devices::read template.
Open-AudIT ProfessionalBugFix HTML issue on attributes::create template.
Open-AudIT ProfessionalBugFix editing "Assign to Location" button on discoveries::read template.
Open-AudIT ProfessionalImprovementSort policy.options by name on devices::read template.
Open-AudIT ProfessionalImprovementShow time taken (in seconds) to discover each device on discoveries::read template, in devices list section.
Open-AudIT ProfessionalNew FeatureIntegrations. It is now quick and simple to integration Open-AudIT and NMIS. How simple - try 3 mouse clicks! See Integrations and OpenAudIT-NMIS Integration.
Open-AudITBug

Fixed a bug in the linux audit script (not correctly escaping policy.options JSON).

As a result, have changed the audit Linux and audit Windows script to use XML children, instead of attempting to write JSON into the XML.

The associated processing of the audit result in audit_helper.php has been updated to account for this.

Open-AudITNew Feature

Added configuration items for create_change_log_<table>. If set to 'y', change logs will be created for items in that table.

Override ALL items by setting create_change_log to 'n'.

Open-AudITNew Feature

Added configuration items for delete_noncurrent_<table>. If set to 'y', when processing audit data, items that are not current will be deleted from that table.

Override ALL items by setting delete_noncurrent to 'n'.

Open-AudITNew Feature

Added configuration items for create_change_log_netstat_<well_known || registered || dynamic>.

Only 'well known' is set to 'y'. These correspond to ports 0-1024, 1024-49151 and 49152-65535.

https://en.wikipedia.org/wiki/List_of_TCP_and_UDP_port_numbers

https://social.technet.microsoft.com/Forums/ie/en-US/4f8ee026-28c9-402c-87ea-09809700027d/dns-udp-ports?forum=winserveripamdhcpdns

Open-AudITImprovementChange the config option download_reports to be a bool (y,n).
Open-AudITImprovement

Enable Open-AudIT on Windows to run discovery as per Linux.

IE - Copy audit script to target Windows device, run script on target device, copy result file back to server and process.

Config item 'discovery_use_vintage_service' provided to enable the old way of working if required (not default).

Open-AudITBugComment out for now the netstat portion of the AIX audit script. Has not worked with updated code for quite a while. To be fixed.
Open-AudITImprovementAdded SNMP data for Nortel, Siklu, Cisco Nexus, Digi, 
Open-AudITImprovementIgnore invalid (or self-signed) certs when submitting logs in discover_subnet.sh.
Open-AudITImprovementRemove default SNMP community string of 'public' from DB schema.
Open-AudITImprovementProvide raw SQL as comments to top of schema upgrade file.
Open-AudITImprovementAdd an index to audit_log table.
Open-AudITImprovementRemove attributes on export if empty.
Open-AudITBugFix error in URL parsing for log submission.
Open-AudITBugFix custom scans where discovery_scan_option_id = 0.
Open-AudITBugAllow for a - in a custom port range when updating a discovery.
Open-AudITNew FeatureAdd cloud_id to response->meta if using Open-AudIT Cloud.
Open-AudITImprovementAdd extra info into timings (current unix time).
Open-AudITNew FeatureSNMP Version added to system table in system.snmp_version.
Open-AudITImprovementRevised 'hostname' command use to determine hostname, domain and fqdn.
Open-AudITImprovementImproved Audit Solaris with XML escaping if required.
Open-AudITImprovementRevised hostname to use raw 'hostname' command as various Unixes use different options. Add Solaris os_name into ssh helper.
Open-AudITBugFix link for Cloud Devices Audited per Day widget.
Open-AudITImprovementAdded tomcat, nginx and mongodb to the audit linux script for server details, Thanks alexander.szele@umanitoba.ca
Open-AudITImprovementAdded Office 365 to the MS Office query.
Open-AudITImprovementDo not populate 'hostname' using SNMP 'sysName'.
Open-AudITImprovementImplement 2x new matching rules - match_sysname and match_sysname_serial.
Open-AudITBugFIx bug not parsing "filtered" option in discover_subnet.vbs