Microsoft 365 License & Activity - Snapshot Summary and History#

Pair current activity and cost fields from the summary with per-user historical snapshot rows for the same period—useful for audits, comparisons, and drilldown to a user’s timeline.

Tables

TABLES
TitleResourceFieldsDrill-down
Activity Summary - Active Users Microsoft O365 Activity Summary Customer
user_principal_name
last_activity_date
assigned_products
audio_duration
Days Since Last Activity
license_cost_annual_total_formatted
license_cost_currency
license_cost_monthly_by_bucket
license_cost_monthly_by_sku
license_cost_monthly_total_formatted
license_cost_monthly_total
license_cost_annual_total
drilldown-modelType: data/DataO365ActivitySummary
Activity Summary - All Users Microsoft O365 Activity Summary Customer
user_principal_name
last_activity_date
assigned_products
license_cost_monthly_total
audio_duration
Days Since Last Activity
drilldown-modelType: data/DataO365ActivitySummary
o365 History Microsoft O365 Activity Snapshot History timestamp_epoch
report_refresh_date
Customer
user_principal_name
last_activity_date
snapshot_at
deleted_date
report_period
assigned_products
Is Active
Is Deleted
Is External
Is Licensed
Meeting Count
drilldown-modelType: data/DataO365ActivitySnapshotHistory