Querying when restrictions were added or removed

[Kathryn Reddie]

Hi all,

Is there a way I can find when restrictions were added or removed using the database? I've looked at CONTENT_PERM but I can't work out how to query a page id.

My skills in SQL are limited to basic queries I'm afraid.

Thanks,
Kathryn.

[Dave Liao · Accepted solution]

@Kathryn Reddie - unfortunately Confluence doesn't track when page restrictions were removed, just when they're initially applied (as you can see in Page Information for a given page).

This has been a pain point, and I believe there are multiple suggestion tickets for this, including https://jira.atlassian.com/browse/CONFSERVER-19721

[Kathryn Reddie]

Thanks @Dave Liao ,

Could I query when the restrictions were applied by page id via SQL?

Thanks,
Kat.

[Dave Liao]

Hi Kat! I presume you can, but I'm unsure what the exact SQL query would be.

This is partially relevant - these are queries to return pagesthat have restrictions:

https://confluence.atlassian.com/confkb/how-to-list-pages-with-restrictions-951412334.html

For reference, here's info on Confluence's data model, that might help you craft a SQL query: https://confluence.atlassian.com/doc/confluence-data-model-127369837.html