:::: MENU ::::

Hardware/Software Scan with last boot up time on specific machines – SQL Query

SELECT

v_R_System.Name0AS[Server Name],

v_GS_OPERATING_SYSTEM.Caption0AS[Operating System],

v_GS_OPERATING_SYSTEM.LastBootUpTime0AS[Last Machine Boot Up Time],

v_GS_WORKSTATION_STATUS.LastHWScanAS[Last HW Scan Date],

V_GS_LASTSOFTWARESCAN.LASTSCANDATEAS[LAST SOFTWARE SCAN DATE]

FROMv_R_SystemINNERJOINv_GS_OPERATING_SYSTEM

ONv_GS_OPERATING_SYSTEM.ResourceID=v_R_System.ResourceIDINNERJOIN

v_GS_LastSoftwareScanONv_R_System.ResourceID=v_GS_LastSoftwareScan.ResourceIDINNERJOIN

v_GS_WORKSTATION_STATUSONv_R_System.ResourceID=v_GS_WORKSTATION_STATUS.ResourceID

ANDv_R_System.Name0IN(‘Machine01’,‘Machine02’)


10 Comments

So, what do you think ?