Report For Printers

[asldesktop]

Hello

Is it possible to have a custom report to show all locally connected printers and the port they are connected to (LPT1 or USB001,USB002 etc)?

I am not familiar with report writing or SQL so any help is appreciated.

[Hemoco]

Try this

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Userdomain, tblComputers.Username,
tblPrinters.Caption, tblPrinters.Portname
From tblComputers Inner Join
tblPrinters On tblComputers.Computername = tblPrinters.Computername