Last Successful Scan Report
Hi,
I've found this code in the forums for a query report to tell me when the last succssful scan occurred on my discovered hardware. Can someone interpret it and tell me if it's still valid?
select si.WORKSTATIONNAME, date_format(from_unixtime(ah.AUDITTIME/1000),'%d-%m-%Y %k:%i') "Audit Time" from AuditHistory ah left join SystemInfo si on ah.WORKSTATIONID=si.WORKSTATIONID where ah.AUDITSTATUS ='SUCCESS'
I try to run the query but receive the error:-
Error While Fetching Ajax Response : Unknown Runtime Error
I'm running the most up to date version of SD+ with latest service pack.
Thanks,
Paul.
I've found this code in the forums for a query report to tell me when the last succssful scan occurred on my discovered hardware. Can someone interpret it and tell me if it's still valid?
select si.WORKSTATIONNAME, date_format(from_unixtime(ah.AUDITTIME/1000),'%d-%m-%Y %k:%i') "Audit Time" from AuditHistory ah left join SystemInfo si on ah.WORKSTATIONID=si.WORKSTATIONID where ah.AUDITSTATUS ='SUCCESS'
I try to run the query but receive the error:-
Error While Fetching Ajax Response : Unknown Runtime Error
I'm running the most up to date version of SD+ with latest service pack.
Thanks,
Paul.