→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
RLG
Engaged Sweeper
Hello all,

I Need a Report for the following to Show:

Printer Asset Name, Printer Manufacturer, Printer Serialnumber, Printer Model, Printer IPLocation

Can somebody help please.

Thank you

Alex.
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
Please find an example report below which lists this data. Instructions for running reports can be found here. If you are interested in building or modifying reports, we would recommend:
  • Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  • Updating to Lansweeper 5.3, if you haven't already. Lansweeper 5.3 includes a database dictionary, which is linked at the top of the report builder. The dictionary explains in great detail what each table and field stores.


Select Top 1000000 tblAssets.AssetName,
tblAssetCustom.Manufacturer,
tblAssetCustom.Serialnumber,
tblAssetCustom.Model As [Device model],
tsysIPLocations.IPLocation,
tblAssets.Lastseen,
tblAssets.AssetID
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Where tblAssetCustom.State = 1 And tsysAssetTypes.AssetTypename = 'printer'
Order By tblAssets.AssetName

View solution in original post

2 REPLIES 2
rsellers
Engaged Sweeper II
When I get this report, I get a response of:
This report has no results!

Suggestions?
Daniel_B
Lansweeper Alumni
Please find an example report below which lists this data. Instructions for running reports can be found here. If you are interested in building or modifying reports, we would recommend:
  • Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  • Updating to Lansweeper 5.3, if you haven't already. Lansweeper 5.3 includes a database dictionary, which is linked at the top of the report builder. The dictionary explains in great detail what each table and field stores.


Select Top 1000000 tblAssets.AssetName,
tblAssetCustom.Manufacturer,
tblAssetCustom.Serialnumber,
tblAssetCustom.Model As [Device model],
tsysIPLocations.IPLocation,
tblAssets.Lastseen,
tblAssets.AssetID
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Where tblAssetCustom.State = 1 And tsysAssetTypes.AssetTypename = 'printer'
Order By tblAssets.AssetName