7 Replies Latest reply on Aug 27, 2015 12:33 AM by HolyGuacamole

Alert Acknowledgement Report to Include NodeName

l.mendoza Aug 25, 2015 9:21 PM

Hello.

I am trying to customize a report for the alerts triggered and acknowledged (must include the node that is related to the alert).

Attached herewith is the SQL script I have created by joining the two tables. The script is executable already.

However, I am not getting any data (please refer to the attached file).

Please let me know if I missed anything in the script.

Thank you very much.

Kind Regards,

Leny

janene16, baka matulungan mo ako B1..hahaha . tenchu!

Alert Acknowledgement Report.png 17.2 KB

Re: Alert Acknowledgement Report to Include NodeName

HolyGuacamole Aug 26, 2015 3:15 AM (in response to l.mendoza)

which version of NPM?
Like Show 0 Likes(0)

Actions
- Re: Alert Acknowledgement Report to Include NodeName
  
  l.mendoza Aug 26, 2015 6:57 PM (in response to HolyGuacamole)
  
  NPM 11.5. Thanks..
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Alert Acknowledgement Report to Include NodeName
    
    HolyGuacamole Aug 26, 2015 8:49 PM (in response to l.mendoza)
    
    The legacy reporter maybe referencing the legacy alerts table. Try the web reporter
    
    Like Show 0 Likes(0)
    
    Actions
    - Re: Alert Acknowledgement Report to Include NodeName
      
      l.mendoza Aug 26, 2015 10:03 PM (in response to HolyGuacamole)
      
      Its not possible in the web reporter. Some of the columns needed such as "acknowledgedby" etc are not available that is why we are trying to customize a report via SQL SQL.
      
      Like Show 0 Likes(0)
      
      Actions
      - Re: Alert Acknowledgement Report to Include NodeName
        
        HolyGuacamole Aug 26, 2015 10:39 PM (in response to l.mendoza)
        
        You are looking at Events in the web reporter. You should be looking at Alerts.
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: Alert Acknowledgement Report to Include NodeName
        
        l.mendoza Aug 27, 2015 12:30 AM (in response to HolyGuacamole)
        
        There's no alerts from the available columns. fyi
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: Alert Acknowledgement Report to Include NodeName
        
        HolyGuacamole Aug 27, 2015 12:33 AM (in response to l.mendoza)
        
        Available columns is dependent on the datasource you have picked in step 1. Change that to Alerts.
        
        Like Show 0 Likes(0)
        
        Actions

Go to original post