Author Topic: Old data still showing in reports  (Read 2345 times)

hwjustin

  • Newbie
  • *
  • Posts: 16
  • Karma: 0
    • View Profile
Old data still showing in reports
« on: December 11, 2009, 19:42:06 »
Before going live with my QM install, I cleared the the file /var/log/asterisk/queue_log and the queue_log table in MySQL. However, when I run reports, specifically on Agent Availabilty, I see old data included 100+ hours of login time when the 'live' operation hasn't even been up that long. How can I truncate the data to show only the relevant data since going live?

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Old data still showing in reports
« Reply #1 on: December 14, 2009, 12:42:51 »
If Qm shows it, it's either in the queue_log table (if you use mysql storage) or in the local queue_log file.

hwjustin

  • Newbie
  • *
  • Posts: 16
  • Karma: 0
    • View Profile
Re: Old data still showing in reports
« Reply #2 on: December 14, 2009, 15:19:53 »
Upon second check, you are correct. There was a leftover line the queue_log that threw off the agent data. I removed it from the queue_log and the corresponding SQL table. All is fixed. Thanks!  :)

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Old data still showing in reports
« Reply #3 on: December 16, 2009, 11:40:07 »
 ;D