We need to query existing Synapse users for the purpose of upcoming ux research study on file versioning.
What we need is a query run against synapse users that:
Returns list of synapse usernames
Includes users that have logged in within the last 12 months
Includes users that introduced or modified new versions of file entities.
Returns count of action (introduced or modified new versions of file entities)
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.
Send list to and . The query used to produce the output: