5 Replies Latest reply on May 14, 2018 11:33 AM by amrita1690

Report on TOP XX Alerted Nodes

amrita1690 May 11, 2018 11:21 AM

Hi All,

I am trying to get a report where I could list say top 10 nodes which had the maximum alerts in last one month. So, it should list out NodeA had 20 alerts, NodeB had 19 alerts and so on....

I can do it manually in various ways but it would be nice to have it automated for problem management every month/week.

Any help here would be appreciated.

Many Thanks!

Re: Report on TOP XX Alerted Nodes

amrita1690 May 14, 2018 5:12 AM (in response to amrita1690)

Hi aLTeReGo,

Any suggestions here, please ?

Thanks!
Like (0)

Actions
- Re: Report on TOP XX Alerted Nodes
  
  aLTeReGo May 14, 2018 7:58 AM (in response to amrita1690)
  
  You mean something like these?
  
  Alert Analysis
  Repetitive Email Alerts (Noise) - MUST HAVE REPORT!!!
  
  Like (0)
  
  Actions
  - Re: Report on TOP XX Alerted Nodes
    
    amrita1690 May 14, 2018 11:33 AM (in response to aLTeReGo)
    
    Thanks aLTeReGo,
    
    This is not exactly I needed, but these helped add to the vision.
    
    For now, I rather need a report stating Node1 has 20 alerts, Node 2 has 30 alerts, Node 3 has 10 alerts, and so on.
    
    Like (0)
    
    Actions
Re: Report on TOP XX Alerted Nodes

David Smith May 14, 2018 8:09 AM (in response to amrita1690)

I'm not sure it will be that straightforward as the Alerts table doesn't store your alerts by NodeID, and not All alerts are directly related to a Node, so you would have to perform some sort of filter that excludes alerts that are not Node alerts, and then various joins to get the other data you need.

I'm sure it's possible, but not easy.
Like (0)

Actions
- Re: Report on TOP XX Alerted Nodes
  
  David Smith May 14, 2018 8:14 AM (in response to David Smith)
  
  I stand corrected - Although I would argue that there was a lot of work put into those reports but due to the awesomeness of this community we all get to benefit !
  
  Like (0)
  
  Actions

Go to original post