Looking for a report Of XP Machines with serial number Make and Model

[Mbrown2]

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

[MikeMc · Accepted solution]

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