2 Replies Latest reply on Mar 3, 2011 6:56 AM by kluap

    Date node added

    MrSampsonite

      It would be very helpful to have a field for each node, interface, and volume for when it was first monitored/discovered. Currently we are using the script below, but it takes a load on the database across all our nodes availability data and once we get past the stats collection it will be out of date.

       

      Select n.caption as 'Node Name' , Min(datetime) as 'Date Added'
      from responsetime r join nodes n on n.nodeid = r.nodeid
      Group by n.caption
      order by n.caption