SMS SQL for Oldest and Newest Inventory Dates

Three simple little queries to show you both the oldest and newest date for your clients hardware and software inventory.

----Begin SQL----

SELECT Min(LastHWScan),
Max(LastHWScan)
From v_GS_WORKSTATION_STATUS

Select Min(LastScanDate),
Max(LastScanDate)
From v_GS_LastSoftwareScan

Select Min(LastCollectedFileScanDate),
Max(LastCollectedFileScanDate)
From v_GS_LastSoftwareScan

----End SQL----