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?
SELECT distinct u.username
FROM users u
Please let me know if that helps.
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?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?