cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1637
Views
0
Helpful
4
Replies
jmn Beginner
Beginner

How to clear EndUser Extension Mobility Dynamics

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

Everyone's tags (4)
1 ACCEPTED SOLUTION

Accepted Solutions
Contributor

Re: How to clear EndUser Extension Mobility Dynamics

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.

extensionmobilitydynamic.PNG

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.

View solution in original post

4 REPLIES 4
Contributor

Re: How to clear EndUser Extension Mobility Dynamics

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 Beginner
Beginner

Re: How to clear EndUser Extension Mobility Dynamics

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

Highlighted
Contributor

Re: How to clear EndUser Extension Mobility Dynamics

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.

Untitled.png

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.

Contributor

Re: How to clear EndUser Extension Mobility Dynamics

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.

extensionmobilitydynamic.PNG

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.

View solution in original post

CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards
This widget could not be displayed.