Get Endpoint details by IP address using Cisco ERS API

[Mo Pourmirza]

Hi, 

I am trying to get endpoint details based on the endpoint IP address using ISE 2.3 ERS API. I am able to get the endpoint details by passing the MAC address as below. I use Postman to send the get request.

https://ers-username:ers-password@isemnt.domain.com/admin/API/mnt/AuthStatus/MACAddress/E4:B3:18:10:25:CF/0/100/All

Response:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<authStatusOutputList>
<authStatusList key="E4:B3:18:10:25:CF">
<authStatusElements>
<passed xsi:type="xs:boolean" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">true</passed>
<failed xsi:type="xs:boolean" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">false</failed>
<user_name>E4:B3:18:10:25:CF</user_name>
<nas_ip_address>10.116.196.180</nas_ip_address>
<nas_port_type>Wireless - IEEE 802.11</nas_port_type>
<calling_station_id>E4:B3:18:10:25:CF</calling_station_id>
<identity_group>Test</identity_group>
<network_device_name>Test-WLC</network_device_name>
.

.

However, I can not use the endpoint IP address to get the same result. I have tried below but I get error code 500( internal server error).

https://ers-username:ers-password@isemnt.domain.com/admin/API/mnt/Session/EndPointIPAddress/10.213.193.133

Response :

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<mnt-rest-result>
<http-code>500</http-code>
<cpm-code>34110</cpm-code>
<description>Server has encountered error while processing the REST request</description>
<module-name>MnT</module-name>
<internal-error-info>Error in generating XML output. Error message = [TimesTen][TimesTen 11.2.2.7.4 ODBC Driver][TimesTen]TT0846: Data store connection invalid or not current -- file "dbAPI.c", lineno 7685, procedure "sb_connLatchAcquire"</internal-error-info>
<requested-operation>Get By Type</requested-operation>
<resource-id>N/A</resource-id>
<resource-name>N/A</resource-name>
<resource-type>RESTSDStatus</resource-type>
<status>SERVER_ERROR</status>
</mnt-rest-result>

[Surendra · Accepted solution]

The API you are using is correct. However, the problem seems to be on the session database on the ISE as per the response you see. Do you see the same response for any IP address of just a few? Either ways, please contact TAC to sort out any issues with the session database.

[Mo Pourmirza]

Hi  Surendra,

Many thanks for your reply!

I have tested the API for a few IP addresses and received the same response(500). I will raise a TAC to fix the session database.

Also, can you please advise if I can use the ERS API to get the endpoint details using the endpoint host name? If yes, can you please share an example of the API?

[Surendra]

ISE currently does not support pulling endpoint by hostname probably because not all of them would have it associated with them and also is not a significant attribute.