Tuesday, May 13, 2014

List all printers (local and networked) SQL Report

SQL Report :


  1. 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
Posted by at

1 comment:

  1. RaffaAugust 8, 2018 at 4:56 AM

    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

Subscribe to: Post Comments (Atom)