cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
128
Views
0
Helpful
1
Replies
Beginner

Find active agents in a cluster

Hi 

Is there a way to find active agents from the past 6 months in an UCCE environment?

 

I have a list of all the users in ICM but it is not accurate as old users have not been cleaned up.

 

Thanks 

Everyone's tags (1)
1 REPLY 1
Collaborator

you can do that in many ways,

you can do that in many ways, one is below:

query HDS Agent_Event_Detail table for Event = 1 and whatever Date time you are looking for.

event = 1 is for event Login gets recorded table when agent logs in. 

you can extract skill target id from the output and actually gets the enterprise name of the agent from that by querying again  t_Agent table in AW.

 

below query will work if you have aw_db and HDS co-located

select EnterpriseName from <aw db instance>.dbo.t_Agent where SkillTargetID in (
Select SkillTargetID from Agent_Event_Detail where Event = '1' and DateTime > '2015-02-24')

 

 

the above will give name of all the agents logged in after '2015-02-24'

 

Chintan

 

CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards