Create
cancel
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

Query related to "User statistics" Macro

Hello Team

Can you please let me know how to use "User Statistics' Macro ,who developed this macro? Was it Atlassian? and how to use the macro, 

We tried to generate report using "User Statistics' Macro but all time we get variance, please help us to resolve below queries:

 

    1. Let us know how we can identify this is an accurate report (given the variance one of the questions will be how do we know this is accurate?) we need certification from the vendor.
    2. Also, why is the report different? The original report was generated using this query:

SELECT s.spacename, s.spacekey, s.spacetype, s.spacestatus, s.creationdate, s.lastmoddate, u.lower_username FROM spaces AS s JOIN user_mapping u ON s.creator = u.user_key ORDER BY s.spacekey;

 

Lastmoddate at this <spaces> table yields only 80+ spaces with a lastmoddate greater than Jan 2020… the question I need an answer to is why this query says 80+ and the Macro report says 400+.

 

Space Url :; https://conflu.allstate.com/

 

Thanks,

Gurinder 

1 answer

0 votes
Brant Schroeder Community Leader Sep 26, 2021

@Gurinder Singh Welcome to the Atlassian Community

From the URL it looks like you are on Server and not cloud.  Cloud and Server do not have a User Statistics Macro that is delivered.  There is a Macro called Usage Statics that is delivered on Server and created by Atlassian.  You can learn more about how it works here: https://confluence.atlassian.com/doc/macros-139387.html#Macros-Macrousagestatistics

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence Cloud

🎨 Add some visual life to your templates

Hi Atlassian Community, My name is Avni Barman, and I am a Product Manager on the Confluence Cloud team. Based on feedback from you, we are giving admins more power to create templates that a...

215 views 4 9
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