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
Highlighted
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
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies