• State Not Answered
  • Replies 2 replies
  • Subscribers 62 subscribers
  • Views 311 views
  • Users 0 members are here
Options
Related

Dynamic Distro - Filter Help

ken hansen
4 months ago

In our environment we have different groups of users, and they have different formats of their EmployeeID. Some are all numbers, and some are prefaced with an alpha character. I am trying to come up with a query to only include users with an EmployeeID with no alpha characters. Is that possible? I know I can script this in PS and manage it that way (which I have done in the past), but to compensate for the learning curve of all the users using this tool, I would like to keep everything in the GUI.

Alternatively, is there a way to add a regular LDAP query to the membership rules? I don't see a way in the GIU to add each criteria and nest them so I can have AND and OR statements. 

Parents
  • 0 4 months ago

    If the EmployeeIDs are truly prefixed with letters, and not contains letters, then the Dynamic Group's rules could have 10 entries for 'Starts With', one for each digit 0-9, that are ORed together. This would filter out any EmployeeID that does not start with a number.

    To add a custom written LDAP query to a Dynamic Group's Membership Rules, select the rule type 'Include by Query' or 'Exclude by Query' (depending on what you're trying to accomplish with the LDAP query) and in the 'Find' drop-down list of object types, select Custom Search, and then select the Advanced tab.

Reply
  • 0 4 months ago

    If the EmployeeIDs are truly prefixed with letters, and not contains letters, then the Dynamic Group's rules could have 10 entries for 'Starts With', one for each digit 0-9, that are ORed together. This would filter out any EmployeeID that does not start with a number.

    To add a custom written LDAP query to a Dynamic Group's Membership Rules, select the rule type 'Include by Query' or 'Exclude by Query' (depending on what you're trying to accomplish with the LDAP query) and in the 'Find' drop-down list of object types, select Custom Search, and then select the Advanced tab.

Children