topic Re: AXL how to get the AppUser id with device number in Management

AXL how to get the AppUser id with device number

eran.finish — Wed, 06 Oct 2021 12:08:15 GMT

Hello,

For jabber AXL API, how do I get the App User Id by device number or userName or some indicator?

Re: AXL how to get the AppUser id with device number

npetrele — Wed, 06 Oct 2021 13:24:02 GMT

Could you rephrase that or provide some more details? I don't understand the question.

Re: AXL how to get the AppUser id with device number

eran.finish — Wed, 06 Oct 2021 13:31:24 GMT

For every app user we have a list of associated Devices.

I need away to know what is The appUser that is associated with a certain device number.

Re: AXL how to get the AppUser id with device number

npetrele — Wed, 06 Oct 2021 14:10:20 GMT

A device can be controlled by more than one app user. There's not a one-to-one relationship between a device and an app user.

Re: AXL how to get the AppUser id with device number

dstaudt — Wed, 06 Oct 2021 15:54:11 GMT

npetrele is correct in that the below request may return more than one row of matches, but in case it's helpful, you can use something like this <executeSqlQuery> request:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/14.0">
   <soapenv:Header/>
   <soapenv:Body>
      <ns:executeSQLQuery sequence="1">
         <sql>select applicationuser.name,applicationuser.pkid
              from device,applicationuser,applicationuserdevicemap 
              where applicationuserdevicemap.fkapplicationuser = applicationuser.pkid
              and applicationuserdevicemap.fkdevice = device.pkid
              and device.name = "CSFDSTAUDT"</sql>
      </ns:executeSQLQuery>
   </soapenv:Body>
</soapenv:Envelope>

Response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
   <soapenv:Body>
      <ns:executeSQLQueryResponse xmlns:ns="http://www.cisco.com/AXL/API/14.0">
         <return>
            <row>
               <name>testAppUser</name>
               <pkid>0085d951-9f27-a128-e2f7-378783caffc5</pkid>
            </row>
         </return>
      </ns:executeSQLQueryResponse>
   </soapenv:Body>
</soapenv:Envelope>

Re: AXL how to get the AppUser id with device number

npetrele — Thu, 07 Oct 2021 14:49:38 GMT

For what it's worth, here's a sample when the device is controlled by more than one app user:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/12.5">
   <soapenv:Header/>
   <soapenv:Body>
      <ns:executeSQLQuery>
         <sql>select applicationuser.name,applicationuser.pkid
              from device,applicationuser,applicationuserdevicemap 
              where applicationuserdevicemap.fkapplicationuser = applicationuser.pkid
              and applicationuserdevicemap.fkdevice = device.pkid
              and device.name = "SEP001EF727852D"</sql>
      </ns:executeSQLQuery>
   </soapenv:Body>
</soapenv:Envelope>

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
   <soapenv:Body>
      <ns:executeSQLQueryResponse xmlns:ns="http://www.cisco.com/AXL/API/12.5">
         <return>
            <row>
               <name>norbert</name>
               <pkid>47f7c497-1e96-3724-f034-6fb56204cb0a</pkid>
            </row>
            <row>
               <name>daggett</name>
               <pkid>63e82413-5626-6a33-40ae-7a91a45635d9</pkid>
            </row>
         </return>
      </ns:executeSQLQueryResponse>
   </soapenv:Body>
</soapenv:Envelope>

You would need some other criteria to determine which app user you were looking for.

Re: AXL how to get the AppUser id with device number

eran.finish — Sun, 10 Oct 2021 06:19:21 GMT

Thank You all For The Fast reply