How to get historical reports for deleted agents?

[carrai]

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,

[kalpanaautade]

Deleted Agent data exist in cc and tr database but it cannot be recovered through IPOCC reports.

[carrai]

Thanks for the answer. In that case, is possible to connect to the database to get reports directly with a query?

[schopdekar]

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.

[kruegerb]

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.

[carrai]

Originally Posted by kruegerb

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?