Change Hlog setting based on CFA on DN

Mikael Hansson — Wed, 19 Apr 2017 08:33:47 GMT

I need to do a change of the Hlog (devicehlogdynamic) on all devices with a specific DN based on the CFA-status of that DN through AXL.

For example where DN=62990 and cfadestination is not empty or cfavoicemailenabled is true.

I know i have to do this in several steps:

1. get information if the DN is forwarded and which devices that DN belongs to.

2. update the Hlog on those devices

3. reset devices (doDeviceReset; isHardReset=false)

(if more than one device then do step 2 and 3 for each device)

Have anyone done this previously and have some code that you can share ?

Any help is appreciated. Even small contribution or examples on similar code

Regards

Mikael Hansson

Re: Change Hlog setting based on CFA on DN

npetrele — Wed, 03 May 2017 15:05:41 GMT

Here's a way to do step 1 with executeSQLQuery:

select device.name from device,numplan,devicenumplanmap,callforwarddynamic

where numplan.dnorpattern = "<the dn>" and

callforwarddynamic.cfadestination is not null and

callforwarddynamic.cfavoicemailenabled = "t" and

devicenumplanmap.fknumplan=numplan.pkid and

callforwarddynamic.fknumplan=numplan.pkid and

devicenumplanmap.fkdevice=device.pkid

Unless I'm misunderstanding your goals, the rest should be pretty straightforward, I think.

Some people prefer:

where numplan.dnorpattern like "<the dn>" and