cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
CVCO
Engaged Sweeper III
In our Lansweeper v. 6.0.151.34 deployment the built in "Windows: Installed network printers" report only has 1 single entry from a desktop last seen in 2016 for some reason when it should have closer to a couple thousand active entries based on the number of users and mapped network printers we have. The built in "Windows: Installed local printers" report has around 2500 entries populated. Suggestions are appreciated. This is the current code from our network printers report:



Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblPrinters.Caption As Printer,
tblPrinters.Portname As PrinterPort,
tblPrinters.Printprocessor,
tblPrinters.Capabilitydescriptions As PrinterCapabilities,
tblPrinters.Lastchanged
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblstate On tblstate.State = tblAssetCustom.State
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblPrinters On tblAssets.AssetID = tblPrinters.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblPrinters.Printprocessor <> 'WinPrint' And Case tblPrinters.Network
When 0 Then 'No' When 1 Then 'Yes'
End = 'Yes' And tblstate.Statename = 'Active'
Order By tblAssets.Domain,
tblAssets.AssetName,
Printer
10 REPLIES 10
CVCO
Engaged Sweeper III
CyberCitizen wrote:
I also have the same, but what I do is go to Assets > Asset Type > Printers and find the ones I need there.

Or Under the reports, device Printer status. For some reason that report you mention returns no results for me, not sure if the report needs to be rebuilt.



Thanks for the feedback but what I'm looking for is a report of mapped printers per user per machine rather than just a listing of printers on the network. The built in report should provide what's needed if/when it works.