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.