Good morning,

I am looking for a way to determine which users are inactive. 

With my setup, we have delegated the account management responsibilities a specific team. Unfortunately, we know this team is not staying up-to-date on employee departures, resulting in hundreds (potentially thousands) of inactive accounts.

I am wondering if there is a way for me to produce a report that identifies these accounts. In theory, this could be something as simple as a report identifying when the user last connected to Interaction Desktop. However, I am interested in any possible avenue that will produce the same result; the identification of inactive users. 

Please let me know your thoughts.

Thanks!

#PlatformAdministration

------------------------------
Patrick Ellis
Statistics Canada
------------------------------

You can use the LoginLogoutChangeLog table in the database to see who at least has a login event in some IC application in the last X number of days with a query similar to:

select distinct(UserId) from LoginLogoutChangeLog where ActionDateTime >'2024-06-01';

This will return a list of UserId's that had a login/logout event in since June 1 2024, 12:00am local timezone.

You can then compare that to your listing of active users in the system to generate a difference report then provide that to the team that should be doing this work to follow up and validate if those are still valid users or not.

------------------------------
Aaron Lael
State of Utah - comments on this forum reflect my own personal opinions\observations and are separate from any entity I am otherwise involved in.

Original Message:
Sent: 08-19-2024 10:48
From: Patrick Ellis
Subject: Identifying Inactive Users

Good morning,

I am looking for a way to determine which users are inactive. 

With my setup, we have delegated the account management responsibilities a specific team. Unfortunately, we know this team is not staying up-to-date on employee departures, resulting in hundreds (potentially thousands) of inactive accounts.

I am wondering if there is a way for me to produce a report that identifies these accounts. In theory, this could be something as simple as a report identifying when the user last connected to Interaction Desktop. However, I am interested in any possible avenue that will produce the same result; the identification of inactive users. 

Please let me know your thoughts.

Thanks!

#PlatformAdministration

------------------------------
Patrick Ellis
Statistics Canada
------------------------------