Windows XP Report Need help

[kcrum]

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?

[rgross · Accepted solution]

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