Can I use Explore to find out the last time agents signed in and to identify agents that have been inactive for a while? Can I create an Agent Login Aging Report to show agents that have signed in, in the last 30 days, 60 days and 90 days?
I'd like to keep track of inactive agents to make sure I'm not paying for agent seats take up by inactive accounts.
To report on when an agent last signed in to Zendesk you can use the metric Time since user login in the Tickets dataset. Make sure to add a filter for the Assignee role to exclude end-users from your query. Learn other ways to generate a list of the last time users signed in, in this article: How do I generate a user's last login date list?
If you would like to group the sign-in dates into bracketed time frames, you can create a Date range calculated metric for each bracketed time frame. For example, create one Date range calculated metric based on the original metric Time since user login for between 0 days ago and 30 days ago, another for between 31 days ago and 60 days ago, and a third for between 61 days ago and 90 days ago.
For more information, see the article: How do I report on user data in Explore?