Scriptrunner - get active users who's not logged in for the past 90 days

Question

Hi!

I'm trying to retrieve users who's account is active, but who either haven't logged in for 90 days, or who's never logged in.

With the script below i get users as expected based on login times/no login, but it also returns users who's been deactivated.

I think I can use the com.atlassian.jira.user.ApplicationUser property called "isActive", but I'm not sure how to correctly add it in the script.

Any help is much appreciated!

import com.atlassian.jira.user.util.UserManagerimport com.atlassian.jira.component.ComponentAccessorimport com.atlassian.jira.security.login.LoginManager

def userManager = ComponentAccessor.getUserManager()def loginManager = ComponentAccessor.getComponent(LoginManager)
ArrayList oldUsers = new ArrayList()Date today = new Date()//CHANGE TO DESIRED AMOUNTint threshold = 90
userManager.allApplicationUsers.toList().each { user ->def loginfo = loginManager.getLoginInfo(user.username)
if (loginfo.getLastLoginTime() == null) {oldUsers.add(user.displayName)}else {def lastLogOn = new Date(loginfo.getLastLoginTime())def difference = today.minus(lastLogOn)if (difference >= threshold) {oldUsers.add(user.displayName)oldUsers.add(lastLogOn)}}}
return oldUsers

Sean Midkiff · Answer

Thank you for providing yours, I built off of it and wanted to share. This includes only active users, last active date limited to 60d, and created date. I wanted to find users idle for more than 60 days or never logged in, but wanted to make sure they weren't recently created first. import com.atlassian.jira.component.ComponentAccessor import com.atlassian.jira.security.login.LoginManager import com.atlassian.sal.api.component.ComponentLocator import com.atlassian.crowd.embedded.api.CrowdService import com.atlassian.crowd.model.user.TimestampedUser import java.text.SimpleDateFormat // Get required components def userUtil = ComponentAccessor.getUserUtil() def loginManager = ComponentAccessor.getComponentOfType(LoginManager.class) def groupManager = ComponentAccessor.getGroupManager() def crowdService = ComponentLocator.getComponent(CrowdService) // Define the groups to pull users from def adminGroup = groupManager.getUsersInGroup('jira-administrators') def sysadminGroup = groupManager.getUsersInGroup('system-administrators') def softwareGroup = groupManager.getUsersInGroup('jira-users') def extGroup = groupManager.getUsersInGroup('External') def addonGroup = groupManager.getUsersInGroup('atlassian-addons') def servGroup = groupManager.getUsersInGroup('Service Account') def intGroup = groupManager.getUsersInGroup('Integration Users') def auditGroup = groupManager.getUsersInGroup('External Auditors') def extsupGroup = groupManager.getUsersInGroup('External Support') // Combine groups into a unique list of users def users = (adminGroup + sysadminGroup + softwareGroup + extGroup + addonGroup + servGroup + intGroup + auditGroup + extsupGroup).unique() // Define a threshold: only include users whose last activity (last login or creation) is more than XX days old. Date threshold = new Date() - 60 // Set up a date formatter for display SimpleDateFormat df = new SimpleDateFormat("dd/MM/yy hh:mm") // Build the HTML output with embedded JavaScript StringBuilder builder = new StringBuilder() builder.append(""" Inactive Users

""") users.each { user -> // Only consider active users if (!user.active) { return } // Retrieve last login info (may be null if the user never logged in) def loginInfo = loginManager.getLoginInfo(user.username) Long lastLoginTime = loginInfo ? loginInfo.getLastLoginTime() : null Date lastLoginDate = lastLoginTime ? new Date(lastLoginTime) : null // Use CrowdService to capture the created date def crowdUser = crowdService.getUser(user.username) Date creationDate = (crowdUser instanceof TimestampedUser) ? crowdUser.getCreatedDate() : null // Determine the "last activity" date: if last login exists, use it; otherwise, use the created date Date lastActivityDate = lastLoginDate ?: creationDate // Only include users whose last activity is more than 60 days old. if (!lastActivityDate || lastActivityDate > threshold) { return } String createdText = creationDate ? df.format(creationDate) : "N/A" String lastActivityText = lastLoginDate ? df.format(lastLoginDate) : "Never Logged In" builder.append("") builder.append("") builder.append("") builder.append("") builder.append("") builder.append("") builder.append("") } return builder.toString()

User Name	Full Name	Email Address	Created Date	Last Activity
${user.username}	${user.displayName}	${user.emailAddress}	${createdText}	${lastActivityText}

Jakob KN · Answer

Hi Ram, thanks for your reply! I ended up using something slightly similar, returning users based on group membership and simply including all groups with application access. It includes Username, Full Name, Email Address, Last login and active status. Then returns it in a table that can be easily copied to excel or google sheets. This resolved both my initial question (since we can sort by login date in a sheet), and my question in the comment below. Adding it below in case someone comes across this post, and finds it useful in the future. import com.atlassian.jira.component.ComponentAccessor import com.atlassian.jira.security.login.LoginManager import java.text.SimpleDateFormat; import java.util.Date; import com.atlassian.jira.user.util.UserUtil UserUtil userUtil = ComponentAccessor.getUserUtil() def loginManager = ComponentAccessor.getComponentOfType(LoginManager.class) //def users=ComponentAccessor.UserManager.getAllApplicationUsers() def groupManager = ComponentAccessor.getGroupManager() def adminGroup = groupManager.getUsersInGroup('jira-administrators') def sysadminGroup = groupManager.getUsersInGroup('system-administrators') def softwareGroup = groupManager.getUsersInGroup('jira-users') def extGroup = groupManager.getUsersInGroup('External') def addonGroup = groupManager.getUsersInGroup('atlassian-addons') def servGroup = groupManager.getUsersInGroup('Service Account') def intGroup = groupManager.getUsersInGroup('Integration Users') def auditGroup = groupManager.getUsersInGroup('External Auditors') def extsupGroup = groupManager.getUsersInGroup('External Support') //def serviceDeskGroup = groupManager.getUsersInGroup('jira-servicedesk-users') def users = adminGroup + sysadminGroup + softwareGroup + extGroup + addonGroup + servGroup + intGroup + auditGroup + extsupGroup users.unique() StringBuilder builder=new StringBuilder() builder.append("") users.each{ Long lastLoginTime = loginManager.getLoginInfo(it.username).getLastLoginTime() String activeStatus=it.active if(userUtil.getGroupsForUser(it.getName()).size() == 0) //builder.append("") return else if(activeStatus=="false") builder.append("") else if(lastLoginTime==null) builder.append("") else{ Date date=new Date(lastLoginTime); SimpleDateFormat df2 = new SimpleDateFormat("dd/MM/yy hh:mm"); String dateText = df2.format(date); builder.append("") } } builder.append("

User Name	Full Name	eMail Address	Last Login	Status
"+it.username+"	"+it.displayName+"	"+it.emailAddress+"	No Group added	"+it.active+"
"+it.username+"	"+it.displayName+"	"+it.emailAddress+"	Inactive User	"+it.active+"
"+it.username+"	"+it.displayName+"	"+it.emailAddress+"	Logon not found	"+it.active+"
"+it.username+"	"+it.displayName+"	"+it.emailAddress+"	"+dateText+"	"+it.active+"

") return builder

Ram Kumar Aravindakshan _Adaptavist_ · Answer

Hi @Jakob KN

We have a similar script in the ScriptRunner Example Scripts page.

You will need to modify the code to suite your requirements.

Thank you and Kind regards,
Ram