Forum Discussion
dskeane
5 years agoHelper I
AD Group members
Looking to get a list of AD Security Groups and the members that are associated with that group. I do have the AD connector working and looking to figure out what table holds that information, I trie...
amitchandak
5 years agoSuper User
dskeane , refer if these can help
https://matt40k.uk/2016/06/getting-a-list-of-ad-groups-and-their-members-using-powerquery/
- dskeane5 years agoHelper I
That informatoin is good and I believe answers my question. It sure does answer one part which is the Group table Column "securityprincipal" was holding the informatoin i was looking for. The next part I cant seem to figure out is if I need to create a relationship to the user table or I just missed the information in some instructions.
Amitchandak, thank you!
- dskeane5 years agoHelper I
Never mind my last statement the two links attached by Amitchandak answer both sides of my question.
Again thanks!