CMS Audiences - check all usage
Sometimes you want to check if an Audience from your CMS (former Visitor Group) has been used by which page(and which version of that page)
Then you just need to use my sample SQL query to check the usage of that audience:
CREATE TABLE #TempGUID(ID INT IDENTITY(1,1),VGName VARCHAR(50), VGGuid VARCHAR(36));
INSERT INTO #TempGUID (VGName,VGGuid) SELECT String01, Guid FROM tblSystemBigTable SBT join tblBigTableIdentity BTI ON SBT.pkId = BTI.pkId where SBT.StoreName = 'VisitorGroup' ;
DECLARE @CurrentValue VARCHAR(36);
DECLARE @CurrentName VARCHAR(50);
DECLARE @MinID INT = (SELECT MIN(ID) from #TempGUID);
WHILE @MinID IS NOT NULL
BEGIN
SELECT @CurrentValue = VGGuid,@CurrentName = VGName FROM #TempGUID WHERE ID = @MinID
SELECT DISTINCT @CurrentName AS AudienceName,fkContentID AS ContentID,NAME AS ContentName,pkID AS VersionNumber FROM tblWorkContent WHERE pkID IN
(SELECT fkWorkContentID FROM tblWorkContentProperty WHERE LongString like ('%'+ @CurrentValue+'%'))
DELETE FROM #TempGUID WHERE ID = @MinID;
SET @MinID = (SELECT MIN(ID) from #TempGUID);
END;
DROP TABLE #TempGUID;The reult should look like this:
Hope that help!
Dec 12, 2025
Comments