desktops/laptops with serial number

[jimbob]

hi all

i'm trying to generate a report that lists all desktops/laptops together with serial number.
Is there a simple way to do this?

any help is appreciated.

thanks
sam

[jimbob]

great stuff.. thanks for the quick reply

[rgross · Accepted solution]

You can try this:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssetCustom.Model,
tblADusers.Displayname,
tblOperatingsystem.Caption,
tblAssetCustom.Warrantydate,
tblAssetCustom.Serialnumber
From tblADComputers
Inner Join tblAssets On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tblADusers On tblAssets.Username = tblADusers.Username And
tblAssets.Userdomain = tblADusers.Userdomain
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Order By tblAssets.AssetUnique