Subscribe

Unified Manager 6.3 mySQL Query for Alerts

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

 

Re: Unified Manager 6.3 mySQL Query for Alerts

Hi Corey,

 

On a UM6.3 server, i see below DB tables related to alerts (in 'ocum' DB) which lists the alert attributes.

They are not available in the ocum_view DB though.

 

root@oncommand-28:~# mysql -e "show tables from ocum" | grep -i alert
alert
alert_emailaddressrecipients
alert_emailadminrecipient
alert_eventseverities
alerteventtypevalues
alertresourceobjects

 

Hope this helps.

 

Re: Unified Manager 6.3 mySQL Query for Alerts

Thanks Kirana,

 

The issue I have run into is that the account I provisioned doesn't have access to the ocum database.   (A DB User account with the Integration Schema) 

 

Is there a procedure to create an account that has access to the ocum database?  

 

Note: I am running the appliance version of OCUM.