I needed to know when a user had installed something they shouldn't have, (too far back in the mists of time to be picked up by the show software in the last N days on the index page).
The software view only showed the names of the packages, so I added software_first_timestamp to show the first time a software item was audited, on the software for systems view (SVN ver 1083). Now you can see the first time OA picked up the installation. I would have used `software_install_date` however this is not formatted very well, or indeed always available for some reason, (use the following snippet to see what I mean).
[code] SELECT COUNT( * ) AS `Rows` , `software_install_date` FROM `software` GROUP BY `software_install_date` ORDER BY `software_install_date` LIMIT 0 , 30 [/code]
_________________ Andrew
[size=85]OA Server: Windows XP/ XAMPP, Mandriva/Apache, Ubuntu Auditing: 300+ Wstns, 20+ Srvrs, Thin clients, Linux boxes, Routers, etc OS's: Windows XP , W2K Srvr, W2K3 Srvr, W2K8, Vista, Windows 7, Linuxes (and a Mac at home) LDAP: Active Directory[/size]
|