In one line: Copilot can now tell you who last changed each model object, and when — in plain English, on demand. It's last-modified accountability + staleness, not a full change history.
What it is
Every model object carries three audit fields (we've been collecting them for ~8 months):
- createdOn — when the object was first created
- updatedOn — when it was last changed
- changedBy — who last changed it (Copilot resolves this to the person's email)
Copilot reads these over the live project model, so you just ask in plain English. The same data is available through our MCP.
What you can ask (verified)
| Ask Copilot | What you get |
| "Which tables changed most recently, and by whom?" | Objects ranked by last edit, with the editor's email |
| "What have I changed?" / "What did <teammate> last touch?" | Objects whose last editor is that person |
| "Which tables haven't been touched in 30 days?" | Stale objects (last edit vs. today) |
| "What changed this week?" | Recently active objects |
| "Which tables were created but never modified?" | createdOn == updatedOn |
| "Which objects have no edit info yet?" | Untouched since tracking began |
| "Who last touched the relationships on X?" | Relationships carry audit fields too |
Works across tables, views, schemas, databases, relationships, diagrams (and most model objects). Timestamps can be shown as readable dates.
Good for: last-editor accountability • spotting stale/forgotten tables • light domain-ownership & onboarding ("who works on the party model") • activity grouped by schema.
What it can NOT do (so we don't oversell it)
- Not a history / changelog. It's a single last-changed snapshot, not a timeline. It can't show how a table evolved between two dates, diff revisions, count how many times something was edited, or report change velocity. → Evolution over time = Revision History / Compare, a separate capability.
- No "created by." You get when an object was created and who last changed it — there is no original-author field.
- Object-level, not column-level. Per table / view / schema / etc. — not per individual column.
- Only since ~Oct 2025. ~8 months of data. Objects untouched since then (or anything from 2024) have empty audit info.
- No monitoring, alerts, SLAs, or dashboards. Copilot answers when asked — it doesn't watch the model or notify anyone.
- Timestamps ≠ effort. createdOn → updatedOn is just first-edit to last-edit, not "design time" or number of iterations.
- Not a compliance/immutable audit log (SOX, GDPR, etc.) — it's convenience metadata, not a tamper-proof trail.
How to explain it in one breath
"Copilot can now answer who last changed what, and when across your model — great for finding the last editor, spotting stale tables, and basic ownership/onboarding. It's last-touch info, object-level, from the last ~8 months — not a full revision history."