Sends an email report on the previous day’s login activity to a specified address. Requires access to an SMTP server that allows anonymous access. Easily automated using Scheduled Tasks. Recipient addresses can be separated by semicolons (with no spaces) for multiple recipients.
Usage: cscript AAEmailReport.vbs SQLSERVERNAME\SQLINSTANCENAME [or just SQLSERVERNAME if no instances installed] <RUNLEVEL> <FROMADDRESS> <TOADDRESS> <SMTPSERVER>