*Note: The direct download and version information is available below
There were some questions on my team regarding how to send emails based on events generated in the Horizon View EventsDB. The Horizon View Events Database was first introduced with Horizon View 4.5. There is a great article by Dwayne Lessner on doing this using SQL and PowerShell (http://itbloodpressure.com/2011/02/27/no-desktops-big-problems/). I decided to write something in vb.net that would allow this alerting external to the SQL database.
I wrote the application in vb.net and used the standard SQL client and Mail references. The application has a settings tab which allows configuration of the SQL server/instance and username/password. It allows you to test the SQL connection prior to starting the application. You can also choose what type of alerts to notify on. By default, only error events are alerted on, but you can choose to be notified on Warnings and Audit failures. You can also now choose how many minutes back you want to query the EventsDb. You also set an SMTP server, port and an email address to send the alerts from. You can add multiple addresses in the alert recipients field. You can also test the SMTP connection by sending a test email. All of the settings are saved in an xml configuration file, and the SQL password is 256 bit AES encrypted. To start the application, simply click the start button, or start with the /silent switch. The silent switch starts the application automatically and minimizes to the system tray. Minimizing the application will also send it to the system tray. By default, the application polls every 60 seconds for new events to alert on. There is now a context menu from the tray that allows you to refresh now, show the full form and exit the application.
UPDATE – The application is available from the link below. I have also added some new features. There is a readme.txt in the .zip that details how to configure it.
Version 1.5: Added ability to clear events, system tray context menu and how far back to query events
Version 1.6: Added Database Name field and Table Prefix options for SQL configuration
Horizon View Events Notifier Version 1.6 Download: http://goo.gl/WP7Vnt