‎04-13-2015 11:11 AM
Select Top 1000000 tblRegistry.Value As [SAP InstServer],
Count(tblRegistry.Valuename) As Total
From tblRegistry
Inner Join tblAssets On tblAssets.AssetID = tblRegistry.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where (tblRegistry.Regkey Like '%SOFTWARE\Wow6432Node\SAP\SAP Shared' Or
tblRegistry.Regkey Like '%SOFTWARE\SAP\SAP Shared') And
tblAssetCustom.State = 1
Group By tblRegistry.Value,
tblRegistry.Regkey
Order By Total Desc
Solved! Go to Solution.
‎04-13-2015 01:14 PM
‎04-16-2015 12:54 PM
‎04-13-2015 02:14 PM
‎04-13-2015 01:14 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now