Cisco ISE 2.4 - RA VPN report with calling public IP address or REST API method

[giovanni.augusto]

Hi Everyone,

I am looking for a method to do either one of the following

1) Create a report in ISE RADIUS accounting that can list also the calling public IP address of Remote Access VPN users 

2) Extract a list of session data information for a specific NAS IP (or all...but too much data I think) in a specific time window.

for #2 I would then extract the ip:source-ip=x.x.x.x by parsing the resulting XML, I can actually do that for the latest authentication session for a NAS by using this method 

https://<ISE-node>/admin/API/mnt/Session/IPAddress/<NAS-IP>

But I didn't find yet how to extract a list instead of a single entry

@thomas  Do you know which API call would suit this scenario?

Thanks!

[giovanni.augusto]

EDIT:
In the end I am writing a python script to extract the list, just I am having some problems on this API call :

https://<ISE-NODE>/admin/API/mnt/AuthStatus/MACAddress/<MAC-ADDRESS>/110/100/All

I always get the following error :

<?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>SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in RESTAuthSearchMap.xml.  
--- The error occurred while applying a parameter map.  
--- Check the RESTAuthSearchMap.getFullAuthStatus-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLSyntaxErrorException: ORA-00904: "OTHER_ATTR_STRING": invalid identifier
</internal-error-info>
    <requested-operation>Get By Type</requested-operation>
    <resource-id>N/A</resource-id>
    <resource-name>N/A</resource-name>
    <resource-type>FullRESTAuthStatusOutputList</resource-type>
    <status>SERVER_ERROR</status>
</mnt-rest-result>