cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

Easiest Way to Generate SWQL Queries for Dashboards

Hi,

I'm currently creating my own modern dashboard and was wondering what methods people use to find out which tables to use for certain queries.

For example I want to generate a query for Avg Disk Queue length but am not sure where the data is stored in the database. I haven't managed to find it via the graphical query builder either. Do people have certain methods they use to find the correct query or are you just hunting around?

Thanks,

Mark

0 Kudos
1 Reply

Have you installed SWQL studio anywhere?  Initially i would just hunt around in there, but a couple years ago they added a search to SWQL studio, so a few tries of "it's probably called something like this" would get me there.  

mesverrum_0-1607966884076.png

 

 

Looks like it would be orion.volumes if you are just interested in the right now numbers, or probably Orion.volumeperformancehistory if you are looking for historical data

 

- Marc Netterfield, Github