5 Replies Latest reply on Jan 22, 2014 1:24 PM by njoylif

Alerting report

BXIV Oct 28, 2008 4:16 PM

I have a manager who is asking for a report from Orion to tell him when/if someone gets paged for alerts that are setup.

I see that in the AlertLog table I can get him all of that information, but I can't write the proper SQL statement to make the report for the manager. Has anyone else here had to produce a similar result?

Re: Alerting report

mark wiggans Oct 28, 2008 5:27 PM (in response to BXIV)

This one is sort of similar- Maybe you could tweak it to serve your needs...
Active Alerts for Advanced Alerts - replace "All triggered alerts" on summary
Like (0)

Actions
- Re: Alerting report
  
  BXIV Oct 31, 2008 10:43 AM (in response to mark wiggans)
  
  I looked at that and only see that it does current alerts, I need a history for the alerts.
  
  Like (0)
  
  Actions
  - Re: Alerting report
    
    BXIV Oct 31, 2008 10:44 AM (in response to BXIV)
    
    Currently I have this :
    Select AlertLog.MsgID as 'Incident ID',AlertLog.LogDateTime, AlertLog.ObjectID,AlertLog.ObjectName,AlertLog.Message
    From AlertLog,Nodes,Events
    WHERE AlertLog.ActionType != 'EMail' and AlertLog.ObjectType = 'Node' and AlertLog.ObjectID = Nodes.NodeID and AlertLog.MsgID like '%'
    order by AlertLog.LogDateTime
    
    Like (0)
    
    Actions
    - Re: Alerting report
      
      BXIV Oct 31, 2008 3:57 PM (in response to BXIV)
      
      Got it!
      Select distinct top 60 AlertLog.MsgID,AlertLog.LogDateTime, AlertLog.ObjectID,AlertLog.ObjectName,AlertLog.Message
      From AlertLog,Nodes
      WHERE AlertLog.ActionType = 'EMail' and AlertLog.ObjectType = 'Node' and AlertLog.ObjectID = Nodes.NodeID and AlertLog.MsgID like '%'
      
      order by AlertLog.LogDateTime DESC
      
      Change the 60 if you want more alert history to show up on the report.
      
      Like (0)
      
      Actions
      - Re: Alerting report
        
        njoylif Jan 22, 2014 1:24 PM (in response to BXIV)
        
        I'd like to take it a step further by getting a report that has the message in it...i.e. if it is a windows event log alert -> provide that message...
        anyone done this?
        
        Like (0)
        
        Actions

Go to original post