The following SQL statement can be used to retrieve the information required by this exercise:

SELECT v_R_System.Netbios_Name0 AS [Computer Name],

  v_RA_System_SMSInstalledSites.SMS_Installed_Sites0 AS [Site Code],

  v_GS_WORKSTATION_STATUS.LastHWScan AS [Last HWScan],

  DATEDIFF(day, v_GS_WORKSTATION_STATUS.LastHWScan, GETDATE()) AS [Days Since Last HWScan]

FROM v_GS_WORKSTATION_STATUS INNER JOIN v_R_System ON

  v_GS_WORKSTATION_STATUS.ResourceID = v_R_System.ResourceID

  INNER JOIN v_RA_System_SMSInstalledSites ON

  v_R_System.ResourceID = v_RA_System_SMSInstalledSites.ResourceID

ORDER BY [Last HWScan] DESC

No report prompt or report prompt SQL statement is required for this report.

The following report link settings can be used when creating the report in this exercise:

Link Type: Link to Computer Details

Computer Name Column: 1

Concepts

Other Resources