cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Mbrown2
Engaged Sweeper
looking for a report of windows Xp Machines with Detail like Make and Model
I really need to see if these can be upgraded or do I need to replace them for Budgeting.

I do not see this in any of the candid Reports

thank you
Maryellen
1 ACCEPTED SOLUTION
MikeMc
Champion Sweeper II
See if this works for you:
Select Top 100000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysOS.OSname,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Memory,
tblAssetCustom.Serialnumber
From tblAssets
Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tsysOS.OSname = 'Win XP' And tblAssetCustom.State = 1
Order By tblAssets.AssetName

View solution in original post

1 REPLY 1
MikeMc
Champion Sweeper II
See if this works for you:
Select Top 100000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysOS.OSname,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Memory,
tblAssetCustom.Serialnumber
From tblAssets
Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tsysOS.OSname = 'Win XP' And tblAssetCustom.State = 1
Order By tblAssets.AssetName

New to Lansweeper?

Try Lansweeper For Free

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

Try Now