Exchange Online Mailbox Association with AD account on Premise

%3CLINGO-SUB%20id%3D%22lingo-sub-63141%22%20slang%3D%22en-US%22%3EExchange%20Online%20Mailbox%20Association%20with%20AD%20account%20on%20Premise%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-63141%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Experts%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20there%20any%20way%20to%20pull%20a%20report%20of%20Exchange%20Mailbox%20association%20with%20On-premise%20AD%20account%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewe%20have%202%20AD%20forests%20and%20both%20are%20synching%20with%20Azure%20AD%20via%20AAD%20connect%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20need%20to%20find%20how%20many%20mailboxes%20are%20still%20tied%20to%20Forest%201.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-63141%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExchange%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExchange%20Server%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EHybrid%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOutlook%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-63170%22%20slang%3D%22en-US%22%3ERe%3A%20Exchange%20Online%20Mailbox%20Association%20with%20AD%20account%20on%20Premise%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-63170%22%20slang%3D%22en-US%22%3EI%20don't%20see%20anywhere%20on%20Azure%20AD%20or%20Exchange%20Online%20where%20it%20specify%20Forest%20FDQN.%20Correct%20me%20If%20I%20am%20wrong.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-63168%22%20slang%3D%22en-US%22%3ERe%3A%20Exchange%20Online%20Mailbox%20Association%20with%20AD%20account%20on%20Premise%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-63168%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F58%22%20target%3D%22_blank%22%3E%40Vasil%20Michev%3C%2FA%3E%26nbsp%3Bwe%20use%20ObjectGuid%2FImmutble%20ID%20as%201%3A1%20co-relation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20went%20to%20AAD%20and%20did%20metaverse%20search%20based%20and%20added%20value%20as%20xyz.com%20and%20i%20was%20able%20to%20pull%20the%20reports%20for%20users%20whos%20mailboxes%20are%20still%20mapped%20to%20xyz.com%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20i%20did%20correct.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F46914%22%20target%3D%22_blank%22%3E%40Vishal%20Kalal%3C%2FA%3E%26nbsp%3B%3A%20Thanks%20buddy.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUPN%2FDisplayanme%2FfORESTfqdn%20is%20what%20i%20am%20looking%20for%3F%20can%20i%20use%20your%20PS%20for%20same%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-63164%22%20slang%3D%22en-US%22%3ERe%3A%20Exchange%20Online%20Mailbox%20Association%20with%20AD%20account%20on%20Premise%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-63164%22%20slang%3D%22en-US%22%3E%3CP%3EWell%20you%20have%20the%20ImmutableID%2FSourceAnchor%20parameter%2C%20it's%20a%201%3A1%20mapping%20between%20cloud%20and%20on-prem%20objects.%20Depending%20on%20your%20configuration%2C%20it%20can%20use%20different%20set%20of%20attributes%2C%20the%20default%20one%20being%20ObjectId%20for%20single-forest%20and%20objectSID%2FmsExchMasterAccountSid%26nbsp%3Bfor%20account%2Fresource%20forest%20configuration.%20So%20check%20what%20you%20are%20using%20and%20then%20match%20the%20values%20between%20O365%20mailboxes%20and%20the%20on-prem%20forest(s).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-63161%22%20slang%3D%22en-US%22%3ERe%3A%20Exchange%20Online%20Mailbox%20Association%20with%20AD%20account%20on%20Premise%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-63161%22%20slang%3D%22en-US%22%3E%3CP%3ECould%20you%20please%20let%20us%20know%20what%20all%20information%20you%20need%20in%20the%20report.%20we%20can%20prepare%20a%20powershell%20script%20and%20shae%20with%20you.%20Incase%20if%20User%20Name%2C%20Display%20Name%20and%20Email%20address%20will%20help%20you%2C%20you%20can%20use%20below%20PowerShell%20scrip%20and%20run%20on%20Exchange%20online%20powershell%20to%20get%20the%20output-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Deleted
Not applicable

Hello Experts,

 

is there any way to pull a report of Exchange Mailbox association with On-premise AD account

 

we have 2 AD forests and both are synching with Azure AD via AAD connect

 

We need to find how many mailboxes are still tied to Forest 1.

4 Replies
Highlighted

Could you please let us know what all information you need in the report. we can prepare a powershell script and shae with you. Incase if User Name, Display Name and Email address will help you, you can use below PowerShell scrip and run on Exchange online powershell to get the output-

 

Highlighted

Well you have the ImmutableID/SourceAnchor parameter, it's a 1:1 mapping between cloud and on-prem objects. Depending on your configuration, it can use different set of attributes, the default one being ObjectId for single-forest and objectSID/msExchMasterAccountSid for account/resource forest configuration. So check what you are using and then match the values between O365 mailboxes and the on-prem forest(s).

Highlighted

Hi @Vasil Michev we use ObjectGuid/Immutble ID as 1:1 co-relation.

 

I went to AAD and did metaverse search based and added value as xyz.com and i was able to pull the reports for users whos mailboxes are still mapped to xyz.com

 

I hope i did correct.

 

@Vishal Kalal : Thanks buddy.

 

UPN/Displayanme/fORESTfqdn is what i am looking for? can i use your PS for same?

Highlighted
I don't see anywhere on Azure AD or Exchange Online where it specify Forest FDQN. Correct me If I am wrong.