ISE database oracle - how to access it for RO purpose

[Przemyslaw Konitz]

Hi,

I was wondering whether there is any way to access its internal records (database)?

Im interested in creating my own reports couse those given by ISE (predefined) are unsufficient.

any clues?

regards

Przemek

[Justin bollinger]

There is an API that may be of use to you.  I dont know that you can directly attach to the DB or not.  

http://www.cisco.com/c/en/us/td/docs/security/ise/1-4/api_ref_guide/api_ref_book/ise_api_ref_ch1.html

[Przemyslaw Konitz]

hi,

I've seen it but its quite limited and for me useless

nethertheless THX

regards

[Justin bollinger]

Just curious, but what type of information are you looking to get from the DB?

[Przemyslaw Konitz]

need to create report which presents failed authentication but I want only one record per failed endpoint which is impossible to do on ISE.

so I was wandering whether it is possible to make custom query

regards

[Justin bollinger]

try this.  maybe it will fit your needs.  

https://raw.githubusercontent.com/bandrel/ciscoisetools/master/uniquefailed.py

[Przemyslaw Konitz]

thx for the script

I'll try this and give back my feedback :)

regards