Avaya Support Forums  

Go Back   Avaya Support Forums > IP Office Contact Center

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 12-11-2015, 12:14 PM
carrai carrai is offline
Whiz
 
Join Date: Jun 2015
Posts: 40
carrai has 10 reputation points
Default How to get historical reports for deleted agents?

Hello everyone,
We have a IPOCC 9.1 working fine 6 months, during this period some agents left the company and they were deleted from the system. Now, when I tried to extract agents reports it just shows about active agents but no deleted agents appear in the list.
I tried creating the deleted agent again but its reports appear with no information.
Is there any way to get extract historical reports for deleted agents?

Thanks,
Reply With Quote
  #2  
Old 12-14-2015, 12:37 AM
kalpanaautade kalpanaautade is offline
Whiz
.
 
Join Date: Sep 2015
Posts: 32
kalpanaautade has 10 reputation points
Default

Deleted Agent data exist in cc and tr database but it cannot be recovered through IPOCC reports.
Reply With Quote
  #3  
Old 12-17-2015, 07:14 PM
carrai carrai is offline
Whiz
 
Join Date: Jun 2015
Posts: 40
carrai has 10 reputation points
Default

Thanks for the answer. In that case, is possible to connect to the database to get reports directly with a query?
Reply With Quote
  #4  
Old 12-17-2015, 10:37 PM
schopdekar schopdekar is offline
Whiz
.
 
Join Date: Aug 2015
Location: Pune, India
Posts: 40
schopdekar has 10 reputation points
Default

To connect directly to database, you can use "pgAdmin III" which ships with IPOCC.
You can launch it from Start Menu, under "Avaya IP Office Contact Center" -> PsogreSQL 9.3 -> "pgAdmin III"

The db password is needed to connect to the db. This is the same password which you provide during install/upgrade of IPOCC.
The data would be in cc database.
You would need to know the tables from which you would be extracting the data.
Reply With Quote
  #5  
Old 12-18-2015, 12:58 AM
kruegerb kruegerb is offline
Genius
.
 
Join Date: Oct 2013
Location: Stuttgart-Germany
Posts: 276
kruegerb has 12 reputation points
Default

reporting data (contact Details and Agent Status) for deleted Agent can be taken from database tr directly by SQL commands. In this database the Agent can be found by their names.
In database cc it is not possible to evaluate the reporting data for agents, they are stored with IDs, not with names. The Evaluation of the reporting data in cc database can only be done by the Server component statistic_Srv, not manually.
Reply With Quote
  #6  
Old 12-18-2015, 10:13 AM
carrai carrai is offline
Whiz
 
Join Date: Jun 2015
Posts: 40
carrai has 10 reputation points
Default

Quote:
Originally Posted by kruegerb View Post
reporting data (contact Details and Agent Status) for deleted Agent can be taken from database tr directly by SQL commands. In this database the Agent can be found by their names.
In database cc it is not possible to evaluate the reporting data for agents, they are stored with IDs, not with names. The Evaluation of the reporting data in cc database can only be done by the Server component statistic_Srv, not manually.
Then, is not possible to get reports for agents deleted because they left the company? is there any documentation that could give me more information?
Maybe we should not delete agents or set his state like disabel but I think that consume a license?
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 05:52 AM.

This Forum is provided solely for the use and convenience of Avaya customers and partners. Use of the Forum is subject to the Terms and Use and Privacy Statement found at www.avaya.com. No other use is permitted. The Forum including all content posted is “AS IS” and Avaya expressly disclaims all warranties and/or guarantees as to its accuracy, reliability, usefulness, quality or non-infringement of intellectual property. Avaya reserves the right to remove any content posted on the Forum at any time and for whatever reason.

Avaya will not be liable for any content posted on this Forum, including, without limitation, any errors or omissions or for any losses or damages of any kind incurred as a result of use or reliance on any content, regardless of its origin.

You expressly understand and agree that you assume all risks associated with use or reliance on this content.