Previously I have run a query that allows me to see all groups and their types (univ, Global etc) and added an extra column of username. When run the query has reported all members in a group and their domain details in [ ] square brackets. Even users who are in the same domain as the tool were reported in Disting format. Since the latest upgrade I've lost where or how to do this. Is there a setting. Bascially i want to be able to filter out all groups that are universal - and see in which of the trusted domains the users in those groups are based. Using a search and replace I replaced uk], with a ! then split out in excel into colums the exported file so one user appeared per cell, I then looked for the domain name and changed the contents to domain1 =1 domainb=2. Using conditional formatting I could then see by colour whcih universal groups were heavily biased to one domain or another.

 

can anyone tell me how to list members of the groups with all members notated in the same format whether they be in an alternative domain or the one where the tool is installed.