Alteryx Gallery - how to count number of Private Studios not associated to users

[Nicholas_Tasa]

Hi all, wondering how we can count the number of studios in our gallery that are not associated to an individual user. Each new user has a studio created by default, we want to know how to count the number of studios that are not created by default for each user.

We can get the total with the below query in Mongo

db.getCollection('subscriptions').find({}).count()

[fmvizcaino]

Hey @Nicholas_Tasa ,

I would suggest you using the Alteryx Server Usage Report. There you have most of the interactions needed to find that out. The suggestion would be to check studios that don't have a username in their name.

https://help.alteryx.com/20213/server/install-server-usage-report

Best,

Fernando Vizcaino

[elsastark]

Hi @Nicholas_Tasa - Since a studio is created automatically when the user is added, there could be a way to match up the creation dates between the studios and users in Mongo to identify which ones were created in parallel with the user's profile. Probably would want to have some sort of check of the naming convention like @fmvizcaino mentioned so that you aren't just relying on the timestamp.