Printers and Users

[Chicken]

has anyone tried searching for color printers and then finding out who has them installed on their workstation?

[Hemoco · Accepted solution]

Lansweeper will return info on printers mapped to the computer account (computer wide) and not to specific users on that computer.

Below is an example report for finding color printers.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblPrinters.Caption
From tblComputers Inner Join
tblPrinters On tblComputers.Computername = tblPrinters.Computername
Where tblPrinters.Capabilitydescriptions Like '%color%'