→ 🚀Are you a Lansweeper Champion?! Join our Contributor Program Sign up here!

Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kcrum
Engaged Sweeper
Trying to create a report to get all windows xp machines, their asset name, ip address, ip location... Wondering if anyone can help me with this?
1 ACCEPTED SOLUTION
rgross
Engaged Sweeper III
Here is a report I use, you can customize it to fit your needs




Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssetCustom.Model,
tblADusers.Displayname,
tblADComputers.OU,
tblOperatingsystem.Caption,
tblAssetCustom.Warrantydate
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

1 REPLY 1
rgross
Engaged Sweeper III
Here is a report I use, you can customize it to fit your needs




Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssetCustom.Model,
tblADusers.Displayname,
tblADComputers.OU,
tblOperatingsystem.Caption,
tblAssetCustom.Warrantydate
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