Skip to content

History / Database Schema

Revisions

  • Document that importer timestamps are stored in UTC Adds a Time zones section to the Database Schema page clarifying that all event and activity timestamps (web tracking, audit log, usage reports, Teams/calls/email/Copilot) are stored in UTC. Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com>

    @sambetts sambetts committed Jun 26, 2026
  • Wiki: finish branding modernisation + fix two malformed Analytics tables - Modernise generic 'Office 365' platform references to 'Microsoft 365' across the wiki (44 occurrences), now that the product is 'Microsoft 365 Advanced Analytics'. The real 'Office 365 Management [Activity] API' name and code identifiers (Office365ActivityImporter, o365_client_applications) are preserved. - Analytics - Data model: fix the malformed 'Usage metrics' table (the header had two columns but the data row had four; the stray cells duplicated the App-per-platform table below). - Analytics: de-indent the Runbooks table so it renders reliably (it was indented under a list item). Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com>

    @sambetts sambetts committed Jun 18, 2026
  • Wiki updates for next release: Power Platform, Sent Email, FK upgrade New page - Audit Events FK Upgrade: operator guide for the AddAuditEventsOperationIndex + AddAuditEventsOperationFK migrations - what the upgrade does, measured benchmark, time estimates for VM/HDD and Azure SQL DB tiers, row-count probe SQL, pre/during/after steps, sanity-check script. Updates - Database Schema: new Power Platform section documenting all the new tables (power_app_environments, power_apps, power_automate_flows, power_bi_*, copilot_studio_bots, event_meta_*, connector junction tables). audit_events row updated to reflect the restored FK and link to the FK upgrade page. - Release Notes: new top entry covering the 6 migrations, Power Platform import, Sent Email Import, Cognitive Services RBAC fallback, optional Service Bus, license import + delta-token + Power BI merge + org-URL + SentEmail cascade fixes, and the ImportTaskSettings opt-in behaviour change. - Home: Power Platform Adoption Events and Sent Email entries added to the Data Collection Map. - Prerequisites: Microsoft.ServiceBus marked optional (only required when Calls import is enabled); ActivityFeed.Read row extended to mention Power Platform adoption events. - Updating the solution: new Schema-change considerations section linking to the FK upgrade page with the pre-upgrade checklist. - _Sidebar: link to the new Audit Events FK Upgrade page. Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com>

    @sambetts sambetts committed Jun 1, 2026
  • Docs: add Sent Email Import feature details and related permissions to database schema and prerequisites

    @sambetts sambetts committed May 5, 2026
  • Docs: rename GUID media files to descriptive names and update database schema - Rename 178 GUID-named wiki images to descriptive names derived from page context and section headings (e.g. a196d0f6ee3d1e7b6059fd8f7eeed03b.png → deployment-guidance-aad-in-azure-portal.png) - Update all image references across 13 markdown files - Remove dead link references in Deployment Guidance - Database Schema: add missing Copilot section (13 tables), plus undocumented tables in Teams, Web Sessions, Audit, and Miscellaneous sections - Analytics Data model: fix incorrect Copilot table names (event_copilot_chats → copilot_chats, etc.) - Fix "Platoform" typo → "Platform"

    @sambetts sambetts committed Mar 3, 2026
  • Docs

    @jesusfer jesusfer committed Aug 2, 2024
  • Move docs from main repo

    @jesusfer jesusfer committed Aug 2, 2024