Printers in all locations with some "data"

[RLG]

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.

[rsellers]

When I get this report, I get a response of:
This report has no results!

Suggestions?

[Daniel_B · Accepted solution]

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