cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
357
Views
2
Helpful
1
Replies
Highlighted
Beginner

Add a single device to AppUser's Associated Devices

I need to use AXL to add a single device to an application users existing associated devices.  Im thinking to do this Ill have to use updateAppUser, specify associatedDevices, and include all the currently associated devices in addition to the extra single device I want to associate. Is that correct? Is there an easier way to add just a single device, without having to include all existing devices as well?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Cisco Employee

You are correct, as far as the standard AXL requests: use <updateAppUser> and specify the new (complete) set of associated devices.

Note, it is possible to modify the associations via <executeSqlUpdate> by modifying the CUCM database via direct SQL.  See the 'applicationuserdevicemap' table.  An example:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/10.5">

  <soapenv:Header/>

  <soapenv:Body>

      <ns:executeSQLUpdate sequence="1">

        <sql>insert into applicationuserdevicemap (pkid,fkapplicationuser,fkdevice,tkuserassociation) values (newid(),"ca121da0-683f-0886-1dd1-fe8abdcd149c","02bb0c13-376d-08e0-b6de-77362cedb79a",1)</sql>

      </ns:executeSQLUpdate>

  </soapenv:Body>

</soapenv:Envelope>

View solution in original post

1 REPLY 1
Highlighted
Cisco Employee

You are correct, as far as the standard AXL requests: use <updateAppUser> and specify the new (complete) set of associated devices.

Note, it is possible to modify the associations via <executeSqlUpdate> by modifying the CUCM database via direct SQL.  See the 'applicationuserdevicemap' table.  An example:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/10.5">

  <soapenv:Header/>

  <soapenv:Body>

      <ns:executeSQLUpdate sequence="1">

        <sql>insert into applicationuserdevicemap (pkid,fkapplicationuser,fkdevice,tkuserassociation) values (newid(),"ca121da0-683f-0886-1dd1-fe8abdcd149c","02bb0c13-376d-08e0-b6de-77362cedb79a",1)</sql>

      </ns:executeSQLUpdate>

  </soapenv:Body>

</soapenv:Envelope>

View solution in original post

Content for Community-Ad