Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Where to run queries?

Vasudeva Gupta
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Apr 19, 2023

I want to get last modified dates for all pages . The link below talks about Analytics, Data Center and Server; whereas how to go to the server and where exactly to run the queries? Help me to navigate to the place where I can run the query.

4 answers

4 accepted

0 votes
Answer accepted
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 20, 2023

If you can't get access to the database to run those queries, you could just use the Page Status Browser provided by the Better Content Archiving app.

It allows working a tree control that shows the last update date:

page-status-browser (1).png

(Discl. it is a paid and supported app developed by our team.)

0 votes
Answer accepted
Radek Dostál
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Apr 19, 2023

It states 

If you have Confluence Server, you'll need to query the database directly to find out this information.


It's SQL language which you'd run in a database client, which is dependent on which database type your Confluence is connected to. Most commonly this would be PostgreSQL (but you might just as well be running a different database):


But you could just as well be running on plenty other db types such as MySQL which uses a different client, etc.


However, you would of course need to also know where the database is running, the database name to connect to, credentials to use, and most importantly, running SQL directly can have devastating effect if you do not know what you're doing. I would suggest you talk to your sysadmin(s) who set up Confluence as they should be familiar with how to connect to the db and how to run queries in it.


That said, this is only specific to Server edition of Confluence, if you are in fact running Data Center (which you should imo because Server is nearing end of life), then you can use the "Insights" which is baked into data center, without having to run SQL - 


You can see more info about the database in "System info" page in Confluence (to determine the type for example), and the db settings are in <confluence_home>/confluence.cfg.xml file such as the address, name, and most importantly the credentials Confluence uses to talk with the db.

Hi @Vasudeva Gupta ,

The queries must be run directly in your database associated to Confluence ( for Server and Datacenter versions of the product)

depending on the kind of database, you can use different tools to access it. For example , you can use tools like Pg Admin to access PostgreSQL

Or you can ask your database administrators to run the queries.


For Cloud you must go through Confluence Cloud Rest API, but not sure if this information is available.

Hope this helps,


Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events