Mail reports

Exchange Online usage: how much mail flows, how big the mailboxes are, and how close they are to their quotas. All three come from the Graph reports API as CSV.

flowchart LR
    subgraph Exchange Online reports
      A["get_email_activity_counts"] --> A1["Send / Receive / Read per day"]
      B["get_mailbox_usage_storage"] --> B1["Bytes used per day"]
      C["get_mailbox_usage_mailbox_counts"] --> C1["Total vs active mailboxes"]
      D["get_mailbox_usage_quota_status_mailbox_counts"] --> D1["Under limit / warned / blocked"]
    end

Email activity

Sent, received, and read counts per day, with period totals — spot usage trends and justify (or reclaim) mail licensing.

rows = client.reports.get_email_activity_counts("D30").execute_query().csv_rows()
for row in rows:
    print(row["Report Date"][:10], row["Send"], row["Receive"], row["Read"])

Mailbox usage

Mailbox storage trend, total vs active mailbox counts, and the quota-status breakdown (under limit, warning issued, send prohibited, send/receive prohibited, indeterminate) — the input for storage planning.

storage = client.reports.get_mailbox_usage_storage("D30").execute_query().csv_rows()
quota = client.reports.get_mailbox_usage_quota_status_mailbox_counts("D30").execute_query().csv_rows()

Both scripts need the Reports.Read.All application permission.