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
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
Hello all,
ReplyDeleteTry 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
How do I get the port IP address on his report? Not the port name, but the actual IP address
ReplyDeleteHow do I add this port IP address info to this?
ReplyDeleteSELECT
v_GS_TCPIP_PRINTER_PORT.HostAddress0
FROM
v_GS_TCPIP_PRINTER_PORT