Urgent help in AD

[jun-wu]

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?

[#2]

By the way, I am currently using Power shell to extract all those information from AD

[#3 · Accepted solution]

@jun-wu 

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

Export O365 Distributions Group Members:
https://www.morgantechspace.com/2018/04/export-office-365-distribution-group-members-csv-powershell....

Export O365 Groups (Unified) and Members:
https://www.morgantechspace.com/2016/06/list-office-365-group-members-using-powershell.html

[#4]

@Kevin Morgan Thanks! It helped alot