Hi @Pavel
Without any app, finding users who have never interacted with a JSM Server project can be very tricky. JQL is primarily designed for searching issues rather than tracking user activity directly. You have to manually examine the history of issues returned from JQL which searches updated JSM issues in a timespan.
On the other hand, if you have access to Jira's database, you could potentially run very complex queries (especially changegroup, changegroupitem tables) to find users who have never interacted with JSM projects. However, I'd not recommend hitting Jira db directly for this purpose as this approach would cause performance problems.
I may understand the reason that you might be willing to decrease JSM agent license tier but without an app it's almost impossible.
You may use an app in which you can define a user custom field reindex JSM projects and search against this field. It might not cover all users but it will be a good starting point. Let's say, you use Enhancer Plugin's Resolution User field, or Transition User fields. Use a JQL something as below, add cf_transitionuser field to the issue navigator
category = service and cf_transitionuser is not empty
return all issues, export to excel and get unique users who are in the list.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.