SQL command for Activating a Directory Number in 4.1.3
I am running CM4.1.3SR7. I am looking for a way to activate a bunch of directory numbers in my CallManager that are already present but not active.
I was hoping for some kind of SQL command to apply directly to my database via SQL query analyzer.
I am in a situation where I need to use my CCM as a hub for CallForwarding calls to users mobile phones. I can create directory numbers via BAT when I creaty a dummy phone and deletes it afterwards. But BAT deactivates the directory number when deleting the phones (which is probably OK).
So I need a way to reactivate them again. And as I have a few thousands, I would prefere not to do it via the web GUI of 4.1.3.
Anybody who has done this before and knows the SQL command ?
Re: SQL command for Activating a Directory Number in 4.1.3
Thx for your post. I am able to insert a phone (with directory number) via BAT. If I then delete the Device, the directory number remains in the database, but is no longer active. If I then lookup the directory number via Route Plan Report, I can find the number and manually activete it. Then the Directory Number is working again and I can set a Callfoward All to a mobile phone.
It's just that I find it very irritating that I have to go through the manual web GUI interface to re-activate the Directory number after deleting the associated device.
That's why I'm looking for a SQL command to do this job for me rather than going through 5000 directory numbers via the web GUI.
I'm not able to access my old voice mail messages all of a sudden. The recording says something like 'the message is currently not available'. This has never happened before in all the years I have been using this system. I have t...
If you have 2 ISR routers, one acting as Failover, do we need to have both the same number of SRST licenses on the 2 routers?
No. You will only need the SRST licenses on the primary router. Because this feature...