Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Users might experience few discrepancies in Search results. We are working on this on our side. We apologize for the inconvenience it may have caused.
New Member

Route Pattern table in SQL

What table are the Route Patterns stored in?

1 ACCEPTED SOLUTION

Accepted Solutions
Silver

Re: Route Pattern table in SQL

It is in NumPlan table along with the Phone DNs.

3 REPLIES
Silver

Re: Route Pattern table in SQL

It is in NumPlan table along with the Phone DNs.

New Member

Re: Route Pattern table in SQL

Can I make a search by this field into SQL?

New Member

Re: Route Pattern table in SQL

Sure! It depends what you want to pull out.

For example, this gives me all my NANP Route Patterns.

SELECT *

FROM NumPlan

WHERE (DNOrPattern LIKE '9.%')

105
Views
0
Helpful
3
Replies
CreatePlease to create content