Audit: Windows Servers with TS/RDS Role (App-Mode)

[AdmJLovejoy]

Select Top (1000000) tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tsysOS.Image As icon
From tblAssets
Inner Join tblRegistry As tblRegistrya On tblAssets.AssetID =
tblRegistrya.AssetID And tblRegistrya.Valuename = 'TSAppCompat'
Left Outer Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblRegistrya.Value = '1' And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tblAssets.Domain

[Susan_A]

FYI for everyone: this report requires you to submit the TSAppCompat value in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server for registry scanning.