Ways to audit active users / clients?

[Rosa M Fossi]

Hello Community,

I've been trying to find a way to audit which users are active, and which are not. The Admin section "users" does not yield the right information. 

Scenario: We have users that have accounts, but no licenses (we have a valid / atlassian-support-guided reason as to why our clients are added to our instance this way).   These clients access our instance via Service Mgmt portal to open tickets.  

The problem is that their portal activity (opening tickets, commenting on tickets) does not register as Activity in the Atlassian logs.  In fact, their "last seen on" dates are often their initial signup date.   The attached example is how a user appears to me in the admin panel.  I know for a fact that client opened a ticket this morning.

I have no way to tell which of these accounts is actually active / has logged into the portal.  A support agent previously suggested using "an activity stream" as a work around, but that solution isn't (for so many reasons)...  I can't check those on the fly since Activity Streams aren't retroactive, I'd have to wait until that user acted before the stream showed anything;  and obviously, I shouldn't have to create a board with every single user ID in a stream!  Even if I did, I don't know how I would even begin to audit that.  :| 

Leadership is asking for a list of inactive users, and I simply can't see myself checking all 70+ client accounts manually each time they ask for this.  HALP!

[C_ Derek Fields]

There is a recently created Jira Cloud ticket for this: https://jira.atlassian.com/browse/JRACLOUD-76982 - Unfortunately, I doubt that Atlassian will do anything about it

[Bloompeak Support]

Hi @Rosa M Fossi ,

As an alternative, you can try Manage Users for Jira app developed by our team. It displays all users details in a single page in which you can see last activity dates. Hope it helps.

[Rosa M Fossi]

Hi Bloomspeak,

Can you confirm what criteria is used to determine your "Since Last Activity" column?   

My problem is the users I'm trying to audit do not interact with tickets by logging into the instance. They have accounts and are added to groups, but they hold no licenses and interact only via the portal (they create tickets, and comment on them).  

[Bloompeak Support]

Hi Rosa,

It is taken from Atlassian over Rest APIs. Therefore, it is the same that is displayed in each user detail.

[Hyrum Steffensen _Appfire_]

Hello Rosa,

You can get the "active" status of a user by using this Atlassian REST endpoint.

Since you are interested in getting the information for multiple accounts, consider using a scripting solution as found on the Atlassian Marketplace such as Power Scripts. Here is an example script using Power Scripts:

string user = "charlie";

struct StructValues { 
    boolean active; 
}

HttpRequest request; 
request.headers += httpCreateHeader("Content-Type", "application/json"); 
request.headers += httpBasicAuthHeader("admin", APIKEY); 
// create API KEY here: https://id.atlassian.com/manage/api-tokens

StructValues structValues = httpGet("http://example.atlassian.net/rest/api/3/user?username=" + user, request);

runnerLog(structValues.active);

With a script, you can loop through a list of users and output their status. Please note that I tested this script on a Jira Server environment, so I would imagine you would need to use the user key when using Jira Cloud. For example:

string [] users = "5b10a2844c20165700ede21g|5b10a2844c20165700ede21g|5b10a2844c20165700ede21g";

for (string user in users) {
    // use REST API from above here
}

 For more information on using httpGet(), see this documentation.

Again, this can be accomplished by using any scripting solution on the Atlassian Marketplace that supports REST or something like Node.js.

Regards,

Hyrum 

Due to Confluence Cloud security features, you may need to open the documentation posted in incognito mode or by logging out of Confluence.

Please note that I am a product engineer for Power Scripts and that I work for Anova Apps, an Appfire company.

[Rosa M Fossi]

Thanks for the suggestion (and the disclosure) Hyrum. 😄

It's worth looking into!

[Hyrum Steffensen _Appfire_]

Sure thing, Rosa! Please let us know how you implement the solution. If you have a different scripting solution we could post an example in that language (such as Groovy).

Regards,

Hyrum