Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

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

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

3 REPLIES
New Member

Re: IPCCE 7 - Webview - when I getting report an agent appears t

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?

New Member

Re: IPCCE 7 - Webview - when I getting report an agent appears t

sorry I am very basic on IPCC, how can i do the query ( SELECT * FROM ipcc_awdb.dbo.t_Agent ) ? please t

hanks

Andres

Green

Re: IPCCE 7 - Webview - when I getting report an agent appears t

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

267
Views
0
Helpful
3
Replies