2
Do you want one email per server or one email for all servers?
One per server is easy, push out a job that does your check and send the email using sp_send_dbmail. This can be done through an MSX server if you want.
One mail for all servers requires a client that query each servers and collect the info and finally send email. Powershell is likely a good idea....
Only top voted, non community-wiki answers of a minimum length are eligible