4 Replies Latest reply on Dec 9, 2016 4:51 AM by Jan Pelousek

    SWQL Node Availability Query

    alphabits

      Hello, I am trying to generate a SWQL query to gather node availability so I can post this on an NPM page. I encountered some old Thwack posts where people were referencing a table named "Orion.ResponseTime". I'm not seeing this in database manager.

      I'm seeing ResponseTime_Statistics though, but this table doesn't have availability.  I'm at a remote office, and cannot use SWQL studio or direct SQL database access.

       

      I was going to use the ResponseTime_Statistics table and manually write the query to calculate availability for the last week, based on count divided by time, but this table only has three entries.

      I need the response time results table before the data is summarized into hourly.

       

      Can someone help me out here? NPM ver is 11.5.3