MOCKUP — M - Distribution Groups · Phase 2 · admin · ops · Follow REPORT-DESIGN-SPEC.md in Power BI Desktop to build this
Cq Claritiq · M - Distribution Groups Refreshed today
Critical Caution Healthy · target
Scope: eni.enigron.com · c1.eni.enigron.com
Total DGs
287
across all domains
Empty
42
14.6% — safe to delete
No owner
78
27.2% — unmanaged
No activity 90+
164
57.1% — review
Single-member
31
consider per-user routing
Dynamic DGs
12
rule-based — verify rules
DGs by ownership state
OwnershipCount% of DGsDistribution
Single owner (active user)14249.5%
142
Multiple owners6723.3%
67
No owner7827.2%
78
No-owner DGs are unmanaged — when the original owner leaves and no replacement is named, they keep delivering to ex-employees and external addresses unattended.
DGs by message activity (last 90 days)
ActivityCountSeverity
10+ messages/week47Active
1-10 messages/week76Active
< 1 message/week64Low usage
No messages 90+ days78Stale
No messages ever22Dead
Quick views
Cleanup candidates — empty + no-owner + no-activity Showing 6 of 142 · Sorted by Last activity asc
DG nameEmailMembersOwnersLast messageRecommendation
DL-Q4-2019-Commscomms-q42019@contoso.com002020-01-08Delete
DL-Project-Apollo-Teamapollo-team@contoso.com202021-06-03Delete or assign owner
DL-EOL-Migration-2023migration2023@contoso.com1402023-12-12Assign owner
DL-AcmeVendor-Notificationsacme-notif@contoso.com102024-08-14Single member · convert to user routing
DL-Marketing-Newsletter-Oldmkt-news@contoso.com41212024-11-22Verify still in use
DL-Test-Distributiontest-dl@contoso.com30Test list · delete