Report showing AuditStatus for all scans - not just last scan

I am after a report to show the Audit Status for all success/failure scans as recorded in the history tab of each workstation. The report can be split across different sites and restricted to a specific date range (ie 1 month) as it would likely produce a great deal of data.

I am wanting to use the success/failed scan logs to report on workstations that are potentially being under utilized and perhaps are being turned on only a couple of times in the month. All reports I have found only report on the last success or last failed scan, whereas I need to show multiple scan status' per workstation.

Any assistance would be greatly appreciate!

Using MSSQL