not latest service pack XP

[sdaniels]

Could someone one post the sql from the not the latest service pack for xp please?

more info. the default report not the latest servic epack for xp is not working. i'm looking for the original sql query so we can recreate it.

Thank you

[Hemoco · Accepted solution]

Hi,

You can find the query down here:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tblAssets.SP As [Current SP],
tblAssets.Lastseen,
tsysOS.Image As icon
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tsysOS.OSname = 'Win XP' And tblAssets.SP <> 3 And tsysOS.OScode =
'5.1.2600' And tblAssetCustom.State = 1
Order By tblAssets.AssetName