I would like to import all users in AD but eliminate users without an email address.

This works when running a query on AD but not from Kace


Kace does not like (!(!mail=*)) which removes users with out email. 

Are there any work arounds for this without me adding all users accounts without email to another group and excluding the group?


Answer Summary:
1 Comment   [ + ] Show Comment


  • Thanks for the reply. This was my first post and it took two days for IT Ninja to approve my account and this post to become public.

    I ended up adding all my external and service accounts without email to a group and excluding it: (!(memberOf=NEW-GROUP))
Please log in to comment


The way I did it when I was adding my users, I wanted all users that had the Office field populated. So my simple query pulls only users that have physicaldeliveryofficename populated:


Note I am using their email address as the username.
Answered 02/24/2015 by: h2opolo25
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity