Urgent help in AD

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?

Kevin_Morgan
Iron Contributor
Mar 31, 2019
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.html

Export O365 Groups (Unified) and Members:
https://www.morgantechspace.com/2016/06/list-office-365-group-members-using-powershell.html
- jun-wu
  Copper Contributor
  Mar 31, 2019
  Kevin_Morgan Thanks! It helped alot
jun-wu
Copper Contributor
Mar 25, 2019
By the way, I am currently using Power shell to extract all those information from AD

Forum Discussion