DataConnect Database Views
Description
DataConnect provides read-only Oracle database access to ISE operational data. Views are organized by function:
-
Authentication - RADIUS/TACACS+ auth logs
-
Accounting - Session accounting data
-
Endpoints - Device inventory and profiling
-
Policy - Policy sets, authz profiles, SGTs
-
Audit - Configuration changes, admin logins
-
Posture - Compliance assessment results
View Categories
RADIUS Authentication & Accounting
| View | Description |
|---|---|
|
All RADIUS authentication attempts |
|
Last 7 days of authentications |
|
Aggregated auth statistics |
|
Session accounting (start/stop/interim) |
|
Last 7 days of accounting |
|
Authentication failures with reasons |
|
Detailed diagnostic messages |
TACACS+ Authentication & Accounting
| View | Description |
|---|---|
|
All TACACS+ authentications |
|
Recent TACACS+ auths |
|
Aggregated TACACS+ stats |
|
TACACS+ authorization events |
|
Recent authorizations |
|
TACACS+ command accounting |
|
Recent accounting |
|
Detailed command logs |
Endpoints & Profiling
| View | Description |
|---|---|
|
All endpoint records (MAC, profile, group) |
|
Endpoint group definitions |
|
Endpoints scheduled for purge |
|
Registered/known endpoints |
|
Profiling statistics |
|
Profiler policy definitions |
|
Logical profile definitions |
Policy & Authorization
| View | Description |
|---|---|
|
Network access policy sets |
|
Authorization profile definitions |
|
TrustSec SGT definitions |
|
SGACL definitions |
|
User password policy |
|
Policy set mappings |
|
Policy set policy associations |
Network Infrastructure
| View | Description |
|---|---|
|
NAD inventory (switches, WLCs, APs) |
|
Device group hierarchy |
|
ISE deployment nodes |
|
NADs with config issues |
|
Supplicants with issues |
Identity Sources
| View | Description |
|---|---|
|
AD join point status |
|
LDAP store configuration |
|
Certificate auth profiles |
|
ODBC identity stores |
|
RADIUS token servers |
|
REST identity stores |
|
RSA SecurID config |
|
SAML IdP configurations |
|
Social login providers |
|
Internal user accounts |
|
User group definitions |
Guest & Sponsor
| View | Description |
|---|---|
|
Guest user accounts |
|
Guest session accounting |
|
Guest device login audit |
|
Sponsor portal activity |
|
AUP acceptance tracking |
Audit & Administration
| View | Description |
|---|---|
|
Configuration change log |
|
Admin login history |
|
Admin user accounts |
|
Password change audit |
|
API operation audit |
Posture & Compliance
| View | Description |
|---|---|
|
Posture results by condition |
|
Posture results by endpoint |
|
Grace period status |
|
Script condition results |
|
Remediation actions |
Complete View List
All 70 DataConnect Views
AAA_DIAGNOSTICS_VIEW
ADAPTER_STATUS
ADAPTIVE_NETWORK_CONTROL
ADMINISTRATOR_LOGINS
ADMIN_USERS
AUP_ACCEPTANCE_STATUS
AUTHORIZATION_PROFILES
CHANGE_CONFIGURATION_AUDIT
COA_EVENTS
ENDPOINTS_DATA
ENDPOINT_IDENTITY_GROUPS
ENDPOINT_PURGE_VIEW
EXT_ID_SRC_ACTIVE_DIRECTORY
EXT_ID_SRC_CERT_AUTH_PROFILE
EXT_ID_SRC_LDAP
EXT_ID_SRC_ODBC
EXT_ID_SRC_RADIUS_TOKEN
EXT_ID_SRC_REST
EXT_ID_SRC_RSA_SECURID
EXT_ID_SRC_SAML_ID_PROVIDERS
EXT_ID_SRC_SOCIAL_LOGIN
FAILURE_CODE_CAUSE
GUEST_ACCOUNTING
GUEST_DEVICELOGIN_AUDIT
KEY_PERFORMANCE_METRICS
LOGICAL_PROFILES
MISCONFIGURED_NAS_VIEW
MISCONFIGURED_SUPPLICANTS_VIEW
NETWORK_ACCESS_USERS
NETWORK_DEVICES
NETWORK_DEVICE_GROUPS
NODE_LIST
OPENAPI_OPERATIONS
POLICY_SETS
POSTURE_ASSESSMENT_BY_CONDITION
POSTURE_ASSESSMENT_BY_ENDPOINT
POSTURE_GRACE_PERIOD
POSTURE_SCRIPT_CONDITION
POSTURE_SCRIPT_REMEDIATION
PRIMARY_GUEST
PROFILED_ENDPOINTS_SUMMARY
PROFILING_POLICIES
PXGRID_DIRECT_DATA
RADIUS_ACCOUNTING
RADIUS_ACCOUNTING_WEEK
RADIUS_AUTHENTICATIONS
RADIUS_AUTHENTICATIONS_WEEK
RADIUS_AUTHENTICATION_SUMMARY
RADIUS_ERRORS_VIEW
REGISTERED_ENDPOINTS
SECURITY_GROUPS
SECURITY_GROUP_ACLS
SPONSOR_LOGIN_AND_AUDIT
SYSTEM_DIAGNOSTICS_VIEW
SYSTEM_SUMMARY
TACACS_ACCOUNTING
TACACS_ACCOUNTING_LAST_TWO_DAYS
TACACS_AUTHENTICATION
TACACS_AUTHENTICATION_LAST_TWO_DAYS
TACACS_AUTHENTICATION_SUMMARY
TACACS_AUTHORIZATION
TACACS_AUTHORIZATION_LAST_TWO_DAYS
TACACS_COMMAND_ACCOUNTING
THREAT_EVENTS
UPSPOLICY
UPSPOLICYSET
UPSPOLICYSET_POLICIES
USER_IDENTITY_GROUPS
USER_PASSWORD_CHANGES
VULNERABILITY_ASSESSMENT_FAILURES