sql query for all RN_QOS_DATA_*** tables

[Brian Rudden]

sorry if this is a basic question, but my sql writing experience is limited.

 

I'd like to use a sql query to display/export cdm Disk Usage % metrics from the NMS database.

 

I see that there are multiple RN_QOS_DATA tables (RN_QOS_DATA_001, RN_QOS_DATA_002, etc...) that contain the data I'm looking for, but I'm not sure of the syntax of the sql to query all of the relevant tables.  I tried RN_QOS_DATA_*, but it didn't like the wildcard.

 

If anyone can give the proper syntax for this, I'd appreciate it.

[Anon Anon]

If you are looking for only one type of data, you should only need to query one RN_QOS_DATA_* table. Each of the data tables contains all of the data for a specific QoS type, which is a row in the S_QOS_DEFINITION table. That table should tell you which data table holds the data for each type. Disk usage percentage should be QOS_DISK_USAGE_PERC.

 

Having to query only one table for the data should simplify things a bit, but you will probably have to include a lookup to S_QOS_DATA to find out the server and filesystem to which each value in the data table refers. I can't easily piece together SQL to do that, but hopefully someone else here can help with that part.

[Brian Rudden]

thanks.  I must have run a bad query earlier against S_QOS_DATA (maybe i used "where probe = 'cdm'" instead of "where qos = 'blahblah'"). 

 

I re-ran the query and all of the data I'm looking for is in RN_QOS_DATA_002, so this should be a non-issue.

 

thanks for your help!

[RobPol]

You can also use the qos views script:

 

http://forum.nimsoft.com/t5/Unified-Monitoring-Development/qos-views-sql-script/m-p/16613

 

To build views that make QoS access much simpler