Fun at zangOOr Click Here
0 like 0 dislike
531 views
Vicidial Login and Logout Agent time report is showing more hours than actual - Column (Agent Time)..Any idea?
in Education & Reference by (640 points) | 531 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) | 940 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) | 187 views
0 like 0 dislike
1 answer
1 like 0 dislike
1 answer
2 like 0 dislike
1 answer
asked Jun 2, 2020 in Education & Reference by Sam (1.4k points) | 318 views

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,244 questions
1,398 answers
564 comments
4,809 users