Secret Server report to show discovered AD Users and each group they are in. Each group is in it's own row. Filtered by group name.

Secret-Server--Discovery-AD-Accounts--Users-And-Groups-Filtered.sql

SELECT 
	A.[OU DN],
	A.[AccountName],
	Split.a.value('.', 'VARCHAR(1000)') AS [Group]
FROM (
	SELECT 
		[ou].[DistinguishedName] AS 'OU DN',
		[ca].[AccountName], 
		CAST ('<M>' + REPLACE(REPLACE(REPLACE(REPLACE([ca].[SearchGroups], '&', '\u0026'), '<', '\u003C'), '>', '\u003E'), CHAR(59), '</M><M>') + '</M>' AS XML) AS [Group] 
	FROM [tbComputerAccount] [ca]
	JOIN [tbOrganizationUnit] [ou] ON [ca].[OrganizationUnitId] = [ou].[OrganizationUnitId]
) AS A 
CROSS APPLY [Group].nodes ('/M') AS Split(a)
WHERE Split.a.value('.', 'VARCHAR(1000)') LIKE '%' + #CUSTOMTEXT + '%'
ORDER BY
	[Group],
	A.[OU DN],
	A.[AccountName]