CUCM - ILS Configuration - How to change "advertised Route String" using AXL ?

[fabien.bonic]

Hi all,

I want to change the "Advertised Route String" and "Exchange Global Dial Plan Replication Data with Remote Clusters" in ILS Configuration using an AXL request. The updateIlsConfig does not have these fields. So how to change them using an AXL request?

In the updateIlsConfig request, what are the corresponding GUI field for "activateIls" "registrationServer", "activatedServers" and "deactivatedServers"?

Another question: how can I "read" the fields values ? The getIlsConfig request does not have the fields such as "use TLS Certificates", "Synchronize Cluster Every"...

Thanks,

Fabien

[dhook · Accepted solution]

Hi,

It took me a while but I found the ILS Configuration in the table "featureconfig".

The "Advertised Route String" corresponds to "RoutingString". "Exchange Global..." corresponds to "IsURIEnabled".

The "Synchronize Cluster Every"... corresponds "PingInterval" etc.

A query for select * from featureconfig where tkfeatureconfig = 6 gives

      <ns:executeSQLQueryResponse xmlns:ns="http://www.cisco.com/AXL/API/10.5">
        <return>
            <row>
              <keyname>RegistrationServer</keyname>
              <value/>
            </row>
            <row>
              <keyname>IsHubCluster</keyname>
              <value>T</value>
            </row>
            <row>
              <keyname>PingInterval</keyname>
              <value>600</value>
            </row>
            <row>
              <keyname>IsURIEnabled</keyname>
              <value>T</value>
            </row>
            <row>
              <keyname>RoutingString</keyname>
              <value>myRoutingString</value>
            </row>
            <row>
              <keyname>ILSState</keyname>
              <value>0</value>
            </row>
            <row>
              <keyname>ReplicationPassword</keyname>
              <value/>
            </row>
            <row>
              <keyname>HubPeerId</keyname>
              <value/>
            </row>
            <row>
              <keyname>UseTLS</keyname>
              <value>T</value>
            </row>
            <row>
              <keyname>RegistrationStartTime</keyname>
              <value/>
            </row>
        </return>
      </ns:executeSQLQueryResponse>

If not AXL request is available you could always (with caution) use executeSQLUpdate.

For 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="?">
         <sql>update featureconfig set value = "myRoutingString" where keyname = "RoutingString" and tkfeatureconfig = 6</sql>
      </ns:executeSQLUpdate>
   </soapenv:Body>
</soapenv:Envelope>

[fabien.bonic]

Thank you for the answer !

[fabien.bonic]

Hi,

Just another question: where is stored the "role" value? It seems not be in featureconfig table.

Thanks,

Fabien

[Fred Nielsen (ePlus)]

Old post so I assume you've sorted this by now, but the "value" column in the featureconfig table reflects the stored parameter value - with one exception, for some things (like "Advertised Route String" for example) that have not yet been changed from their default value, this column will indicate a null value.