Lenovo Model and Description

[ntrimarc]

We have recently begun Lenovo laptops in our environment and have run across a problem. In Lansweeper these devices show a model of 2429n53 which means nothing. An accurate description is ThinkPadT530.

Is there a way to get this description into the asset record? If it were an SNMP device, I could use OID to map the device description correctly (as I've had to do with some printers). But there doesn't seem to be a corresponding mechanism for Windows devices.

I really need this capability to be able to produce meaningful reports.

Thanks!

[Hemoco]

You can add an expression like the one below to your reports to list tblComputerSystemProduct.Version for Lenovo machines and tblAssetCustom.Model for other assets.

Case
When tblAssetCustom.Manufacturer Like '%lenovo%' Then
tblComputerSystemProduct.Version Else tblAssetCustom.Model End

[ntrimarc]

Yes, that appears to work... I attached a screen shot sample to the original post... Do I need to do anything to get this information into the asset records or should I just add this select into my reports where the model type / manufacturer is Lenovo?

[Hemoco]

Could you verify whether the report below lists the correct model information. It is known that some Lenovo machines store this data in an incorrect WMI (Windows Management Instrumentation) field.

SELECT tsysOS.Image AS icon, tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tblAssets.IPAddress, tblAssets.Firstseen, tblAssets.Lastseen,
tblComputerSystemProduct.Version AS Model
FROM tblAssets INNER JOIN
tsysOS ON tblAssets.OScode = tsysOS.OScode INNER JOIN
tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID INNER JOIN
tblComputerSystemProduct ON tblAssets.AssetID = tblComputerSystemProduct.AssetID
WHERE (tblAssetCustom.State = 1)
ORDER BY tblAssets.Domain, tblAssets.AssetName