Is there any query or process to list all UCCE(ver 9) agents that have not been logged in for months?

[bill.king1]

You could run a query to look at any ID that has logged in during the time frame you want in something like agent_interval, then do an export of all of the agent IDs and see who is not on the list, and those would be the people who hadn't logged in.

[kamil0jmi]

Thank you for help.

If I use Agent_Interval table and search for complete month then it will show multiple entries of same agent multiple time because active agents logs in everyday.

Is there any way to find out last logout/login timestamp  of agents?

[bill.king1]

Sure, just look for the max DateTime in one of the DateTime fields and group by the Agent.

[kamil0jmi]

I used this script select Extension from Agent_Logout where LogoutDateTime >= '2017-11-01' to find agents who have logged in or logged out since November. I will compare this output with the list of all agents and the agents which I do not find matching with first list I will consider them inactive and delete them.

Do you agree with this approach?

[Chintan Gajjar · Accepted solution]

Hi,

Using Agent_Logout table:

Select DISTINCT p.FirstName,p.LastName,p.LoginName,a.PeripheralNumber,a.EnterpriseName,a.Description from Agent a,Person p where
a.PersonID = p.PersonID
and a. SkillTargetID not in
(select SkillTargetID from Agent_Logout where LogoutDateTime > '2017-01-01' )

Using Agent_Interval Table:

Select DISTINCT p.FirstName,p.LastName,p.LoginName,a.PeripheralNumber,a.EnterpriseName,a.Description from Agent a,Person p where
--a.PeripheralID = '5019' and
 a.PersonID = p.PersonID
and a. SkillTargetID not in
( select SkillTargetID from Agent_Interval where DateTime > '2017-01-01' )

The above query will give you the agents who has not logged into the system since '2017-01-01'.

don't do manual, when you can get it in minutes.