UCM 7.1.2 Query

[Live2 Bicycle]

I am looking for a query that will tell me all DNs that have the below fields with an number in the Destination Field

Forward Busy Internal

Forward Busy External

Forward No Answer Internal

Forward No Answer External

Forward No Coverage Internal

Forward No Coverage External

Forward on CTI Failure

Forward Unregistered Internal

Forward Unregistered External

Does anyone have something like this?  THis is for UCM 7.1.2.

[Joseph Martini]

Here's a query to cover some of those:

run sql select dnorpattern, cfbintdestination, cfbdestination, cfnadestination, cfnaintdestination, cfurdestination,  cfurintdestination from numplan where cfbintdestination like '%_' or cfbdestination like '%_' or cfnadestination like '%_' or cfnaintdestination like '%_' or cfurintdestination like '%_' or cfurdestination like '%_'

The data dictionary can be found on cisco.com which has the database schema to find out what else to query (http://www.cisco.com/en/US/docs/voice.../datadict/8.../datadictionary_801.pdf)