Device mobility information

[mmenozzi]

Hi Team

my customer has a CUCM version 9.1.2SU1

Our need is to get information from CUCM about the device mobility status of the phone device.

Device mobility feature allows a user to understand from a specific message on the phone if he is in "home" location or "roaming location" depending on the effective registration of the device. If the device will register with an IP address (subnet) that is the same as its own physical location (gathered from device mobility info) then this device will be in "home" location. If device will register with a different IP address it's known to be as in "roaming" location.

Said that, we would like to understand how to get this information through AXL API. In the past with CUCM 7.1.5 version we found an API which allowed to get the "roaming device pool" information. The API parameter was called "roamingdevicepoolname" (ELEMENT AXL:XIPPHONE) obtained via GetPhoneRes (probably).

I have been told that this API parameter is no more available in 9.1 release. The fact is that from the GET above this value is no more returned.

I would need some support on this topic.

thanks a lot

regards

Marco

[mmenozzi]

I would also add that today with 7.1 it works like that

AXL get -- > getPhone

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

   <soapenv:Header/>

   <soapenv:Body>

      <ns:getPhone sequence="?">

         <phoneName>IUSPNB2T</phoneName>

      </ns:getPhone>

   </soapenv:Body>

</soapenv:Envelope>

In the answer it's possible to see

..

<roamingDevicePoolName>21d1bc42-b629-e2a5-9e49-e27b28f29a14</roamingDevicePoolName>

...

Marco

[lucadaprile]

In axl 9.1 I didn't find a direct api, but

I find this process to get current devicepool_devicemobility configuration using query to DeviceMobilityDynamic table:

the result is bring up the different devicepool_devicemobility

1) query on DeviceMobilityDynamic table were fkdevice is phone uuid (lower case)
call:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/9.1">
   <soapenv:Header/>
   <soapenv:Body>
      <ns:executeSQLQuery sequence="?">
         <sql>select * from DeviceMobilityDynamic where fkdevice = '33e3aece-7a65-bd14-b973-a12ee3d99240'</sql>
      </ns:executeSQLQuery>
   </soapenv:Body>
</soapenv:Envelope>

response in device mobility status:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
   <soapenv:Body>
      <ns:executeSQLQueryResponse sequence="?" xmlns:ns="http://www.cisco.com/AXL/API/9.1">
         <return>
            <row>
               <pkid>7cf492ec-1e52-433a-884e-b4e87907136b</pkid>
               <fkdevicepool_devicemobility>2c459c7b-81a2-48cd-96a7-43541adf9358</fkdevicepool_devicemobility>
               <fkdevice>33e3aece-7a65-bd14-b973-a12ee3d99240</fkdevice>
               <datetimestamp>1399544612</datetimestamp>
               <versionstamp>1399544612-ce04fc6a-f5b6-48dd-bb49-720da67e0e82</versionstamp>
            </row>
         </return>
      </ns:executeSQLQueryResponse>
   </soapenv:Body>
</soapenv:Envelope>

response   in home  status
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
   <soapenv:Body>
      <ns:executeSQLQueryResponse sequence="?" xmlns:ns="http://www.cisco.com/AXL/API/9.1">
         <return>
            <row>
               <pkid>7cf492ec-1e52-433a-884e-b4e87907136b</pkid>
               <fkdevicepool_devicemobility>7b44c5ea-4e0f-44f6-9fc9-c510e7a3ebc7</fkdevicepool_devicemobility>
               <fkdevice>33e3aece-7a65-bd14-b973-a12ee3d99240</fkdevice>
               <datetimestamp>1399540706</datetimestamp>
               <versionstamp>1399540706-a76400c4-eb4c-4c7f-a5c2-f85fa862e32e</versionstamp>
            </row>
         </return>
      </ns:executeSQLQueryResponse>
   </soapenv:Body>
</soapenv:Envelope>

than you can use    axl api getDevicePool using   fkdevicepool_devicemobility as uuid

to get all information of the current

Luca

[mmenozzi]

Hi

so do you mean that starting from device mobility and table you are able to get the specific information for a specific Phone ?

It's however much more complex than current 7.1 implementation.

I would have expect that you would still be able to get roamingdevicepool information

Marco

[lucadaprile]

is more complex than 7.1,  I can't get  a one shot information, I have to use more than a single query and make compare routine to find roaming status: not so immediate and easy. I hope than someone can find somethig better.

ciao