It's not the same without you
Join the community to find out what other Atlassian users are discussing, debating and creating.
Does anyone know, How do I get a list of unlicensed users in STASH using either CLI or database ?
Thanks !
Hi,
This query is for Postgres so it may need to be adapted depending on your database, but it should return the unlicensed users in your Stash instance.
select * from ( (select child_name as user_name from cwd_membership where lower_parent_name not in (select group_name from sta_global_permission where group_name is not null) and membership_type='GROUP_USER' and group_type='GROUP') except (select slug as user_name from sta_global_permission join sta_normal_user on sta_global_permission.user_id = sta_normal_user.user_id) ) as tmp;
This is not working for Oracle database. This is throwing the following error. ERROR at line 1: ORA-00907: missing right parenthesis Appreciate, if you can send me the query for Oracle database. Thanks !
I don't have an Oracle database readily available, but does this query work for you? select * from ( (select child_name as user_name from cwd_membership where lower_parent_name not in (select group_name from sta_global_permission where group_name is not null) and membership_type='GROUP_USER' and group_type='GROUP') minus (select slug as user_name from sta_global_permission join sta_normal_user on sta_global_permission.user_id = sta_normal_user.user_id) ) as tmp;
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.
Read moreBitbucket Pipelines helps me manage and automate a number of serverless deployments to AWS Lambda and this is how I do it. I'm building Node.js Lambda functions using node-lambda ...
Connect with like-minded Atlassian users at free events near you!
Find a groupConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.
Start an AUGYou're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.