03-21-2017 12:07 AM - edited 03-15-2019 06:28 AM
Gents,
Which table does the dialed number gets stored in. I need to know how to find the dialled number rather than manually going through each dialed number list as this can be very time consuming as you can imagine.
Thanks
Solved! Go to Solution.
03-21-2017 03:14 AM
you can query Dailed_Number table from Logger database . There are two columns (EnterpriseName and DialedNumberstring) in this table which will give you complete list
select EnterpriseName,DialedNumberString from Dialed_Number
03-21-2017 07:40 AM
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
03-21-2017 12:24 AM
If you are looking from which Dial Number call came, then you can get it from Route_Call_Detail table (use DialedNumberID field ) and check that ID in Dialed_Number table.
03-21-2017 03:04 AM
Thanks Sasikumar,
I am not looking for the dialed number in the RCD table.
What I want is this, in configuration manager you have a list of dialed numbers by name. in my environment there are lots of them. To find the dialed number associated to each list you have to manually click on the list. Is there a way to run a query to find the dialed number configured without scrolling through each list
03-21-2017 03:14 AM
you can query Dailed_Number table from Logger database . There are two columns (EnterpriseName and DialedNumberstring) in this table which will give you complete list
select EnterpriseName,DialedNumberString from Dialed_Number
03-21-2017 05:05 AM
Thank you that was what I wanted.
03-21-2017 05:08 AM
Glad that helped.. Have a great day..
03-21-2017 07:40 AM
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
03-21-2017 10:57 AM
Omar,
This is brilliant, thank you
03-21-2017 11:09 AM
+5 Omar,
This is really cool. Very helpful in finding the mapping in case of huge no.of DN's and scripts.
04-26-2024 02:15 PM
This query is awesome! Is there a way to show only the numbers associated with the CallType ID? I don't need the script names and I am looking to have it not show repeats of the number...Hope this makes sense.
04-30-2024 06:42 AM
I think this is what you're looking for.
SELECT DISTINCT CT.CallTypeID AS CallTypeID, DN.DialedNumberString AS DialedNumber
FROM Call_Type CT
JOIN Dialed_Number_Map DNM ON DNM.CallTypeID = CT.CallTypeID
JOIN Dialed_Number DN ON DN.DialedNumberID = DNM.DialedNumberID
JOIN Call_Type_Map CTM ON CT.CallTypeID = CTM.CallTypeID
JOIN Master_Script MS ON CTM.MasterScriptID = MS.MasterScriptID
WHERE MS.MasterScriptID IS NOT NULL
ORDER BY DN.DialedNumberString;
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide