Creating custom table that shows component availability for all components

Is it possible to show the availability of all components in a single table?

I am creating a dashboard/report and I'm always getting timed out showing the availability.

Filtering it by a single componentID, shows the availability from the Orion.APM.ComponentStatus.

Find more posts tagged with

swql query

sam

how many components are in your environment?

How are you calculating the availability?

What is the setup of the Solarwinds SQL Database?

Keep in mind that a report/ dashboard is a SQL query in the backend. It might be coded inefficiently, so it hits the timeout mark before completion.

I'm trying to display about a thousand components.

I calculated the availability by aggregating the PercentAvailability on Orion.APM.ComponentStatus by date.

Hmm not sure about the SQL database, what do you mean?