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

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to find out how many Knowledge Base Articles you have?


I am trying to report to the managers how many knowledge base articles we have. One of our goals for 2018 is to increase our KB repository, so I just wanted to measure how many we have right now, so we can compare it. 

1 answer

0 votes
Guilherme V. Atlassian Team Feb 21, 2018

Hi Andrea,

You can use a DB query in order to find how many pages you have in Confluence:

select count(*) from content where contenttype = 'PAGE' and content_status = 'current'

You can also use plugins:

Hi Guilherme, 


Can you please walk me through the process? I tried it and it didn't work for me. 


thank you, 


Andrea Aznar

Guilherme V. Atlassian Team Feb 22, 2018

what kind of issues you had with the query? Were you able to access the database? depending the database(mysql,oracle..), the query needs to be uppercased

So I went to the Confluence page, and then where do I perform the search? 

How do I access the database? 

Guilherme V. Atlassian Team Feb 22, 2018

What's your confluence's address? If you are using Confluence Cloud, then you'd not have access to the DB. If you are using the standalone version, then the Confluence admin would be able to access the database.

I am using Confluence Cloud. Is there a workaround it? 

Renata Bueno Atlassian Team Feb 22, 2018

Hello, Andrea!

Since the information you're requesting is confidential to your company, we've proceeded to open a support ticket on your behalf to assist you in this matter: JST-370093. In case you have any questions, please feel free to contact us as well!

Best Regards!

Renata Bueno | Atlassian Support

Like Rahul Kumar likes this

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

Admins, notify your Jira instance of system-wide changes with the new admin announcement banner

Hi All! We’re excited to share the launch of an announcement banner that lets Jira site administrators communicate directly to their users across their  Jira Cloud instance.  ...

553 views 15 18
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you