Unlimited JSM License? How to find the real agents at JSM for the right Cloud or DC license

Here are your Codes:

• SQL Code

  SELECT DISTINCT u.lower_user_name
FROM cwd_user u
JOIN cwd_membership m ON u.id = m.child_user_id
JOIN cwd_group g ON m.parent_id = g.id
JOIN app_user au ON u.lower_user_name = au.user_key
JOIN changegroup cg ON au.user_key = cg.author
JOIN jiraissue ji ON cg.issueid = ji.id
JOIN project p ON ji.project = p.id
JOIN nodeassociation na ON p.id = na.source_node_id
WHERE u.active = 'T'
AND g.lower_group_name = 'jira-servicedesk-users'
AND na.sink_node_entity = 'ProjectType'
AND na.sink_node_id = (SELECT id FROM projecttype WHERE "key"='service_desk

• Groovy Code

  import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.history.ChangeItemBean

def groupManager = ComponentAccessor.getGroupManager()
def changeHistoryManager = ComponentAccessor.getChangeHistoryManager()
def projectManager = ComponentAccessor.getProjectManager()

// Holen Sie sich alle aktiven Benutzer in der Gruppe 'jira-servicedesk-users'
def users = ComponentAccessor.getUserManager().getUsersInGroup('jira-servicedesk-users').findAll { it.isActive() }

// Holen Sie sich alle JSM-Projekte
def jsmProjects = projectManager.getProjectObjects().findAll { it.projectTypeKey.key == 'service_desk' }

// Ergebnis
def result = []

users.each { user ->
    def userHasEditedJSMIssue = jsmProjects.any { project ->
        def issuesInProject = ComponentAccessor.getIssueManager().getIssueObjects(ComponentAccessor.getIssueManager().getIssueIdsForProject(project.id))

        issuesInProject.any { issue ->
            def changeItems = changeHistoryManager.getChangeItemsForField(issue, "*")
            changeItems.any { ChangeItemBean changeItemBean ->
                changeItemBean.getUserKey() == user.key
            }
        }
    }

    if (userHasEditedJSMIssue) {
        result << user.name
    }
}

return result

• For tickets created within the last 3 months

  import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.history.ChangeItemBean

def groupManager = ComponentAccessor.getGroupManager()
def changeHistoryManager = ComponentAccessor.getChangeHistoryManager()
def projectManager = ComponentAccessor.getProjectManager()

// Holen Sie sich alle aktiven Benutzer in der Gruppe 'jira-servicedesk-users'
def users = ComponentAccessor.getUserManager().getUsersInGroup('jira-servicedesk-users').findAll { it.isActive() }

// Holen Sie sich alle JSM-Projekte
def jsmProjects = projectManager.getProjectObjects().findAll { it.projectTypeKey.key == 'service_desk' }

// Zeitpunkt vor 3 Monaten
def threeMonthsAgo = new Date() - 3.months

// Ergebnis
def result = []

users.each { user ->
    def userHasEditedJSMIssue = jsmProjects.any { project ->
        def issuesInProject = ComponentAccessor.getIssueManager().getIssueObjects(ComponentAccessor.getIssueManager().getIssueIdsForProject(project.id))

        issuesInProject.any { issue ->
            def changeItems = changeHistoryManager.getChangeItemsForField(issue, "*")
            changeItems.any { ChangeItemBean changeItemBean ->
                changeItemBean.getUserKey() == user.key && issue.getCreated().after(threeMonthsAgo)
            }
        }
    }

    if (userHasEditedJSMIssue) {
        result << user.name
    }
}

return result