sql query for all RN_QOS_DATA_*** tables

Discussion created by brudden1 on Jan 17, 2013
Latest reply on Jan 17, 2013 by RobPol

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.