Skip to main content

IBM Verify (deprecated)

Warning

Deprecated. Do not use these tables in new work. Use IBM Verify Counts, built from the IBM Verify event stream. These tables will stop updating when the reporting API pull is decommissioned.

Daily aggregates in the ibm_verify schema, pulled from the IBM Verify reporting API.

Deprecated table Replacement
auth_total_logins events_auth_total_logins
app_login_counts events_app_login_counts
mfa_activity events_mfa_activity
risk_adaptive_access_total events_adaptive_risk_summary

Tables

Table Description
ibm_verify.app_login_counts Deprecated. Daily SSO event counts by application.
ibm_verify.auth_total_logins Deprecated. Daily CanadaLogin-wide authentication event totals.
ibm_verify.mfa_activity Deprecated. Daily multi-factor authentication activity by factor and result.
No matching items

Data retention

The API keeps only 90 days of per-user data, so the year-to-date and 365-day unique-user figures it computes can undercount. Daily rows stored on our side are unaffected.