db query to extract global content

[Peter Steiger]

My boss is writing up an audit report for upper management that summarizes total activity in our on-prem wiki. Basically a spreadsheet version of the Global Activity report. From my googling I gather that it is not possible to simply extract this report to CSV, so I'm looking to write a query that will pull the data I need, presumably out of the content table.

Does the content table show only the most recent edit? That is, do I need to join with any other tables to get (for example) all edits to a given page? Or does the global activity report draw from another source entirely?

If someone here has already invented this wheel and would be willing to share your query with me, you'd save me a ton of research and earn my eternal gratitude.

[Dominic Lagger]

Hi @Peter Steiger 

I don't have a finished query for you, but here are my thoughts:

• I would assume, that every entry in the content table is one edit. I'm not sure about that, but it seems, that every entry in this table is coming from an edit or save.
• Every Edit on a page creates a new content version. You can check that when you see the page history. Every page history has it's own contentid

Hope this helped a little bit.

Regards, Dominic