How do I search for Users with invalid (malformed) email addresses?

Submitted by pwjm6392@ncedcl... on Sat, 11/29/2014 - 22:19

What you want to do is search for all users in your PSU that do not have a VALID email address format.  You can do this by following this procedure:

  1. Select the Manage Employees tab or Manage Students tab (under Profiles)
  2. Click on the Advanced Search checkbox and enter...
  3. For ALL users (Last Name = *) AND with an invalid email address format (Email != *@*.*)

The equation: Email  !=  *@*.*  translates as Email NOT EQUAL to wildcard@wildcard.wildcard (where "wildcard" represented by an asterisk, can be ANY value)

This search will turn up all users with invalid email addresses, such as those missing: the principal name, the @, or the school domain (e.g. emailname@lea.nc.gov)

FAQ category: 
LEA Administrators and Data Auditors