cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Chicken
Engaged Sweeper
has anyone tried searching for color printers and then finding out who has them installed on their workstation?
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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%'

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
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%'