[SOLVED] Find total number of outbound agents per day

[khuff]

So we're running a blended campaign and I wanted to know how many agents logged in with blended dialing enabled on Friday vs Today. I didn't see any report that would give me this info could you kindly point at a table I query for this info? Additionally is there a place I can look and see who is currently logged with blended dialing checked in real time? Going through each agent individually is time consuming when I have almost 70 agents logged in.

[mflorell]

There is no report currently that provides that specific information in summary.

That information would be stored in the vicidial_user_closer_log database table, and I'm sure a report could be made to provide that info.

[khuff]

Just to confirm an entry goes into that table every time a user logs in?

[mflorell]

An entry goes into that table every time an agent chooses their in-groups in the agent screen. Or, if the agent isn't allowed to choose their in-groups, an entry is inserted every time they log in.

[khuff]

Makes sense. Works like a charm. Here's the query if any people from the future need the same.

Code: Select all

SELECT DISTINCT count(*), date(event_date) FROM `vicidial_user_closer_log`
where date(event_date) = $date_to_search
and campaign_id = $campaign_id
and blended = '1';

Thanks a bunch for the quick reply.

[mflorell]

Thanks for posting your solution!