For those that can run Bazaar (version control), the current branch on Launchpad is pretty close to being called Beta5. Give it a whirl - but don't forget to backup your database and web files. There is quite a lot of changes to the DB.
https://launchpad.net/oav2/trunkTo grab a copy run
bzr branch lp:oav2
A list of changes is below.
GROUP - Database Servers now displays the version of MSSQL on the list page.
REPORT - Alerts-NewSystem, Alerts-Software, Alerts-USBDisks, Alerts, AuditDates, DellSystems, FailedAudits, MSOffice, MSProject, SystemDetails, WorkstationDetails all updated.
REPORT - BillingReport created.
DATABASE - Changed the foreign keys on all tables to enable deleting from the System table to cascade to all affected tables.
DATABASE - Added monitor size and aspect ratio.
DATABASE - Added class, last seen, last seen by, last user to the system table.
Admin - Added the code (but not the menu options) to retrieve and the code to delete "non production" systems from the DB.
BUG - fixed the ability to add and delete locations from the web interface.
BUG - fixed the ability for non-admin users to edit their details without dropping their group access.
FEATURE - Added logging to the PHP error log when a non-valid XML file is submitted, write "Invalid XML for: " . SYSTEMNAME into the log.
FEATURE - update the man_ip_address in system table when DHCP set to TRUE.
FEATURE - only update the ROUTE table if DHCP set to FALSE.
FEATURE - replaced a lot of TODO comments in the PHPExcel library to enable better tracking in Aptana.
FEATURE - Only alert on a partition change if it is NOT a USB device.
FEATURE - when auto-creating network groups, the group select sql only selects production systems now.
BUG - In the model for log, it was incorrectly stating route - fixed.
FEATURE - in the model for monitor, it now updates existing monitors with size and aspect ratio when using the new audit script.
FEATURE - in the model for location I've added PHPDOC style comments for all functions. Intent is to complete this for all files. aptana picks this up and displays when editing PHP - nice.
FEATURE - the icon for a Windows system now uses the string for OSGroup with spaces replaced by underscores, instead of windows_new, etc.
BUG - The list reports page did not work if ONE report was present. Fixed.
FEATURE - Some brands of disk drive will now display the manufacturer logo for a picture, rather than the generic disk icon.
FEATURE - Hard drive manufacturer displayed on the system view page.
FEATURE - Audit Domain script now takes an array of domains (personally, I have four domains to audit).
FEATURE - Added extra dell monitor pictures.
FEATURE - removed obsolete code duplication for some javascript libraries.
FEATURE - Added index.html to most (if not all) directories in the web accessable directories to prevent directory/file listing.
Audit Script Changes
FEATURE - Error checking when attempting to connect to a remtoe system added.
FEATURE - Improved handling of retrieving user details from AD.
FEATURE - Retrieve user "company" field from AD.
BUG - escape the AD OU (some of ours had an & in them).
FEATURE - Retrieve memory stick serial number (even though it's not used by most).
FEATURE - Retrieve hard drive serial (even though a lot of the time it's not populated).
FEATURE - much improved monitor handling. Retrieve monitor size and calculate aspect raito.
FEATURE - Added some more manufacturer detection strings for hard drives
FEATURE - Stopped multiple instance of Outlook Express and Internet Explorer for appearing in the audit result.
FEAUTRE - Added error checking when looking for 64bit software installed by and installed on.
FEATURE - Added debugging and better error handling and better connection attempts for SQL databases.
FEATURE - Improved IIS support and detail retrieval.
FEATURE - Derive a site URL from IIS properties.