How can I find the availability statistics within SWQL Studio?

tallyrich

I specifically want those related to Node availability and Interface availability. Management wants something better than the existing availability widgets out of the box.

Management doesn't like the availability widgets that come out of the box and I find that I can build better tables with SWQL But, I cannot find the availability locations that I need. Maybe I'm missing the obvious, but I've looked quite a bit. I am rather new to SWQL and SQL in general.

stevenstadel

Can you outline what exactly you are looking for? Availability will always be a 100 or a 0 because at any given poll the interface or node is always either up or down, so you need to make the query an average calculation over time.

In SWQL studio you can find availability in Orion.ResponseTime table. Interface data is stored in its' own table as well.