none
List of AD Security Groups Used in Report Manager

    Question

  • Hi, 

    We are using SSRS 2008 r2 in native mode and I am trying to extract a list of all the AD security groups used on our report server. What is the best way to extract a list?

    Thanks

    Tuesday, November 26, 2013 12:28 PM

All replies

  • Hi,
    you can use the select below (SSRS report server) to get all active/assigned security groups/users. 
    If you use groups only for your security you should be fine.

    SELECT distinct u.username

    FROM users u 

    JOIN policyuserrole pur ON u.userid = pur.userid 
    JOIN policies p ON p.policyid = pur.policyid 
    JOIN catalog c ON c.policyid = p.policyid
    WHERE c.TYPE = 2 --Reports Only

    Please let me know if that helps.

    Wednesday, November 27, 2013 7:05 PM
  • Thanks for this.

    There are some AD groups which are missing from the data returned from the script above.

    The AD group is missing from the username table is there another way of finding these groups?

    Thanks

    Thursday, November 28, 2013 9:20 AM