IPCCE 7 - Webview - when I getting report an agent appears twice

Unanswered Question

Hi All,

I was having a problem with an agent's name being in the Cisco database twice. In order to get any data for him I have to select both names. If I select just either one of them then there is no data available.

Prevously  I gave to this agent a new phone extension at Callmanager and IPCC staff , so was wondering if I could take out his name that is still associated with his old extension? Where do I have to find? I need leave only the new extension.

Thanks for your inputs

Andres

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
sebastiaanv Tue, 03/30/2010 - 12:53

What happens if you run the following query on the AW and look for the agent?

SELECT * FROM ipcc_awdb.dbo.t_Agent

Is it listed twice?

Login to the AW (either directly or remotely using VNC or MSTSC), open Microsoft SQL Query Analyzer, select the AW database from the drop down list, and type in the command and press "Execute".

If this is beyond you, do some reading on the Web about using Microsoft Query Analyzer. You really should have basic SQL skills to maintain and administer IPCC, so don't be afraid to start now.

Regards,

Geoff

Actions

This Discussion