cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
david_chang
Engaged Sweeper II
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
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
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