Urgent help in AD

New Contributor

Hey guys, i am new to AD, and i currently face some problem.

i had a domain with many users and groups, and right now, i want to export them out to an excel file in such format

group 1 : member 1
group 1 : member 2
group 1 : member 3
group 2 : member 1
group 2 : member 3
group 3 : member 1


But not matter how i try,  i cant seem to get both different object (users and group) together. sometimes even get back the word length only....


So guys, can y'all kindly help me to solve this problem?

3 Replies
By the way, I am currently using Power shell to extract all those information from AD
best response confirmed by jun-wu (New Contributor)



Are you looking help with Azure AD or On-Premises AD?. You can get some idea from below posts:


Export O365 Distributions Group Members:


Export O365 Groups (Unified) and Members:

@Kevin Morgan Thanks! It helped alot