File reports — OneDrive and SharePoint

Who is using OneDrive and SharePoint, and where the storage actually lives.

flowchart TD
    subgraph Activity ["Activity — who is using it"]
      A["get_onedrive_activity_user_counts"] --> A1["Viewed/edited, synced, shared"]
      C["get_sharepoint_activity_user_counts"] --> C1["Visited, viewed, synced, shared"]
    end
    subgraph Usage ["Usage — what is stored"]
      B["get_onedrive_usage_file_counts"] --> B1["Total vs active files"]
      D["get_onedrive_usage_storage"] --> D1["Bytes stored"]
      E["get_sharepoint_site_usage_detail"] --> E1["Storage and file count per site"]
    end

OneDrive activity

Unique users who viewed or edited, synced, or shared files each day — split into internal and external sharing, with peak and total per activity type.

rows = client.reports.get_onedrive_activity_user_counts("D30").execute_query().csv_rows()
for row in rows:
    print(row["Report Date"][:10], row["Viewed Or Edited"], row["Shared Externally"])

OneDrive usage

Total vs active files, and the daily storage trend. The storage report returns one row per site type; the script keeps the OneDrive rows.

files = client.reports.get_onedrive_usage_file_counts("D30").execute_query().csv_rows()
storage = client.reports.get_onedrive_usage_storage("D30").execute_query().csv_rows()

SharePoint sites

Per-site storage and file counts for the whole tenant, listing the largest sites by default — the basis for SharePoint storage governance and cleanup.

rows = client.reports.get_sharepoint_site_usage_detail("D30").execute_query().csv_rows()
total = sum(float(r.get("Storage Used (Byte)") or 0) for r in rows)

Concealed site names

When a tenant enables report privacy, the report hides site URLs and owner names behind placeholders. sharepoint_sites.py detects that and falls back to the site template (Group, Team Site, ...) plus the file count.

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