7 Replies Latest reply: Dec 5, 2012 2:43 PM by RichardLetts RSS

Where do alert go Part 1 ?

deathunt

After the alert disapear from this page:

https://orion.rtss.qc.ca/Orion/NetPerfMon/Alerts.aspx

 

1)Where do they go ? Are they archive or deleted ?

 

 

2)In wich database table do alert are coming from ?

 
  • Re: Where do alert go ?
    Jan Pelousek

    Hi deathunt,

    after disappearing from this page (by acknowledging or run out from number of displayed alerts) the alerts are still present in AlertStatus table and can be viewed also via Advanced/Basic alert manager, where you are still able to view them, clear and acknowledge/unacknowledge.

    • Re: Where do alert go ?
      deathunt

      AlertStatus only contain ~10 alerts.

       

      After they are clean from AlertStatus, do they go into another table ?

       

      I ask because I have to make a SQL / report that show error for node, volume and application with more than those label (show on https://orion.rtss.qc.ca/Orion/NetPerfMon/Alerts.aspx): TIME OF ALERT, ALERT NAME, ALERT TYPE, NETWORK OBJECT, ACKNOWLEDGED BY, ACKNOWLEDGED TIME.

       

       

      Also, any way to join table AlertStatus and Nodes ? They have no common ID....

      • Re: Where do alert go ?
        bsciencefiction.tv

         

        Select *

         

        From AlertStatus inner join Nodes on AlertStatus.ObjectName = Nodes.Caption

         

      • Re: Where do alert go ?
        bsciencefiction.tv

        And this should work for interfaces

         

        Select *

         

        From AlertStatus inner join Interfaces on AlertStatus.ObjectName = Interfaces.FullName

         

      • Re: Where do alert go ?
        RichardLetts

        ActiveObject and ObjectType are what you should join on

        Somethng like this:

         

        Select Top 1000 *

        From AlertStatus A

          left outer join Nodes N

            on N.nodeid=A.ActiveObject and A.ObjectType='Node'

          left outer join Interfaces I

            on I.InterfaceID=A.ActiveObject and A.ObjectType='Interface'

          left outer join NPM_NV_WL_APS W

            on W.ID=A.ActiveObject and A.ObjectType='Wireless Access Point'

         

         

        (there maye be other tables that you need to join, for example if you have UDT alerts, IPAM alerts, SAM alerts, etc....)

        • Re: Where do alert go ?
          deathunt

          Do you think it weird that you join ActiveObject string with nodeID integer ???

          I understand than you can convert them integer to string or string to integer.  But there risk that it mitmatch data type.

          • Re: Where do alert go ?
            RichardLetts

            fx: shrug. you're right.

             

            Solarwinds seems to lack a metadata manager who blesses their database structure and names.

            Notice we have nodeid, interfaceid, but wireless access points are 'ID'. ObjectType has this longish string value, but in the pollers table we have 'N', and 'I'