cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
816
Views
2
Helpful
1
Replies

Add a single device to AppUser's Associated Devices

mgowland
Level 1
Level 1

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

dstaudt
Cisco Employee
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

dstaudt
Cisco Employee
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>