We are trying to monitor specific Sybase processes on AIX hosts - Where each host has a variable amount of processes ex:
/opt/sybase/bin/dataserver -sprod ,
/opt/sybase/bin/dataserver -sprod2 ,
/opt/sybase/bin/backupserver -sprod3
We can't use OS Service Monitoring as these are not systemd services.
We need to monitor when any of these drop and alert which process has stopped.
DQL I tried was:
fetch dt.entity.host
| fieldsAdd osServices, state
| expand osServices
| parse osServices, """LD 'dt.osservice.name=' LD:"OS Service" ',' LD 'dt.osservice.display_name=' LD:DisplayName ',' LD 'dt.osservice.status=' LD:Status ',' """
| fields `Host Name` = entity.name, id, `OS Service`, DisplayName, Status
| filter contains(`Host Name`, <hostname>)
This only reports back the group instance as dataserver or backupserver and not the specific processes under the group.
We tried using "Process Availability" under "Processes and containers," but this only monitors the count of processes running, and if one dies, it does not give which process it was that is no longer running, just that the count is lower than what you specify.
Could we use "Davis Anomaly Detection" to leverage DQL metrics for alerting in this use case?
