ConfigMgr Reporting – List all printers (local and networked)

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 lists all printers (local and networked).

Please note: The report results includes the standard ‘Microsoft Office Document Image Writer Driver’ etc “software printers” – we suggest you export the report to excel and filter these out.

The report will also be linked to ‘Computer information for a specific computer’ report, allowing you to see detailed information on the systems listed.

How to create a report using SCCM R2:

  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. SCCM-ReportSP1
  6. Under ‘Name’ enter in the desired name, e.g. List All Printers (Local and Networked)
  7. Select a category, e.g. Device Management
  8. SCCM-ReportSP2
  9. Click on the ‘Edit SQL Statement’ button
  10. Under ‘SQL statement’ enter the following code:
  11. SELECT SYS.Netbios_Name0,printer.DriverName0, printer.Location0,printer.PortName0,printer.PrintProcessor0 
    FROM v_GS_PRINTER_DEVICE printer

    JOIN v_R_System SYS ON SYS.ResourceID = printer.ResourceID

    ORDER BY SYS.Netbios_Name0
  12. SCCM-ReportSP3
  13. Click ‘OK’ to return to the ‘New Report Wizard’
  14. Click ‘Next’ then ‘Next’ again
  15. Under ‘Link type’ select ‘Link to another report’
  16. SCCM-ReportSP6
  17. Under ‘Report’ click on the ‘Select’ button
  18. From the reports list, select ‘Computer information for a specific computer’
  19. SCCM-ReportSP7
  20. Click ‘OK’ to close the window
  21. 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. SCCM-ReportSP8
  4. Click ‘Display’ to display the report
  5. The report will list all the printers from the database
  6. To get detailed information on each system click on the arrow to the left of the system name.