Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Symposium on Caché server

Status
Not open for further replies.

ryock2000

Programmer
Jun 23, 2015
4
CA
Hi,

I have access to CCMS_STAT database, but my user don't have access to run "SELECT DISTINCT SqlSchemaName from %dictionary.compiledclass".

would someone be kind to supply the table names.

I know all the "application" related tables, but I'm interested in the "skill" ones.

I need to pull config-data from IEX and Symposium server at skill level, since the grouping is different in both system.

Thanks.
 
Table views in AACC6.4
iSkillsetStat, • dSkillsetStat, • wSkillsetStat, • mSkillsetStat
iAgentBySkillsetStat, • dAgentBySkillsetStat, • wAgentBySkillsetStat, • mAgentBySkillsetStat

i = interval, d = daily, w = weekly & m = monthly

If your unsure, go onto the Avaya web site and look for the Performance Management Data Dictionary - contains everything about reporting.
 
Hi,

thanks, but there's no table that maps the relation application-skill ?
 
There is no application to skillset configuration data in a table. The connection comes through the script when an application processes a queue to a skillset command. At that point the skillset data is written, and the application is identified in the skillset table.

In the performance management data dictionary guide each table lists linkage tables at the end of the chapter.

I hope this helps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top