We need to change 1000 existing extensions in CM to new range.
Since there are lot of 2/3 lines and shared lines phones. I need some kind of tool/App so I can pull existing numbers from CM SQL database to Excel and replace it.
Even if I can't replace the numbers at least if I can pull the existing database to Excel that would be great.
I was checking on this forum more engr's are using this SOAP/AXL for similar requirement.
I have no experience on this SOAP/AXL so I need our experts advice how to do this.
Your help is much appreciated.
Here's the query that has Forward All, Forward Busy and Forward No Answer included:
SELECT d.Name, d.Description, np.DNOrPattern, np.CFADestination, np.CFBDestination, np.CFNADestination, dnp.NumPlanIndex
FROM NumPlan np INNER JOIN
DeviceNumPlanMap dnp ON np.pkid = dnp.fkNumPlan INNER JOIN
Device d ON dnp.fkDevice = d.pkid
WHERE (dnp.fkDevice IN
FROM Device d, DeviceNumPlanMap dnp, NumPlan np
WHERE np.pkid = fkNumPlan AND d.pkid = dnp.fkDevice))