Report that includes computer model number

[david_chang]

When I view hardware assets, desktops or laptops, I can view their specific model numbers.

There is a battery recall on specific Lenovo model numbers.
I need to run a report against all of the machines in my environment and I Need to see, user name, location, computer name, and computer model number (at minimum). The current "hardware" tab links do not sure model numbers. I have to hover over specific machines to get the actual model number.

Please provide the specific SQL language/suggestions.

I'm not a SQL person so any reports are pretty much cut and paste for me.

thanks in advance!

D

[Daniel_B · Accepted solution]

Most of this data is stored in tblAssetCustom. When creating a new report, just scroll through this table and select the columns which you would like to display. The following report should list all your Lenovo assets:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Username,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Model,
  tblAssetCustom.Serialnumber,
  tblAssets.Lastseen
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join tsysIPLocations
    On tblAssets.IPNumeric Between tsysIPLocations.StartIP And
    tsysIPLocations.EndIP
Where tblAssetCustom.State = 1 And tblAssetCustom.Manufacturer Like 'Lenovo%'
Order By tblAssets.AssetName