SOLVED

Urgent help in AD

%3CLINGO-SUB%20id%3D%22lingo-sub-388420%22%20slang%3D%22en-US%22%3EUrgent%20help%20in%20AD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388420%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20guys%2C%20i%20am%20new%20to%20AD%2C%20and%20i%20currently%20face%20some%20problem.%3C%2FP%3E%3CP%3Ei%20had%20a%20domain%20with%20many%20users%20and%20groups%2C%20and%20right%20now%2C%20i%20want%20to%20export%20them%20out%20to%20an%20excel%20file%20in%20such%20format%3C%2FP%3E%3CP%3Egroup%201%3CSPAN%3E%26nbsp%3B%3A%20member%201%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Egroup%201%26nbsp%3B%3A%20member%202%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Egroup%201%26nbsp%3B%3A%20member%203%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Egroup%202%26nbsp%3B%3A%20member%201%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Egroup%202%26nbsp%3B%3A%26nbsp%3B%3C%2FSPAN%3Emember%203%3CBR%20%2F%3E%3CSPAN%3Egroup%203%20%3A%26nbsp%3B%3C%2FSPAN%3Emember%201%3CBR%20%2F%3E%3CSPAN%3E.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EBut%20not%20matter%20how%20i%20try%2C%26nbsp%3B%20i%20cant%20seem%20to%20get%20both%20different%20object%20(users%20and%20group)%20together.%20sometimes%20even%20get%20back%20the%20word%20length%20only....%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ESo%20guys%2C%20can%20y'all%26nbsp%3Bkindly%20help%20me%20to%20solve%20this%20problem%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-388420%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20AD%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EIdentity%20Management%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-391601%22%20slang%3D%22en-US%22%3ERe%3A%20Urgent%20help%20in%20AD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-391601%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F38365%22%20target%3D%22_blank%22%3E%40Kevin%20Morgan%3C%2FA%3E%26nbsp%3BThanks!%20It%20helped%20alot%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-391599%22%20slang%3D%22en-US%22%3ERe%3A%20Urgent%20help%20in%20AD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-391599%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F307851%22%20target%3D%22_blank%22%3E%40jun-wu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20looking%20help%20with%20Azure%20AD%20or%20On-Premises%20AD%3F.%20You%20can%20get%20some%20idea%20from%20below%20posts%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExport%20O365%20Distributions%20Group%20Members%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.morgantechspace.com%2F2018%2F04%2Fexport-office-365-distribution-group-members-csv-powershell.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.morgantechspace.com%2F2018%2F04%2Fexport-office-365-distribution-group-members-csv-powershell.html%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExport%20O365%20Groups%20(Unified)%20and%20Members%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.morgantechspace.com%2F2016%2F06%2Flist-office-365-group-members-using-powershell.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.morgantechspace.com%2F2016%2F06%2Flist-office-365-group-members-using-powershell.html%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-388421%22%20slang%3D%22en-US%22%3ERe%3A%20Urgent%20help%20in%20AD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388421%22%20slang%3D%22en-US%22%3EBy%20the%20way%2C%20I%20am%20currently%20using%20Power%20shell%20to%20extract%20all%20those%20information%20from%20AD%3C%2FLINGO-BODY%3E
jun-wu
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
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

@Kevin Morgan Thanks! It helped alot

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies