Claim your Biolink Click Here
0 like 0 dislike
18.4k views
Vicidial Login and Logout Agent time report is showing more hours than actual - Column (Agent Time)..Any idea?
in Education & Reference by (820 points) | 18.4k 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.6k points) | 1.9k views
1 like 0 dislike
1 answer
0 like 0 dislike
1 answer
asked Sep 28, 2018 in Education & Reference by Sam (1.6k points) | 433 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.6k points) | 743 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,310 questions
1,471 answers
569 comments
4,809 users