Need to Create a Sets that exclude attribute that begins with hyphen RRS feed

  • Question

  • Can someone please tell me how to create a set that exclude all users with loginname that starts with "_".  The provisioned team in their wisdom adds a hyphen to the beginning of a login name when a user is terminated.  I need to create a sets that exclude those users.  The Criteria-based statement of LogiName not starts with _ does not work.

    Along the same line, how to exclude all members who has an attribute with an empty value as in EmployeeID is empty.

    Thanks in advance for the help.

    P.S. This is FIM 2010, we haven't upgraded to R2 yet.

    Friday, October 5, 2012 3:54 PM


  • Hi,

    Actually the _ (undersocre) character hitself have another meaning: LIKE (Transact-SQL)

    Enter the _ (underscore) bewten [] like this: Account Name no start with [_]


    Patrick Layani

    • Proposed as answer by Patrick Layani Thursday, October 11, 2012 8:14 AM
    • Marked as answer by RalphB Thursday, October 11, 2012 4:03 PM
    Saturday, October 6, 2012 6:30 AM