Next Generation ISE Telemetry, Monitoring, and Custom Reporting, Part 2

Emmanuel Cano Gutierrez, Cisco Security Consulting Engineer, shows us how to do customize database queries using the Data Connect feature in ISE 3.2 and later.
Topics:
00:00 Introduction
00:23 Previous Webinar: Part 1 @ • ISE Guest Access Part ...
01:42 Poll: Which reporting options do you use?
03:46 Agenda
04:37 Why Next-Generation Options
06:00 Reports vs Data Connect
08:10 Data Connect (ISE 3.2 and later)
10:52 Data Connect Deployment Scenarios
12:56 Using Data Connect
14:12 - Enable Data Connect (GUI)
16:38 - Enable Data Connect (API)
17:16 - Repository for Examples: github.com/EmmanuelCano/DataC...
17:49 - Certificate Export / Import
19:48 - Monitoring Alarms, Reports, and Log (ise-psc.log)
21:11 Demos Overview
22:40 Demo: Enable Data Connect : GUI and Python REST API Script
24:43 Demo: Verify Change Configuration Audit Report
25:38 Demo: Data Connect Certificate Export and Import for Java Keystore (for JDBC)
```
keytool -importcert -alias ISEWebinarCert -file DataConnectCertificate.pem -keystore client -storetype JKS
```
27:06 Demo: Data Connect with DB Visualizer
Database URL: jdbc:oracle:thin:@(DESCRIPTION-(ADDRESS-(PROTOCOL-tcps)(HOST-10.X.X.X)(PORT-2484))(CONNECT_DATA-(SID-cpm10)))
Database Userid: dataconnect
Database Password: xxxxxxxxxxx
Driver Properties: javax.net.ssl.trustStore (path to certificate): \Users\TestPC\Downloads\client
Connect
29:36 Data Connect Views (read-only)
31:27 Demo: Filter ISE LiveLogs by NAD IP
SQL queries @ github.com/EmmanuelCano/DataC...
33:48 Demo: Authentications by ISE Node
34:21 Demo: Authentication by Allowed Protocols
34:35 Demo: Authentication by Network Device Name
35:06 Demo: Join Tables (radius_authentication_summary and radius authentications)
35:50 Bonus Demo: Unique Devices Authenticated to Each ISE Policy
SQL queries @ github.com/EmmanuelCano/DataC...
38:44 Resources:
Data Connect: developer.cisco.com/docs/data...
Data Connect (Open API): developer.cisco.com/docs/iden...
Configure ISE 3.2 Data Connect Integration with Splunk: www.cisco.com/c/en/us/support...
GitHub Repository : github.com/EmmanuelCano