SMS SQL to show Last HW Scan by Day & Hour

A quick and dirty query to show status of your hardware scan for the last few days, add a darepart yy for year and mm for month if you are looking back more than just the current month.

----Begin SQL----

SELECT DatePart(dd,HWSCAN.LastHWScan), DatePart(hh,HWSCAN.LastHWScan), Count(*)
From v_GS_WORKSTATION_STATUS HWSCAN
Where LastHWScan > '2007-06-01'
Group By DatePart(dd,HWSCAN.LastHWScan), DatePart(hh,HWSCAN.LastHWScan)
Order by DatePart(dd,HWSCAN.LastHWScan), DatePart(hh,HWSCAN.LastHWScan)

----End SQL----