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

    Historical Date for Added Nodes in Orion NPM...



      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?




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

          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

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

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


          ) As r ORDER BY 3 DESC