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>
Questions?
If you have any questions or need some help, we would be happy to assist. Open a case at help.scorpionsoft.com or send an email to support@scorpionsoft.com.