1 Reply Latest reply on Feb 1, 2011 9:33 AM by lchance

    Historical Date for Added Nodes in Orion NPM...

      Hello,

       

      We are running Orion NPM for more than 3 years....and I would need to find out the historical date for adding the nodes in the DB for monitoring. Does the application retain such values?

       

      Thanks,

      Cosmin

        • Re: Historical Date for Added Nodes in Orion NPM...
          lchance

          I don't believe it does. Nor does it have the date for removing nodes.

          In my case I've created a daily 'Node Added' report which I email to myself daily. This is the best I've come up with for my needs. It uses the EVENT LOG schema:

           

          Select NodeName, IP_Address, Event_Time,  Cast(Message As nvarchar(250)) as Message, Event_Type_Name From ( SELECT Nodes.Caption AS NodeName,
          Nodes.IP_Address AS IP_Address,
          Events.EventTime AS Event_Time,
          Events.Message AS Message,
          Events_EventTypes.Name AS Event_Type_Name

          FROM
          Nodes INNER JOIN (Events INNER JOIN EventTypes Events_EventTypes ON (Events.EventType = Events_EventTypes.EventType)) ON (Nodes.NodeID = Events.NetworkNode)


          WHERE
          ( EventTime BETWEEN 40418.3989930556 AND 40419.4166666667 )
           AND 
          (
            (Events_EventTypes.Name = 'node added')
          )

           


          ) As r ORDER BY 3 DESC