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

No comments:

Post a Comment