Show mapped network printers for each user per machine

[IcemanAsakura]

The ability to show locally installed printers is awesome. But since finding myself well into moving from local printer installs to printer shares off of a print server, I no longer can see what printers the user has mapped, and I also of course cannot see what printer is set as default. It would be very nice to have this capability.


-Thanks

[sticky]

Old thread I know, but in case anyone else is looking for this info in Lansweeper 5.x:

Select tblAssets.AssetName, tblAssets.AssetUnique,
tblAssets.Domain, tblAssets.Userdomain, tblAssets.Username,
tblPrinters.Caption, tblPrinters.Portname
From tblAssets Inner Join
tblPrinters On tblAssets.AssetID = tblPrinters.AssetID

[Norgenator]

MahleTech,

This works great!!

Thanks for the post.

-Erich

[MahleTech]

IcemanAsakura wrote:
The ability to show locally installed printers is awesome. But since finding myself well into moving from local printer installs to printer shares off of a print server, I no longer can see what printers the user has mapped, and I also of course cannot see what printer is set as default. It would be very nice to have this capability.


-Thanks

I tried this and got a report that shows what you're looking for. It would be nice to be able to view this from the main screen when you're viewing devices from a computer, but for now, this report works..


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