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:
- 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.
- 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
