cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Announcements
Choose one of the topics below to view our ISE Resources to help you on your journey with ISE

This community is for technical, feature, configuration and deployment questions.
For production deployment issues, please contact the TAC! We will not comment or assist with your TAC case in these forums.
Please see How to Ask the Community for Help for other best practices.

706
Views
0
Helpful
1
Replies
Highlighted

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

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!

 

1 REPLY 1
Highlighted

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>
Content for Community-Ad