I just found out that data in Orion.ResponseTime has 2 minutes interval per records and it only shows up to 5 days worth of data.
Is there any other table where I could get historical data? I am looking into getting the average availability per node of Last Month.
This report can be achieved through the report builder UI. Historical data is rolled up from detailed to hourly to daily statistics during database maintenance and will depend on your configured retetention settings under /Orion/Admin/PollingSettings.aspx
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.