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.
Quote:Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblPrinters.Caption
From tblComputers Inner Join
tblPrinters On tblComputers.Computername = tblPrinters.Computername
Where tblPrinters.Capabilitydescriptions Like '%color%'
