5 Replies Latest reply on Nov 12, 2014 6:44 AM by EJW

    How can i query users by what their first name starts with?

    Apprentice

      I'm setting up my patch process.  I have a static group of machines for my initial patch testing.  I'd like to set up a 20% Pilot group, but don't want to be dealing with keeping it up to date, nor do i want my IT team to have to refer to a list to see if a user is part of the pilot group or not.

       

      I want to select 20% by creating a query that returns all users with a first name that starts with a letter between A and J.  This will give me 20% of our environment that is pretty much random.  It's also easy for the IT team to remember that if a person's first name is between A and J then they are piloting patches.

       

      How can i do this?