Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

find dialed number mapping to call type

hello

iam tasked with finding what call types are mapped to what dialed numbers. our envionrnment have hundereds of numbers and i want a way to make this a much faster process. is there a sql query that can be run?

- aashish

1 ACCEPTED SOLUTION

Accepted Solutions
Silver

aashishYou can use the query

aashish

You can use the query below that will return the dialed number string, each peripheral created for said DN string, what call type is mapped to the DN, and what routing script the call type is scheduled to. 

SELECT DN.EnterpriseName AS Peripheral, CT.EnterpriseName AS CallType, MS.EnterpriseName AS ScriptName, DN.DialedNumberString AS DialedNumber
FROM Call_Type CT, Dialed_Number DN, Dialed_Number_Map DNM, Call_Type_Map CTM, Master_Script MS
WHERE MS.MasterScriptID IS NOT NULL
AND DNM.CallTypeID = CT.CallTypeID
AND DN.DialedNumberID = DNM.DialedNumberID
AND CT.CallTypeID = CTM.CallTypeID
AND CTM.MasterScriptID = MS.MasterScriptID
GROUP BY CT.EnterpriseName, DN.EnterpriseName, MS.EnterpriseName, DN.DialedNumberString
ORDER BY DN.EnterpriseName

2 REPLIES
Silver

aashishYou can use the query

aashish

You can use the query below that will return the dialed number string, each peripheral created for said DN string, what call type is mapped to the DN, and what routing script the call type is scheduled to. 

SELECT DN.EnterpriseName AS Peripheral, CT.EnterpriseName AS CallType, MS.EnterpriseName AS ScriptName, DN.DialedNumberString AS DialedNumber
FROM Call_Type CT, Dialed_Number DN, Dialed_Number_Map DNM, Call_Type_Map CTM, Master_Script MS
WHERE MS.MasterScriptID IS NOT NULL
AND DNM.CallTypeID = CT.CallTypeID
AND DN.DialedNumberID = DNM.DialedNumberID
AND CT.CallTypeID = CTM.CallTypeID
AND CTM.MasterScriptID = MS.MasterScriptID
GROUP BY CT.EnterpriseName, DN.EnterpriseName, MS.EnterpriseName, DN.DialedNumberString
ORDER BY DN.EnterpriseName

New Member

thanks you. this worked very

thanks you. this worked very well

- aashish

134
Views
5
Helpful
2
Replies
CreatePlease to create content