I want to create a report that has the Agent Name, Number of calls answered in an interval for a particular day. What all tables can I source the data from? If I have to create a similar report with Skills, which table can be used?

I would start with the CallDetail table. It usually has every detail I need. If you don't need the detail, there is a view called IAgentQueueStats that provides half hour summary by agent, workgroup name, and nAnsweredACD. Phoebe

It is difficult to account for calls that are transferred or escalated using the CallDetail table. I would recommend the IAgentQueueStats for ACD calls.