Service Tag Number

[frika]

We have Dell computers and I need the Service Tag (Serial Number) of the PC's. This is the report I created:

Select Top 1000000 tblAssets.AssetID,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.AssetUnique,
tblAssetCustom.Serialnumber,
tblAssetCustom.SerialnumberLock
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1

When I run the report the serial number field is empty. What am I doing wrong ?

[76012]

Your report works for me, and shows the Dell service tag.

Maybe check your config to make sure you are scanning the Serial Number. I just looked under Scan Time for a particular computer...

Scan item Wait time (days) Last scanned Scan time (seconds)
Serialnumber 40 05/31/2013 11:41:59 0.02

[Hemoco]

76012 wrote:
Scan item Wait time (days) Last scanned Scan time (seconds)
Serialnumber 40 05/31/2013 11:41:59 0.02

This actually refers to software serials, not computer serials. COMPSYSPROD is the wait time that affects computer serials.

[Hemoco]

Could you ensure that your computers have been successfully scanned. TblAssets.Lastseen should be recent.