Thursday, March 12, 2015

SCCM Report for local printers

Below SCCM report provides all the attached local printer information from a machine.

Collecting local printer inventory involves 2 tasks.

1. Enable Printer Device (Win32_Printer) class in Hardware Inventory classes from \Administration\Overview\Client Settings

2. Run below report to collect the inventoried printer information in a report format.
Wait for 7 days (Default hardware inventory policy interval) after enabling the hardware class and before running the report . Otherwise you may get the bank report.

Below report provides all the attached printer information excluding;
- Microsoft XPS Document Writer
- Adobe PDF Converter
- Microsoft Shared Fax Driver
- TP Output Gateway
- pdfFactory

********************************************************************************************************
SELECT  SYS.Netbios_Name0 AS [Computer Name], printer.DriverName0 AS [Printer Name], printer.PortName0 AS [Port Type],
    printer.Location0 AS [Device Location]
FROM    v_GS_PRINTER_DEVICE AS printer INNER JOIN
        v_R_System AS SYS ON SYS.ResourceID = printer.ResourceID
WHERE   (NOT (printer.DriverName0 LIKE 'Microsoft XPS Document Writer')) AND
    (NOT (printer.DriverName0 LIKE 'Adobe PDF Converter')) AND
        (NOT (printer.DriverName0 LIKE 'Microsoft Shared Fax Driver')) AND
    (NOT (printer.DriverName0 LIKE '%TP Output Gateway%')) AND
        (NOT (printer.DriverName0 LIKE '%pdfFactory%'))
ORDER BY [Computer Name]

***********************************************************************************************************
More SCCM custom reports can be found here

3 comments:

  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

    ReplyDelete
  2. How do I get the port IP address on his report? Not the port name, but the actual IP address

    ReplyDelete
  3. How do I add this port IP address info to this?

    SELECT
    v_GS_TCPIP_PRINTER_PORT.HostAddress0
    FROM
    v_GS_TCPIP_PRINTER_PORT

    ReplyDelete