SQL to duplicate restricted pages report

Question

We need to provide details for out attestation process from confluence on everyone who has access to restricted pages.

The inbuilt space level report that is provided  in Space Tools > Permissions > Restricted Pages provides all the information we need, I just need the same data via a sql satatement that I can get in a csv or similar for upload into our attestation platform.

Has anyone done something similar can someone help with the SQL code (I am not a coder!)

Any help very much appreciated.

Neil Gower · Answer

Okay thanks will grab some of the DBA's time and see what we can do, thanks for pointing us in the correct direction. Will post when I have an update, and post the sql we use here as well

Stephen Sifers · Answer

Hello Neil,

This is a great question, how to get Confluence page restrictions and space permissions via a SQL statement to export into a CSV format. With this said there are two guides which will assist with getting the information you need. You may find these guides here:

* How to Check Permissions for a Space via SQL Queries
* How to List All Pages Restricted to a Specific Group
* How to remove all restrictions from a specific page via the database
* The statement to find the restricted pages is within the delete statement.

The above references will help to discover the data you’re looking for. We would suggest working with your DBA to discover this data and ensure you’re using a query only account as to not delete or change and production data.

Regards,
Stephen Sifers