Hello
I have created a report, the values of custom registry scan lists, grouped by tblRegistry.Value.
I get a List with the Value of the Registry key and the Count of Assets on which the Key is set.
Is there a way to make the Value in the List clickable and to show a List of the individual Assets?
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
Greetings, Stephan