Hi, I build a script to remove licences from inactive users. I want to combine these two queries:
1) Identify users in Jira who haven't logged in for the past 90 days
2) Get list of licensed users in Jira server
into one table to get list of inactive users with license (software and service desk), but my knowledge of SQL is not enough good. Jira version 8.5, MySQL database. Later I want to use API request to remove them from group.
Any SQL masters here? :) I'd be grateful for help.