Query for Global Hardware and Software Scan report :-

Query for Global Hardware  and Software Scan report :-

SELECT Distinct

v_R_System.Name0 AS [netbios_name0],
v_r_system.User_Name0,

v_GS_OPERATING_SYSTEM.Caption0 AS [Operating System],

v_GS_OPERATING_SYSTEM.LastBootUpTime0 AS [Last Machine Boot Up Time],

v_GS_WORKSTATION_STATUS.LastHWScan AS [Last HW Scan Date],

V_GS_LASTSOFTWARESCAN.LASTSCANDATE AS [LAST SOFTWARE SCAN DATE]  ,

v_R_System.Last_Logon_Timestamp0

FROM v_R_System

INNER JOIN v_GS_OPERATING_SYSTEM ON v_GS_OPERATING_SYSTEM.ResourceID = v_R_System.ResourceID
INNER JOIN v_GS_LastSoftwareScan ON v_R_System.ResourceID=v_GS_LastSoftwareScan.ResourceID
INNER JOIN v_GS_WORKSTATION_STATUS ON v_R_System.ResourceID=v_GS_WORKSTATION_STATUS.ResourceID






H\W and S|W scan report for the particular file  :


SELECT Distinct

v_R_System.Name0 AS [netbios_name0],
v_r_system.User_Name0,

v_GS_OPERATING_SYSTEM.Caption0 AS [Operating System],

v_GS_OPERATING_SYSTEM.LastBootUpTime0 AS [Last Machine Boot Up Time],

v_GS_WORKSTATION_STATUS.LastHWScan AS [Last HW Scan Date],

V_GS_LASTSOFTWARESCAN.LASTSCANDATE AS [LAST SOFTWARE SCAN DATE]  ,

v_GS_SoftwareFile.FileName AS [Display Name] ,
v_R_System.Last_Logon_Timestamp0

FROM v_R_System

INNER JOIN v_GS_OPERATING_SYSTEM ON v_GS_OPERATING_SYSTEM.ResourceID = v_R_System.ResourceID
INNER JOIN v_GS_LastSoftwareScan ON v_R_System.ResourceID=v_GS_LastSoftwareScan.ResourceID
INNER JOIN v_GS_WORKSTATION_STATUS ON v_R_System.ResourceID=v_GS_WORKSTATION_STATUS.ResourceID
INNER JOIN v_GS_SoftwareFile ON (v_GS_SoftwareFile.ResourceID = v_R_System.ResourceId)


Where v_GS_SoftwareFile.FileName = 'WINPROJ.EXE'