Asset scanning status report
I have the following Query report that provides me with the last scan date and scan status of each item in ServiceDesk. What would I need to add, in order to include the Resource State of that PC? This would be very useful for auditing. We use MSSQL. Thanks.
select systeminfo.workstationname "Workstation Name", "Model",dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (audithistory.audittime/1000),'1970-01-01 00:00:00')"Last Scanned on",
audithistory.auditstatus "Scan status" from audithistory left join systeminfo on systeminfo.workstationid=audithistory.workstationid where audithistory.auditid in
(Select max(audithistory.auditid) from audithistory group by workstationid) order by 2
select systeminfo.workstationname "Workstation Name", "Model",dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (audithistory.audittime/1000),'1970-01-01 00:00:00')"Last Scanned on",
audithistory.auditstatus "Scan status" from audithistory left join systeminfo on systeminfo.workstationid=audithistory.workstationid where audithistory.auditid in
(Select max(audithistory.auditid) from audithistory group by workstationid) order by 2