Update end user paramters in LDAP sync users

pyeddanapa001 · ‎07-12-2016

Hi

I'm working with development team to prepare AXL script to update LDAP synced end user properties.

"Home Cluster" and "Controlled device" parameters need to be updated using .net AXL APIs.

I see CM 9.1 schema lists "adduser" method, can't find "updateuser" method. Since users are LDAP synced and all of them are existing users, how which method in this case can update certain properties like "Home Cluster" and "Controlled device".

TDoan · ‎07-13-2016

Hi,

There are addUser and updateUser AXL APIs in CM 9.1.

In element updateUser, it has a property homeCluster.

And Controlled Device you can try to use tiControlledDeviceProfiles

I hope this would help you.

Regards

Thuy Doan

pyeddanapa001 · ‎07-18-2016

Our development team put down AXL methods to update end user properties "Home Cluster" and "Controlled Devices".

When they execute those AXL APIs, response doesn't show any errors. But when I checked on Call Manager, "Home Cluster" parameter updated but not associated devices. Controlled Device field is empty.

Attaching a file containing AXL SOAP request and Call Manager AXL debug.

Any thoughts?

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
<updateUser xmlns="http://www.cisco.com/AXL/API/9.0"><userid xmlns="">jtest015</userid>
<firstName xmlns="">Cisco</firstName><lastName xmlns="">Test</lastName>
<telephoneNumber xmlns="">1236541234</telephoneNumber>
<department xmlns="">JBRW</department>
<userLocale xsi:nil="true" xmlns="" />
<associatedDevices xmlns="">
<device>jbw6CNCM9KDQ7</device>
</associatedDevices>
<enableCti xmlns="">true</enableCti>
<digestCredentials xsi:nil="true" xmlns="" />
<subscribeCallingSearchSpaceName xmlns="" />
<enableMobility xmlns="">false</enableMobility>
<enableMobileVoiceAccess xmlns="">false</enableMobileVoiceAccess>
<maxDeskPickupWaitTime xmlns="">10000</maxDeskPickupWaitTime>
<remoteDestinationLimit xmlns="">4</remoteDestinationLimit>
<primaryDevice xmlns="" />
<ctiControlledDeviceProfiles xmlns="" />
<patternPrecedence xmlns="">Default</patternPrecedence>
<mlppPassword xsi:nil="true" xmlns="" />
<homeCluster xmlns="">false</homeCluster>
<imAndPresenceEnable xmlns="">false</imAndPresenceEnable>
<serviceProfile uuid="{3D66AFD3-3A2A-E7BA-3145-BF20343CA812}" xmlns="">Test Service Profile</serviceProfile>
<directoryUri xmlns="" />
</updateUser></soap:Body>
</soap:Envelope>

