We need to query existing Synapse users for the purpose of upcoming ux research study.
What we need is a query run against synapse users that:
Returns list of synapse usernames
Includes users that had an account for at least 6 months
Includes users that have logged in within the last 6 months
Includes users that are part of access control list in any synapse project, directly or via team (except if they belong to AnyoneOnTheWeb and AllSynapseUsers teams)
If there are any issues with getting this data and any options to get us similar data with much less effort, we can tweak the query.
once you see this, please let me know the timeframe involved so that we can plan the study accordingly (we need this to proceed).