Hi All,
I have a SQL qurey to get the inactive user's filter from jira server/DC environment and it works in Mysql server, but it does not work in Azure MSSQL.
It looks like it does not find the table named "searchreaquest".. You have to make sure that you are using correct database. Usually you choose that on beginning when connecting to database (something like "use [databasename]"
Also this article might be helpful overall if you want to find only inactive users
Identify users in Jira who haven't logged in for the past 90 days | Jira | Atlassian Documentation
There is example of MSSQL query that you can use (if you want inactive users then I guess you should change period and this line
WHERE u.active = 1
AND d.active = 1
to
WHERE u.active = 0
AND d.active = 0
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.