In Confluence, is there a way to pull the following stats? * Total # of Members using Confluence (snapshot view) * Total # of ballot votes cast in Confluence across all domains? My client would like me to run a report of these and other user stats, and I'm not able to find how to do this.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I pull user stats in Confluence?

Sandy Pflugfelder

In Confluence, is there a way to pull the following stats?

Total # of Members using Confluence (snapshot view)
Total # of ballot votes cast in Confluence across all domains?

My client would like me to run a report of these and other user stats, and I'm not able to find how to do this.

Accepted answers

Patrick Cartier [Candylio]

Hi @Sandy Pflugfelder,

1. If you are on server this url should get you a count:

http://{yourserver}/dosearchsite.action?startIndex=0&type=userinfo&where=conf_all

2. I need to do a bit of follow-up.

Does this question relate to Confluence Questions?

Are you trying to see the total number of votes on any topic and question across all questions? By domains you mean spaces?

All comments

Patrick Cartier [Candylio]

Hi @Sandy Pflugfelder,

1. If you are on server this url should get you a count:

http://{yourserver}/dosearchsite.action?startIndex=0&type=userinfo&where=conf_all

2. I need to do a bit of follow-up.

Does this question relate to Confluence Questions?

Are you trying to see the total number of votes on any topic and question across all questions? By domains you mean spaces?

Sandy Pflugfelder

Hi Patrick, thank you so much for your response. I tried to go to that URL with my server name, but it comes back with "Oops, you've found a dead link." What my client really needs is a report that they can generate as needed with a bunch of user stats. I was hoping I could create a dashboard. Do you know if this is a possibility?

Patrick Cartier [Candylio]

Hi Sandy,

Sorry but can you be more specific about the statistics you want?

Here is some SQL on returned the amount of users, maybe this works for your first part.

https://confluence.atlassian.com/confkb/how-to-get-a-list-of-active-users-counting-towards-the-confluence-license-298978076.html

Sandy Pflugfelder

Hi Patrick, sorry for the delay in my reply. Great, that query worked! Thank you so much for pointing me to it. The other thing I'm looking for is being able to find out how many users we had on a specific date in the past. Is there a way to do that? I haven't been able to find one.