Adresslist - All users

%3CLINGO-SUB%20id%3D%22lingo-sub-752747%22%20slang%3D%22en-US%22%3EAdresslist%20-%20All%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752747%22%20slang%3D%22en-US%22%3EHello.%20My%20question%20is%20about%20the%20global%20address%20list.%20How%20do%20i%20create%20an%20address%20list%20with%20all%20users%20which%20have%20an%20office%20365%20license%3F%20Currently%20the%20All%20Users%20list%20is%20also%20showing%20shared%20mailboxes%20with%20login%20ability.%20Also%20the%20rooms%20are%20there%20listed.%20Thanks.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-752747%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExchange%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-753399%22%20slang%3D%22en-US%22%3ERe%3A%20Adresslist%20-%20All%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-753399%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F59777%22%20target%3D%22_blank%22%3E%40Dirk%20Schmeckthal%3C%2FA%3E%26nbsp%3Bwhat%20I%20would%20do%20is%20select%20%22hide%20from%20address%20lists%22%20with%20everything%20you%20don't%20want%20to%20show%20up%20in%20the%20GAL.%20You%20can%20do%20this%20with%20all%20mail%20enabled%20objects%20(mailboxes%2C%20groups%20etc.).%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123219i31581E9AA6E52C8B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22smb.jpg%22%20title%3D%22smb.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754255%22%20slang%3D%22en-US%22%3ERe%3A%20Adresslist%20-%20All%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754255%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20it's%20an%20actual%20address%20list%20you%20want%20to%20create%20(not%20hide%20from%20the%20GAL%20or%20something)%2C%20you%20can%20use%20the%20following%20query%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%7BSkuAssigned%20-eq%20%24true%7D%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3EIf%20you%20want%20to%20further%20limit%20it%20to%20just%20(user)%20mailboxes%3A%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%7BSkuAssigned%20-eq%20%24true%20-and%20RecipientTypeDetails%20-eq%20%22UserMailbox%22%7D%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774001%22%20slang%3D%22de-DE%22%3ERe%3A%20Address%20list%20-%20All%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774001%22%20slang%3D%22de-DE%22%3EHello%20Vasil.%20%3CBR%20%2F%3ESorry%20for%20the%20delayed%20reply.%20%3CBR%20%2F%3ECould%20you%20please%20gibe%20me%20a%20hint%20how%20to%20use%20this%20query%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774007%22%20slang%3D%22de-DE%22%3ERe%3A%20Address%20list%20-%20All%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774007%22%20slang%3D%22de-DE%22%3EHello%20Dennis.%20%3CBR%20%2F%3EThanks%20for%20your%20suggestion%2C%20but%20I%20want%20to%20have%20is%20a%20separate%20address%20list%20with%20all%20users%20that%20got%20an%20o365%20license%20assigned.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774581%22%20slang%3D%22en-US%22%3ERe%3A%20Adresslist%20-%20All%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774581%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20will%20have%20to%20update%20the%20recipient%20filter%20on%20any%20and%20all%20Address%20lists%20you%20need%20to%20show%20just%20licensed%20users.%20Or%20create%20new%20ones%2Fassign%20them%20to%20users.%20Here's%20an%20example%20with%20creating%20a%20new%20one%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3ENew-AddressList%20-Name%20LicensedMailboxes%20-RecipientFilter%20%7BSkuAssigned%20-eq%20%24true%20-and%20RecipientTypeDetails%20-eq%20%22UserMailbox%22%7D%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor
Hello. My question is about the global address list. How do i create an address list with all users which have an office 365 license? Currently the All Users list is also showing shared mailboxes with login ability. Also the rooms are there listed. Thanks.
5 Replies
Highlighted

@Dirk Schmeckthal what I would do is select "hide from address lists" with everything you don't want to show up in the GAL. You can do this with all mail enabled objects (mailboxes, groups etc.).

smb.jpg

Highlighted

If it's an actual address list you want to create (not hide from the GAL or something), you can use the following query:

 

{SkuAssigned -eq $true}

 

If you want to further limit it to just (user) mailboxes:

 

{SkuAssigned -eq $true -and RecipientTypeDetails -eq "UserMailbox"}

 

 

Highlighted
Hello Vasil.
Sorry for the delayed reply.
Could you please gibe me a hint how to use this query?
Highlighted
Hello Dennis.
Thanks for your suggestion, but i want to have is a separate address list with all users that got an o365 license assigned.
Highlighted

You will have to update the recipient filter on any and all Address lists you need to show just licensed users. Or create new ones/assign them to users. Here's an example with creating a new one:

 

New-AddressList -Name LicensedMailboxes -RecipientFilter {SkuAssigned -eq $true -and RecipientTypeDetails -eq "UserMailbox"}