Advanced Exercise 2 Solution: Create a New Report for Hardware Inventory

Applies To: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2

The following information can be used to create the report for Advanced Exercise 2: Create a New Report for Hardware Inventory.

Report SQL Statement

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

Report Prompt

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

Report Link

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

See Also

Community Additions

ADD
Show: