Querying data from PostgreSQL into Orion.

routermonkey

Morning,

We have a custom monitoring application that we use to monitor the health of remote sites. Currently, using another monitoring solution, we pull those stats in for monitoring, graphing and alerting. The data is stored in a PostgreSQL database and it queries the database to pull those stats into the monitoring system.

I'm currently trying to figure out how we can do the same in Orion. I need a way to run SQL queries against this database and store the results (which are all integers) I know that worse case, I can probably have a script running somewhere to push these numbers into the Orion db, but I'd rather avoid custom code and do this with Orion directly, if possible. I do have SAM, so perhaps that can be leveraged to accomplish this.

Ideas?

aLTeReGo

You will probably want to look at Server & Application Monitor's ODBC User Experience Monitor. It has the ability to execute queries against a database that return numeric values, store them, chart them, report them,, set thresholds (if so desired) and alert upon those values.