i would like to get count of blogs, pages, comments, questions, answers and points for each user in confluence? To know the users who are active in confluence.

[Avinash Pandugayala]

i would like to get count of blogs, pages, comments, questions, answers and points for each user in confluence? To know the users who are active in confluence.

[Sarah Heimeier]

Hi Avinash,

If you want to disable inactive users from Confluence, it is possible to find out who is inactive by running SQL queries against your database.

To do this you can follow the steps detailed here: 

https://confluence.atlassian.com/display/CONFKB/How+to+identify+inactive+users+in+Confluence

You can get information about users who:

• Are inactive
• Not logged in since a specific date
• List users by last login date
• List users by previous login date
• Active users who haven't created content 

I hope this helps!