ISE Reporting

[williamtan]

I'm using ISE version 3.3 with patch 7 currently.

Management want me to submit the posture failed report monthly. I need to generate posture assessment by endpoint and radius authentication report to Excel format. Since it have multiple line for the same endpoint mac address, I need to remove duplicate and get the latest date data. Then based on the mac addresses, I need to extract the location, switch, and switch port from radius authentication report.

It takes me very long time to prepare the report but management request one simple click to generate the report. Is it possible?

Management also request to generate unauthorized device report that connected to the network at past month. But I can't find it in the report menu too.

Thanks for assist. 

[xivemip220]

what you’re describing is possible, but not directly from Cisco ISE’s built-in GUI or default reports.
You’ll need to automate the process using ISE’s ERS (External RESTful Services) API or pxGrid, along with a simple Python or PowerShell script to extract, filter, and export the data automatically into Excel. Let’s break it down step-by-step so you can plan this cleanly.     e-zpassma

[ahollifield]

You should use syslog for this instead and send it to your favorite reporting utility.