So I am building a dashboard that runs queries against a couple sources. This includes DFM 5.x and UM 6.3.
The table/view I'm working on right now is one that gets the existing alerts that have been sent out to our oncall analysts. The view would give them a single place to go, in order to click for more details on an alert that can't be given in a single text message.
I have been able to generate the query using DFM's 5.x sybase database views, but not UM 6.3.
My current method of integration with UM 6.3 is through mySQL. In the database, I'm unable to find any tables/views on alerts. I see the events, but not the alert configurations that would allow me to correlate what events we are alerting on.
Any assistance would be great. If there is another method, I would love to hear it.
FYI - For those that want the query I used for DFM 5.x
select eventView.eventId ,eventView.eventName ,eventView.eventSourceName ,eventView.eventSeverity ,eventView.eventAckedBy from eventView left join groupMemberView on groupMemberView.objId = eventView.eventSourceObjId left join groupCacheView on eventView.eventSourceObjId = groupCacheView.objId left join alarmView on groupCacheView.groupId = alarmView.alarmGroupId and alarmView.alarmEventSeverity = eventView.eventSeverity where alarmView.alarmEmailAddrs = 'EMAILADDRESSHERE' AND eventView.eventIsCurrent = 'Yes' order by eventTimestamp desc