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. Under ‘Name’ enter in the desired name, e.g. List All Printers (Local and Networked)
  6. Select a category, e.g. Device Management
  7. Click on the ‘Edit SQL Statement’ button
  8. Under ‘SQL statement’ enter the following code:
  9. 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
  10. Click ‘OK’ to return to the ‘New Report Wizard’
  11. Click ‘Next’ then ‘Next’ again
  12. Under ‘Link type’ select ‘Link to another report’
  13. Under ‘Report’ click on the ‘Select’ button
  14. From the reports list, select ‘Computer information for a specific computer’
  15. Click ‘OK’ to close the window
  16. 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. Click ‘Display’ to display the report
  4. The report will list all the printers from the database
  5. To get detailed information on each system click on the arrow to the left of the system name.

Related Articles

One comment on “ConfigMgr Reporting – List all printers (local and networked)

  1. Hello all,

    Try this in your WQL query

    select SMS_R_System.NetbiosName, SMS_G_System_PRINTER_DEVICE.Name, SMS_G_System_PRINTER_DEVICE.DeviceID, SMS_G_System_PRINTER_DEVICE.DriverName, SMS_G_System_PRINTER_DEVICE.PortName from SMS_R_System inner join SMS_G_System_PRINTER_DEVICE on SMS_G_System_PRINTER_DEVICE.ResourceID = SMS_R_System.ResourceId order by SMS_R_System.NetbiosName, SMS_G_System_PRINTER_DEVICE.Name

Leave a Reply

Your email address will not be published.