cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
tundra96
Engaged Sweeper
How would I create a report to show computers using the same network printer. I want to be able to run a report with the printers DNS name or IP address and have it show me all the workstations that are using the printer.

Thanks
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
Please try the report below for the information you are after. You can filter the printer name/IP within the report results.

Select Top 1000000 tblPrinters.Sharename,
tblPrinters.Caption,
tblPrinters.Comment,
tblPrinters.Portname,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Right Join tblPrinters On tblAssets.AssetID = tblPrinters.AssetID
Where tblPrinters.Sharename Is Not Null And tblAssetCustom.State = 1
Order By tblPrinters.Sharename,
tblAssets.AssetName

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
Please try the report below for the information you are after. You can filter the printer name/IP within the report results.

Select Top 1000000 tblPrinters.Sharename,
tblPrinters.Caption,
tblPrinters.Comment,
tblPrinters.Portname,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Right Join tblPrinters On tblAssets.AssetID = tblPrinters.AssetID
Where tblPrinters.Sharename Is Not Null And tblAssetCustom.State = 1
Order By tblPrinters.Sharename,
tblAssets.AssetName