0 like 0 dislike
12 views
Vicidial Login and Logout Agent time report is showing more hours than actual - Column (Agent Time)..Any idea?
in Education & Reference by (520 points) | 12 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.3k points) | 405 views
1 like 0 dislike
1 answer
0 like 0 dislike
1 answer
asked Sep 28, 2018 in Education & Reference by Sam (1.3k points) | 83 views
0 like 0 dislike
1 answer
0 like 0 dislike
2 answers
asked Jul 3, 2018 in Education & Reference by Sam (1.3k points) | 241 views
0 like 0 dislike
0 answers
asked Jun 13, 2018 in Education & Reference by Sam (1.3k points) | 60 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,202 questions
1,347 answers
553 comments
1,994 users