Skip to content

Mailbox Message Report 2.0.0

Choose a tag to compare

View all tags
@Nico77600 Nico77600 released this 07 Oct 15:04
· 16 commits to main since this release
v2.0.0
5c41f13

Every message in the HTML report, and a CSV file Excel always opens. Read only. The format of the reports changes (new column, new HTML report): MAJOR version.

HTML report

The design of the HTML report of Purview DLP Report:

  • Every message, up to Report.HtmlMaxMessages (now 500,000 by default, 0 to 2,000,000; 20,000 before), in compressed blocks of 20,000 (JSON, gzip, base64; folders, subjects, addresses, names and types stored once in dictionaries), decompressed by the page into typed arrays.
  • A table that draws only the visible rows: it scrolls through hundreds of thousands of messages at once.
  • Filters, together: every field, mailbox, location (primary mailbox, archive, Recoverable Items), folder, sender, subject, recipient (To, Cc, Bcc), Internet message ID, received dates, minimum of recipients, with attachments.
  • Sort by a click on a column; every recipient of a message in its detail (To, Cc, Bcc, with Copy); Export the view to CSV.
Messages (synthetic) HTML Opens in Search Memory of the page
200,000 6.5 MB 1.1 s 0.1 s 55 MB
1,000,000 32 MB 4.1 s 0.3 s 305 MB

Version 1.x: 200,000 messages in 118 MB, 200 rows at a time. Real messages (longer message IDs, more subjects): count two to three times these sizes.

CSV safe for Excel

  • A cell is never longer than an Excel cell (32,767 characters). A message sent to 10,000 people broke the row in Excel (4 rows × 8,750 columns, measured): a list of recipients is now cut after its last whole address, with the number of the others (… (+8,739 more)), one row of 23 columns.
  • New column RecipientCount (To + Cc + Bcc; empty with -SkipRecipients) after Bcc.

Validated

  • 36 Pester tests (the blocks of the HTML report decoded as the page does; a message of 10,000 recipients).
  • Excel through COM (the CSV with 10,000 recipients); Microsoft Edge (200,000 and 1,000,000 messages); lab tenant: 5,275 messages of two mailboxes and their archives, filters, sort, detail and export.

Upgrade

Take the configuration file of the package (or set Report.HtmlMaxMessages = 500000). The page needs a recent Microsoft Edge, Google Chrome or Firefox (DecompressionStream): not Internet Explorer mode, not the preview of OneDrive or SharePoint.

Unblock the files after downloading: Get-ChildItem "C:\Chemin\Du\Dossier" -Recurse -File -Force | Unblock-File.

Guides: docs\MailboxMessageReport-UserGuide.html and docs\MailboxMessageReport-Guide.html in the zip.

Assets 3
Loading