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