I need to query the SQL Server Content Store Database to find a list of users who belong to a specific Cognos group.
SELECT *
FROM ContentStore.dbo.CogGroup
WHERE GroupName = '<GroupName>'
I need to query the SQL Server Content Store Database to find a list of users who belong to a specific Cognos group.
SELECT *
FROM ContentStore.dbo.CogGroup
WHERE GroupName = '<GroupName>'
The answer is:
SELECT *
FROM ContentStore.dbo.CogGroup
WHERE GroupName = '<GroupName>'
This SQL query will return all the users who belong to the Cognos group named <GroupName>
from the SQL Server Content Store Database.