CUCM AXL - Listuser to return Self-Service User ID or Meeting Number

[hans.cremers]

Hi all,

Is it possible to retrieve the "Self-Service User ID" / Meeting Number per user via AXL?

The AXL function listuser, doesn't have it in it's return values.

The updateUser function, does have a function to set the "Self-Service User ID" : <selfService></selfService>..
So i'm a bit surprised that this is missing from the listuser.

Thanks in advance.

[hans.cremers · Accepted solution]

Found my own solution.

In the DB it is stored as "keypadenteredalternateidentifier" in the enduser table. So running a query and the information is there. I preferred to stay away from the executeSQLQuery, and use listuser.

Anyway here is the code, for who else was looking for a solution.

<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 userid, keypadenteredalternateidentifier from enduser
        </sql>
        </ns:executeSQLQuery>
    </soapenv:Body>
</soapenv:Envelope>

Hope that the "keypadenteredalternateidentifier" will be available via Listuser in a feature version. 

[Gub]

Many years later this solution saved me a great deal of time and effort. Thanks!