Report MYSQL Help

[hiadviser]

I am trying to create some custom reports for an outside client. I want to print out every record that was inbound from today's date.
I've tried from the vicidial_did_log table, but I keep getting a lot of duplicates. I first select the phone_number from the vicidial_log_table, then perform a lookup in the vicidial_lists table to find the rest of the customer information. But like I said, I'm getting a lot of duplicates. Not sure if there is another table I should be looking in or what. Has anyone done this before?

Any help is greatly appreciated. Thank you.

[retloc]

maybe try vicidial_closer_log if you have your inbound calls transferring to a ingroup.

I typically build my inbound reports with the following tables

vicidial_closer_log = queue information
vicidial_agent_log = agent time per lead worked
vicidial_lists = if I need to pull any saved lead detail

[hiadviser]

Ah, lifesave. vicidial_closer_log was what I needed. Thank you.