Server report showing serial number by vendor

[tundra96]

Can someone tell me how to write a report that will give me a list of all the serial numbers of my HP servers ?

Thanks

[Daniel_B · Accepted solution]

You could try a report like the example below. 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 uses standard SQL queries. This seems like a good tutorial.
- Updating to Lansweeper 5.2, if you haven't already. Lansweeper 5.2 includes a database dictionary, which is linked at the top of the report builder.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.Lastseen,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Serialnumber
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where (tblAssetCustom.Manufacturer Like 'hp %' Or
    tblAssetCustom.Manufacturer Like 'Hewlett%') And tblAssetCustom.State = 1
  And tblComputersystem.Domainrole > 1
Order By tblAssets.AssetName