Dynamic distribution lists looking for a string in departments

[nicholab]

Anyone suggest how I can look for a string in Dynamic distribution list as I need to set this up for the parental contacts. Currently the system use a year group in Departments and company I would like to be able to have one field that contains all the year groups a parents needs say "1,5,6"? Also it currently breaks for families with more that two student in the school.

[HPlum78]

My first thought on this would be to give each year a binary number then script the groups based on the calculation in the attribute..... I will give this more thought.

[nicholab]

My first thought on this would be to give each year a binary number then script the groups based on the calculation in the attribute..... I will give this more thought.

 

That would be a pain as you would need to work out a value you for every permutation which is at about 60 combination if you allow every parent to have 5 children in the school.

[HPlum78]

Yeah 52 different combinations I reckon (if you have 13 year groups and 5 children per parent, assuming that you don't calculate a value for the first child) but the values are a known that's the point behind the exercise. You could then store that value in one of the extensionattributes in AD and then create the groups based on the value found in that attribute by using dynamic distribution groups or as I would do have a script that updates the membership of a group in AD. To be honest working out the values for 52 combinations is a trivial matter for a computer and any programing language or an excel spread sheet!

[nicholab]

Yeah 52 different combinations I reckon (if you have 13 year groups and 5 children per parent, assuming that you don't calculate a value for the first child) but the values are a known that's the point behind the exercise. You could then store that value in one of the extensionattributes in AD and then create the groups based on the value found in that attribute by using dynamic distribution groups or as I would do have a script that updates the membership of a group in AD. To be honest working out the values for 52 combinations is a trivial matter for a computer and any programing language or an excel spread sheet!

 

I recalculate and I think it is over 200,000 combinations.

[HPlum78]

I have miss understood the initial requirment and I was thinking about putting the contact in an AD group called year 1/ year 2 so on.... and then calculating a value from there but to be fair that's over kill you could just use the year group and forget about a calculated value all together, the only reason I was thinking about a value was for automation of the administrative tasks on the groups in the future, along with calculating the dynamic distribution group but that's just not needed and unnesaersary to be honest. Edited November 2, 2017 by HPlum78

[nicholab]

So I would want to search for the like value of YR1* and YR5* and YR7* but this does not seem to work.

[HPlum78]

new-DynamicDistributionGroup -Name 'EDG-Year7-Parents' -OrganizationalUnit 'DomainName/Groups/Email/Distribution/Dynamic Groups' -Alias 'Year7 Parents' -RecipientFilter {(MemberOfGroup -LIKE "CN=EDM-HP273-1,OU=Distribution,OU=Groups,DC=YourDomain,DC=Sch,DC=uk")}

 

I think that looks right.....

[nicholab]

new-DynamicDistributionGroup -Name 'EDG-Year7-Parents' -OrganizationalUnit 'DomainName/Groups/Email/Distribution/Dynamic Groups' -Alias 'Year7 Parents' -RecipientFilter {(MemberOfGroup -LIKE "CN=EDM-HP273-1,OU=Distribution,OU=Groups,DC=YourDomain,DC=Sch,DC=uk")}

 

I think that looks right.....

 

Does that work for multi groups or may be I have a dynamic group nested in a static group?

[HPlum78]

It should accept -and or multiple -and's

[nicholab]

I mean can it work with “y2 y3 y5” and put them into three groups?