CUSTOM INVENTORY REPORT

[jaycii]

Im very new to lansweeper and seem to be having trouble creating a custom report. What Im trying to do is scan our network by site to view inventory. I seem to be having trouble creating a report that includes the following:

-IP LOCATION
-COMPUTER NAME
-ASSET NAME
-MANUFACTURER
-MODEL NUMBER
-THE PC SERIAL NUMBER
-TYPE (WINDOWS/MAC)
-LAST USER
-LAST SEEN
-IP ADDRESS

IF I COULD GET THE CODES NEEDED IN ORDER TO CREATE THIS REPORT WOULD BE GREAT.

THANK YOU IN ADVANCE.

[Susan_A · Accepted solution]

We received and answered this question via email as well. Just for everyone else's benefit, I'm pasting the reply we sent via email below.

Please use the report below for the information you are after. Instructions for adding this report to your Lansweeper installation can be found here. If you are interested in building or modifying reports, we do generally 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.
  
• Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename,
  tblAssets.FQDN,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Serialnumber,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
    And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Where tblAssetCustom.State = 1
Order By tblAssets.IPNumeric,
  tblAssets.AssetName