App Usage Table Explanation

[Abbey2]

I came across the ua_app_usage table in servicenow to track user usage count of applications in servicenow. Is anyone able to explain what the fields represents and in particular, 

 - How is access count incremented?

- What constitutes fulfillment count?

I'm also looking to write a job that checks this table weekly, gets users who havent met a set threshold of access count within a time frame and revoke their access.

Would appreciate any comments on this!

[Jeff Currier]

You can figure out some of the meaning from this doc page.

I believe access account is people reading any table from that application.  You can add Tables_Accessed to the form view which helps that make more sense.

Fulfillment count is the number of activities which would require a fulfiller role.  Basically the sum of the Insert, update and delete activities.

Utilizing the Application Usage Overview reports is likely easier than directing this table.

As an interesting note: you will also see Producer count where you see Fulfiller count.  This depends non the application.

[Tony K]

Could you just use the last login time off the user record or do you need to know by application? If a user isn't logging in, then they aren't using any application. 

[Abbey2]

I've tried that, however, they are users who login to other non itil applications , but have itil roles (even though they aren't fulfillers). Challenge is the roles were earlier so generously to even those who don't need them, i'm trying to isolate those who have the roles but do not access fulfiller applications and revoke access

[cynlink1]

@Abbey2 - I am looking for the same solution. Were you able to figure out a way to do it?