cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
rob_miller
Engaged Sweeper
I am trying to run a report to show all printers installed to workstations but it is coming up empty. This is the report as I found it. Basically I just copied this code as found here to a new report. What am I doing wrong?


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

2 REPLIES 2
JacobH
Champion Sweeper III
To troubleshoot, generally you whittle down the WHERE clause to see if you have any base results.

I did that, and noticed it was the tblprinter.network check - i did a select from that table, and noticed all of my entries in there say 0. So, I assume it's not what I think it is, nor reliable for anything, so I removed it from the WHERE clause

Where tblPrinters.Printprocessor <> 'WinPrint' 
And tblState.Statename = 'Active'


change it to that, and you should get results.
JacobH wrote:
To troubleshoot, generally you whittle down the WHERE clause to see if you have any base results.

I did that, and noticed it was the tblprinter.network check - i did a select from that table, and noticed all of my entries in there say 0. So, I assume it's not what I think it is, nor reliable for anything, so I removed it from the WHERE clause

Where tblPrinters.Printprocessor <> 'WinPrint' 
And tblState.Statename = 'Active'


change it to that, and you should get results.


Thank you! That did it!

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now