03-22-2016 02:34 AM - edited 03-01-2019 02:53 AM
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
Solved! Go to Solution.
03-30-2016 10:18 AM
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.
03-26-2016 11:43 PM
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?
03-30-2016 12:28 AM
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
03-30-2016 10:02 AM
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.
03-30-2016 10:18 AM
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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide