Validating mx record

If you proceed without restarting then setup may be unable to proceed when it detects the pending restart.

validating mx record-27

Probably typos or email like '%.or' or email like '%.ne' -- Missing last letter 0 -- Valid but cannot be ending character or email_address not like '%@%.%' -- Must contain at least one @ and one .

or email_address like '%..%' -- Cannot have two periods in a row or email_address like '%@%@%' -- Cannot have two @ anywhere or email_address like '%[email protected]%' or email_address like '%@.%' -- Cant have @ and .

A data import was done from an access database and there was no validation on the email address field.

Does anyone have an sql script that can return a list of invalid email addresses (missing @, etc). SELECT * FROM `emails` WHERE `email` NOT REGEXP '[-a-z0-9~! ] )*@([a-z0-9_][-a-z0-9_]*(\\.[-a-z0-9_] )*\\.(aero|arpa|biz|com|coop|edu|gov|info|int|mil|museum|name|net|org|pro|travel|mobi|[a-z][a-z])|([0-9]\\.[0-9]\\.[0-9]\\.[0-9]))(:[0-9])? ' 0 -- Valid but cannot be ending character or email not like '%@%.%' -- Must contain at least one @ and one .

He works as a consultant, writer, and trainer specializing in Office 365 and Exchange Server.

Paul is a co-author of Office 365 for IT Pros and several other books, and is also a Pluralsight author.

The "Servers involved in resolving" table at the end is neat. For example, its not immediately clear where it stops querying one nameserver and begins querying the next.

A persistent database of zones that are periodically re-checked.

Because the Active Directory preparation requires the RSAT-ADDS tools I am running it on the domain controller in my test lab.

688 Comments

  1. It may not be as fascinating to you as it is to her, but remember that her world will expand with time just like yours did.

Comments are closed.