Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
query for local printers
- Thread starter tbrand
- Start date
This should give you what you want:
select SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_G_System_PRINTER_DEVICE.Description, SMS_G_System_PRINTER_DEVICE.DriverName, SMS_G_System_PRINTER_DEVICE.Location, SMS_G_System_PRINTER_DEVICE.ShareName from SMS_R_System inner join SMS_G_System_PRINTER_DEVICE on SMS_G_System_PRINTER_DEVICE.ResourceID = SMS_R_System.ResourceId
SMS does not collect network printer information due to a WMI problem (the CIM Win32_Printer has the information, but the implementation of SMS_Printer for hardware collection doesn't work properly -- something like that; I don't know all the details).
select SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_G_System_PRINTER_DEVICE.Description, SMS_G_System_PRINTER_DEVICE.DriverName, SMS_G_System_PRINTER_DEVICE.Location, SMS_G_System_PRINTER_DEVICE.ShareName from SMS_R_System inner join SMS_G_System_PRINTER_DEVICE on SMS_G_System_PRINTER_DEVICE.ResourceID = SMS_R_System.ResourceId
SMS does not collect network printer information due to a WMI problem (the CIM Win32_Printer has the information, but the implementation of SMS_Printer for hardware collection doesn't work properly -- something like that; I don't know all the details).
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question