Community FAQ
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

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now