Call Manager Debug:
2016-07-18 09:16:45,818 DEBUG [http-bio-443-exec-80] servletRouters.AXLFilter - DBLCNQueue Count: 0
2016-07-18 09:16:45,818 DEBUG [http-bio-443-exec-80] servletRouters.AXLFilter - Successfully set the value of counter: 4 value: 0
2016-07-18 09:16:45,818 DEBUG [http-bio-443-exec-80] servletRouters.AXLFilter - --------------- Version matched ----------------
2016-07-18 09:16:45,819 INFO [http-bio-443-exec-80] servletRouters.AXLAlpha - SOAPAction : "CUCM:DB ver=9.0 updateUser"
2016-07-18 09:16:45,843 DEBUG [http-bio-443-exec-80] servletRouters.AXLAlpha - addToCache("cipc_test")
2016-07-18 09:16:45,843 INFO [http-bio-443-exec-80] servletRouters.AXLAlpha - Going to axis--->
2016-07-18 09:16:45,848 DEBUG [http-bio-443-exec-80] axlapiservice.Handler - getPkid Query is :select pkid from EndUser where my_lower(userid ) =my_lower('jtest015' )
2016-07-18 09:16:45,867 DEBUG [http-bio-443-exec-80] axlapiservice.UpdateUserHandler - strpatternprecedenceDefault
2016-07-18 09:16:45,869 DEBUG [http-bio-443-exec-80] axlapiservice.UpdateUserHandler - select precedencelevel from TypePatternPrecedence where name = 'Default'
2016-07-18 09:16:45,870 DEBUG [http-bio-443-exec-80] axlapiservice.Handler - fkCallingSearchspace_restrict IS Being assigned a null value in addfkdataaxis
2016-07-18 09:16:45,871 DEBUG [http-bio-443-exec-80] axlapiservice.Handler - delete from EndUserLicense where fkEndUser='32e05b12-9980-0011-d206-29424266b96f'
2016-07-18 09:16:45,876 DEBUG [http-bio-443-exec-80] axlapiservice.Handler - getPkid Query is :select pkid from UCServiceProfile where my_lower(name ) =my_lower('Test Service Profile' )
2016-07-18 09:16:45,882 DEBUG [http-bio-443-exec-80] axlapiservice.Handler - update EndUser set fkCallingSearchspace_restrict=null,fkUCServiceProfile='3d66afd3-3a2a-e7ba-3145-bf20343ca812',LastName='Test',EnableMobility='f',IsLocalUser='f',EnableMobileVoice='f',AllowCTIControlFlag='t',DirectoryURI='',RemoteDestinationLimit='4',TelephoneNumber='1236541234',FirstName='Cisco',MaxDeskPickupWaitTime='10000',Department='JBRW' where pkid='32e05b12-9980-0011-d206-29424266b96f'
2016-07-18 09:16:45,948 DEBUG [http-bio-443-exec-80] axlapiservice.UpdateUserHandler - select pkid as mlpppkid from EndUserMLPPAuthentication where fkEndUser = '32e05b12-9980-0011-d206-29424266b96f'
2016-07-18 09:16:45,954 DEBUG [http-bio-443-exec-80] axlapiservice.UpdateUserHandler - select pkid from device where my_lower(name) = my_lower('jbw6CNCM9KDQ7')
2016-07-18 09:16:45,959 DEBUG [http-bio-443-exec-80] axlapiservice.UpdateUserHandler - select fkDevice from EndUserDeviceMap where fkEndUser = '32e05b12-9980-0011-d206-29424266b96f' and tkUserAssociation = '7'
2016-07-18 09:16:45,963 DEBUG [http-bio-443-exec-80] axlapiservice.Handler - delete from EnduserDeviceMap where fkEndUser='32e05b12-9980-0011-d206-29424266b96f' and tkUserAssociation='6'
2016-07-18 09:16:45,988 DEBUG [http-bio-443-exec-80] axlapiservice.Handler - delete from EndUserLicense where fkEndUser='32e05b12-9980-0011-d206-29424266b96f'
2016-07-18 09:16:45,994 DEBUG [http-bio-443-exec-80] axlapiservice.UpdateUserHandler - UpdateUser completed
2016-07-18 09:16:45,995 INFO [http-bio-443-exec-80] servletRouters.AXLAlpha - Request processed by AXIS
2016-07-18 09:16:45,995 DEBUG [http-bio-443-exec-80] servletRouters.AXLFilter - ---------------AXLFiler > responseString ---------------- : <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><ns:updateUserResponse xmlns:ns="http://www.cisco.com/AXL/API/8.0"><return>{32E05B12-9980-0011-D206-29424266B96F}</return></ns:updateUserResponse></soapenv:Body></soapenv:Envelope>
2016-07-18 09:16:45,996 INFO [http-bio-443-exec-80] servletRouters.AXLFilter - <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><ns:updateUserResponse xmlns:ns="http://www.cisco.com/AXL/API/9.0"><return>{32E05B12-9980-0011-D206-29424266B96F}</return></ns:updateUserResponse></soapenv:Body></soapenv:Envelope>
2016-07-18 09:16:45,996 INFO [http-bio-443-exec-80] servletRouters.AXLFilter - Request 1468578876702 was process in 192ms
2016-07-18 09:16:46,096 INFO [http-bio-443-exec-80] servletRouters.AXLFilter - Received request 1468578876703 from cipc_test at IP 10.16.177.231
2016-07-18 09:16:46,097 DEBUG [http-bio-443-exec-80] servletRouters.RequestWrapper - : changeNamespace - nameSpac_9_0
2016-07-18 09:16:46,097 DEBUG [http-bio-443-exec-80] servletRouters.RequestWrapper - : setNameSpaceFlag - New nameSpace:9.0
2016-07-18 09:16:46,097 INFO [http-bio-443-exec-80] servletRouters.AXLFilter - AXL REQUEST :

Sascha Monteiro · ‎08-24-2016

you could try to run this on the cucm console to see if the query finds the pkid

run sql select pkid from device where my_lower(name) = my_lower('jbw6CNCM9KDQ7')