How to export list of active users to excel in jira data center

[Andrew W Matthews]

Hi, I'm trying to export list of active users to excel in jira data center, but I'm not able to do so because there is no option to do so.

[Ken McClean]

It sounds like you're just looking to export the names of active users?  If so, it'd be far simpler to just fetch the list and paste it into Excel:

import com.atlassian.jira.component.ComponentAccessor

def userManager = ComponentAccessor.getUserManager()

def userBuffer = []

def users = userManager.getAllApplicationUsers()

users.each{user ->

   if(user.active == true){

    userBuffer.add(user.name + "<br>")

  }

}

userBuffer.toString()

    .replace(",", "")  

    .replace("[", "")  

    .replace("]", "") 

    .trim();