→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
jimbob
Engaged Sweeper II
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
1 ACCEPTED SOLUTION
rgross
Engaged Sweeper III
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

View solution in original post

2 REPLIES 2
jimbob
Engaged Sweeper II
great stuff.. thanks for the quick reply
rgross
Engaged Sweeper III
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

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now