0 Replies Latest reply on Jan 13, 2010 10:14 AM by tylerg

    Days since last outage (uptime report excluding patches, planned downtime)

      I am attempting to create a report that will show the amount of days passed since our last unplanned downtime for certain servers.  I originally thought I would use the "LastBoot" field and do a DateDiff on it to show the amount of days since the last reboot like:

      SELECT NodeID, caption, DATEDIFF (day, LastBoot, getdate()) AS Days_Since_Last_Outage
      FROM Nodes
      WHERE caption = 'server'
      OR caption = 'server2'
      OR caption = 'server3'
      ORDER by caption

      Unfortunately this will not serve our purposes, as this would update every time we did monthly patches on our servers or rebooted for planned maintenance.  Am I correct in assuming that even if I 'unmanaged' the servers before rebooting them, they would still update their "LastBoot" and screw up the report as soon as I managed them again?  NPM doesn't have any option for scheduled maintenance windows currently, right?  I can't think of any way to do this in any sort of semi-automated fashion, anyone have any ideas?  The only thing I can come up with is creating a custom property and updating it manually with the date and time whenever unscheduled downtime occurs.  Does NPM save the dates / times of when a server is down for more than x minutes somewhere?

      Thanks!