Secret Server report to show discovered total AD users per group.

Secret-Server--Discovery-AD-Accounts--Total-Members-By-Group.sql

SELECT
	B.[Group],
	COUNT(B.[AccountName]) AS [Total Members]
FROM (
	SELECT
		Split.a.value('.', 'VARCHAR(1000)') AS [Group],
		A.[AccountName]
	FROM (
		SELECT
			[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)
) B
GROUP BY
	[Group]