User frendly 'Model' names

[hovgaard]

In the 'computer report' is there a column for the 'Model'. I use mostly Lenovo PC's and the Model contains a 7 character model name. I would like to translate or have another column With the user frendly name for this model. I do have list with all Model-numers wha are used and the corresponding 'frendly' name.

Regards Per

[RBosch01]

Thanks! That's really useful to know and seems to work reasonably well with "IBM" devices as well. Wish I'd known this a few months ago 😕

[Hemoco · Accepted solution]

In our experience, Lenovo stores the "correct" model name in the Version field of the Win32_ComputerSystemProduct WMI class, which is not where we would expect it to be.

Win32_ComputerSystemProduct data is stored in the tblComputerSystemProduct table of the Lansweeper database. The sample report below should list the "correct" Lenovo model names.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblComputerSystemProduct.Version As CorrectModel
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblComputerSystemProduct On tblAssets.AssetID =
tblComputerSystemProduct.AssetID
Where tblAssetCustom.State = 1 And tblAssetCustom.Manufacturer Like '%lenovo%'

[chads]

@RBosch01

You mind sharing this SQL script that you run to fill in this information? we are heavy Lenovo here and i hate the way they list their models.

[RBosch01]

We ended up using one of the custom fields on tblAssetCustom to hold a friendly name.
I created a SQL script (update query) which simply populates the custom field with a friendly name based on the model number.
Initially I was running this SQL script manually via the Configuration -> Database Scripts screen in Lansweeper, but now I use the Windows scheduler to call it 3 times times a day and run it directly via the SQL Server management console.
If new models come along, I just update my SQL script accordingly.

[Hemoco]

When you edit the asset maybe you can change the Lenovo model and lock it to avoid to be overwritten again? Most other manufacturers use quite good model names.