Hey folks,
I am monitoring a bunch of Linux processes and would like to alert on the following logic - the idea is to have similar but different alerts (different processes) set up for 4 separate servers:
Node IP = 1.2.3.4 and
HrSwRunName equal mongod and
HrSwRunParameters like %mongodb.conf% and
HrSWRunStatus not equal Running or runnable
Currently I have custom table pollers created for each of these OIDs and have built a table view for each applicable node.
My problem is creating the alert needed. it seems is that these values all exist within the same table, but on different rows. My SQL is not very good and I am unable to construct a query to retrieve the desired results. The RowID appears to be the common between these results, so perhaps I need assistance with an SQL join...?
The attached sql query is as far as i have gotten, as you can see the results are all on different rows but i need to combine them somehow.
Can anyone help?
