0 like 0 dislike
158 views
Vicidial Login and Logout Agent time report is showing more hours than actual - Column (Agent Time)..Any idea?
in Education & Reference by (630 points) | 158 views

1 Answer

0 like 0 dislike
Best answer

You can get the data from the database by the below query which will show you the first login and last logout and tell you the difference in hours min sec

select  User,startdate as fromDate , enddate as toDate, TIMEDIFF(a.enddate, a.startdate) as LoginTtime from (select user, min(event_date) as startdate, max(event_date) as enddate from vicidial_user_log
where event_date >= '2020-02-07 0:00:01' and event_date <= '2020-02-07 23:59:59' group by user) a
by
selected by

Related questions

0 like 0 dislike
1 answer
0 like 0 dislike
3 answers
asked Jan 20, 2014 in Education & Reference by Sam (1.4k points) | 619 views
1 like 0 dislike
1 answer
0 like 0 dislike
1 answer
asked Sep 28, 2018 in Education & Reference by Sam (1.4k points) | 122 views
0 like 0 dislike
1 answer
1 like 0 dislike
1 answer
asked Jun 2, 2020 in Education & Reference by Sam (1.4k points) | 140 views
1 like 0 dislike
1 answer

Where your donation goes
Technology: We will utilize your donation for development, server maintenance and bandwidth management, etc for our site.

Employee and Projects: We have only 15 employees. They are involved in a wide sort of project works. Your valuable donation will definitely boost their work efficiency.

How can I earn points?
Awarded a Best Answer 10 points
Answer questions 10 points
Asking Question -20 points

1,227 questions
1,375 answers
559 comments
2,099 users