ConfigMgr Reporting – List Computers of a Specified Model Type

The following guide will demonstrate how to create a new report using Microsoft System Center Configuration Manager R3.

In this example we will be creating a report which prompts for a model type and then displays a list of all the systems that are the model type.

 

How to create a report using SCCM R3:

1. With the Configuration Manager Console open,
2. Example the ‘Computer Management’ node, then ‘Reporting’ and ‘Reports’
3. Right click on ‘Reports’ (or your custom reporting folder)
4. Select ‘New’ then ‘Report’
5. 
6. Under ‘Name’ enter in the desired name, e.g. List Computers of a Specified Model Type
   
7. Select a category, e.g. Device Management
   
8. 
9. Click on the ‘Edit SQL Statement’ button
10. Under ‘SQL statement’ enter the following code:

11. SELECT sys.Name0 as "Computer Name", sys.User_Name0, CSYS.Model0
    FROM v_R_System sys
    JOIN v_GS_COMPUTER_SYSTEM CSYS on sys.ResourceID = CSYS.ResourceID
    WHERE CSYS.Model0 like @Model

     

12. 
13. Click on the ‘Prompts’ button
14. Click on the ‘New’ button (Yellow star icon)
15. 
16. Under ‘Name’ enter Model
17. Under ‘Prompt text’ enter Select a Model
18. Place a tick next to ‘Provide a SQL statement’
19. Click on the ‘Edit SQL Statement’ button
    
20. Under ‘SQL statement’ enter the following code:

21. select Model0 from v_GS_COMPUTER_SYSTEM

22. Click ‘OK’ to save the changes
23. 
24. Click ‘OK’ several times to save the changes and return to the ‘New Report Wizard’
25. Click ‘Next’ then ‘Next’ again
26. Under ‘Link type’ select ‘Link to Computer Details’
    
27. 
28. Click ‘Next’, ‘Next’ then ‘Close’

The run the report:

1. Navigate to where the report was saved/created
2. Right click on the report and select ‘Run’
3. 
4. Click on ‘Values’ and select a model from your database or enter in a model name (you can use wild cards, e.g. “HP Compaq dc7100%”)
5. Click ‘Display’ to run the report