Good idea, would alerting be a requirement or what if you have an app that ran on your desktop that monitored the service?
My vision would be this service would reside on any server, except those hosting Orion Functions or the SQL Database. So let's assume Print Server.
On the Print Server I Launch ORION IMS (Independent Monitor Service).
- I enter my NPM server(s), ORION specific services are located and added for monitoring.
- I enter my SQL server name and select the database. I enter a SQL query to execute.
- I enter my SMTP settings
- I enter service frequency 5/10/15/30 minutes
- I click update service
- Service install, xml or ini file created with preferences.
- When service is successful, info entered into ORION DB, so I can see it NPM.
- If a check fails, the ORION IMS service triggers an email: example
- Subject:ORION IMS detected an issue
- Body1: Process Orion Services failed. Service <name> is in status <state>
- Body2: Process SQL Check failed. SQL query did not return expected value.
During the day I can open NPM and I can check the ORION IMS status page for information.
This service would be beneficial if at night my NPM server crash, if SQL server crashed, there are other scenerios as well.