[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 325
  • Last Modified:

Query Based distribution Groups

Few months ago I migrate 2003 exchange server to 2010 exchange server. I did covert the query-based distribution groups to universal but I did missed 2 groups. The 2003 Exchange servers doesn't exist anymore. How can I edit or convert the Query-Based Distribution Groups on Exchange 2010? I need access to those groups so I can add and remove users from it.

Thank you very much
0
paco1969
Asked:
paco1969
  • 12
  • 9
1 Solution
 
EEhotlineCommented:
Hello,

Do you see those 2 groups in the group? Did you get any error when modifying their properties?
0
 
paco1969Author Commented:
Yes I can see both groups but when I go to properties, it shows me only 3 tabs on top: ManagedBy, Object and Security. As of a Universal group shows all the tabs: General, members, member of, Managed by, attribute editor security and object. It does not give any errors, but it shows and invalid icon.

Thank you for your assistance
0
 
Jamie McKillopIT ManagerCommented:
Hello,

You need to first create a new recipient filter, based on the LDAP filter. You then run the following powershell command:

Set-DynamicDistributionGroup -Identity "GROUPNAME" -RecipientFilter { <Filter systax> }

If you need help converting the filter, let me know exactly what the filter does.

-JJ
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
paco1969Author Commented:
JJ thank you very much for your help. The group is called "Indy" that is for all the users at the indy office. I will need help with the convertion.
0
 
Jamie McKillopIT ManagerCommented:
If the Office field for these users is "Indy", the command would look like this:

Set-DynamicDistributionGroup -Identity "Indy" -RecipientFilter { (Office -eq 'Indy') }

-JJ
0
 
paco1969Author Commented:
JJ where do I find the filter syntax?
0
 
Jamie McKillopIT ManagerCommented:
I've already populated the filter syntax for what you want to do in the command above. It would be (Office -eq 'Indy')

That will put any object with the value of the "Office" field equal to "Indy" into the group.

-JJ
0
 
paco1969Author Commented:
Thank JJ when I go to the properties of the group under EMC, under the filter tab this is what it looks like: ((Office -eq 'Indy') -and (-not(Name -like 'SystemMailbox{*')) -and (-not(Name -like 'CAS_{*')) -and (-not(RecipientTypeDetailsValue -eq 'MailboxPlan')) -and (-not(RecipientTypeDetailsValue -eq 'DiscoveryMailbox')) -and (-not(RecipientTypeDetailsValue -eq 'ArbitrationMailbox')))

 and this is the result after the command:  

[PS] C:\Windows\system32>Set-DynamicDistributionGroup -Identity "Indy" -RecipientFilter { (Office -eq 'Indy') }

Confirm
To save changes on object "Indy", the object must be upgraded to the current Exchange version. After the upgrade, this
object cannot be managed by an earlier version of the Exchange Management Tools. Do you want to continue to upgrade and
 save the object?
[Y] Yes  [A] Yes to All  [N] No  [L] No to All  [?] Help (default is "Y"): y
[PS] C:\Windows\system32>
0
 
Jamie McKillopIT ManagerCommented:
OK, that looks good. Go back to the filter tab. make sure the recipient container is set to the base container you want to search in. Click the Preview tab and make sure the objects that are returned are those you expect.

-JJ
0
 
paco1969Author Commented:
JJ, preview window is blank
0
 
Jamie McKillopIT ManagerCommented:
Is the recipient container set correctly? Make sure it is set to the root of your domain. Also, in ADUC, open one of the user that should appear and make sure the office field had "Indy" exactly.

-JJ
0
 
paco1969Author Commented:
how do I set it to the root of the domain?. and I did check user and under office field is blank
0
 
Jamie McKillopIT ManagerCommented:
On the filter tab, click Browse and you will see your OU tree. Click on the top level to have it search your entire OU structure.

How was you previous LDAP filet setup? Run Get-DynamicDistributionGroup "Indy" | select ldaprecipientfilter and post the results.

-JJ
0
 
paco1969Author Commented:
LdapRecipientFilter
-------------------
(&(physicalDeliveryOfficeName=Indy)(!(name=SystemMailbox{*))(!(name=CAS_{*))(!(msExchRecipientTypeDetails=16777216))...
0
 
Jamie McKillopIT ManagerCommented:
You say the users you want in the group have a blank Office field in AD? We need some unique property for users in this office. Are they all in the same OU?

-JJ
0
 
paco1969Author Commented:
when I browse under the filter tab it gives me this: trendsinternational.com/Trends Users/Indy
the actual distribution group is in: trendsinternational.com/distribution groups/Indy
0
 
paco1969Author Commented:
the e-mail for the distribution group indy works fine but I can't edit, add or remove users and I can't see members of it wither and it shows as an invalid group icon
0
 
paco1969Author Commented:
and yes, we all are under same OU: trendsinternational.com/Trends Users/Indy
0
 
Jamie McKillopIT ManagerCommented:
You can't manually add or remove members from a dynamic group. The whole point of a dynamic group is that it is based on a query.

The query is currently set to only look in trendsinternational.com/Trends Users/Indy. If you want all users in that OU to be in the group, just change the filter by running:

Set-DynamicDistributionGroup -Identity "Indy" -RecipientFilter { (RecipientType -eq 'UserMailbox') }

-JJ
0
 
paco1969Author Commented:
JJ, I see, thank you very much. We can mark this as an answered question.
0
 
paco1969Author Commented:
you are the greatest JJ
0
 
Jamie McKillopIT ManagerCommented:
Thanks. If you are all set, please accept one of my comments and assign points.

-JJ
0

Featured Post

Easily manage email signatures in Office 365

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

  • 12
  • 9
Tackle projects and never again get stuck behind a technical roadblock.
Join Now