You could try setting up a report with a join such as this (this SQL taken from a report in OAv2) - [code]select system.system_id, system.hostname, sys_sw_software.software_name, sys_sw_software.software_version from system left join sys_sw_software on (system.system_id = sys_sw_software.system_id and system.timestamp = sys_sw_software.timestamp and (software_name like '%virus%' or software_name like '%endpoint%')) join oa_group_sys on (system.system_id = oa_group_sys.system_id and oa_group_sys.group_id = ?) group by hostname order by hostname;[/code] Note the left join...
As for DropBox... It should list most programs in the Registry at - My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall If it appears in there, it should show up in Open-AudIT.
_________________ Support and Development hours available from [url=https://opmantek.com]Opmantek[/url]. Please consider a purchase to help make Open-AudIT better for everyone.
|