How to clear EndUser Extension Mobility Dynamics

[jmn]

Hi all

I want to make a program to clear EndUser Extension Mobility Dynamics table.

Is some one can help me to help me on the way.

Thanks

Regards

Jan Meeling

[lior look]

be much clearly.

the EM Table contain records of endusers that have login available with devices.

When you make logout to devices, the records with same device id are remove.

Would you like to make logout to enduser specific?

[jmn]

Hi Lior Louk,

Thanks for your quick response.

We UCCE with CUCMsome time it happends that we have a shared lines and we look on the system that the user is still logged on several devices when that  happends we have to reboot the CUCM.

I want to make a small program to clear the EM Dymatic table.

I want to know were o find the dynamic table.

Thanks

Regards,

Jan Meeling

[lior look]

Got it.

first of all it sounds like you have Intra-cluster Multiple Login Behavior available.

so go to service parameters -> Extension Mobility Service and be sure you have not allow the parameter.

then, to remove all records of EM Table:

1. so first you should create array object with all devices's names according to the fkdevice field of extensionmobilitydynamic table, see the following query:

select fkdevice from extensionmobilitydynamic

2. Take the fkdevice value and look for the device's name into device table, see the following query:

select name from device where pkid=[fkdevice value]

3. create loop and perform for each device's name call to logout API method, see my sample c# code:

     public void doEMPhoneLogout(string sDeviceName)

     {

            XFkType DevicePhoneName = new XFkType();

            DevicePhoneName.Value = sDeviceName;

            DoDeviceLogoutReq req = new DoDeviceLogoutReq();

            req.deviceName = DevicePhoneName;

            try

            {

                    DoDeviceLogoutRes res = axlobject.doDeviceLogout(req);

            }

            catch (Exception e)

            {

                MessageBox.Show(e.message);

            }

     }

that's it.

[lior look · Accepted solution]

by the way, you can not remove records from extensionmobilitydynamic table directly.

See the information about the table that shows under SQL dictionary of CUCM.

In addition, the devices do not have to be in register status before you perform them logout during the API method.

You should know that the method create a job in Extension Mobility Service and when the device will get register, it will logout also.