Analyse DMARC reports

cn flag

I receive Google's DMARC reports daily as a zip file containing an XML file. I manually download each zip file ~/Documents/DMARC.

I want to aggregate the information from all the saved DMARC reports and produce a human-readable readable report (e.g. table in LibreOffice Calc spreadsheet). I am on Ubuntu 20.04 standard desktop, so I would rather not have memory-hungry or CPU-hungry services running all the time.

Any suggestions on how to do this?

Background Info

Domain-based Message Authentication, Reporting and Conformance (DMARC) is an evolving technical standard and the DMARC report format is specified by that standard. It also looks like Ubuntu will natively support DMARC from 21.04 onwards, but not in 20.04.

The Google link above shows samples of input DMARC XML file format and an output tabular form. As requested, they are pasted here.

Sample input XML file:

<?xml version="1.0" encoding="UTF-8" ?>
    <email>[email protected]</email>

Sample output table: Sample output table:

muru avatar
us flag
Add some example input and what sort of output you want to your question please.
JayDin avatar
cn flag
@muru the Google link in the question shows both input and output formats. I have also now explicitly stated this in the question. Is that enough?
muru avatar
us flag
No, please include relevant information *in this post* as text, with [code formatting](
JayDin avatar
cn flag
@muru ok, added further info and code.
muru avatar
us flag
Thanks, having the XML here is better.

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.