App Usage Table Explanation

Abbey2
Tera Expert

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!

 

find_real_file.png

5 REPLIES 5

Have you found any solution to identify which users with roles do not use?