Symposium on Caché server

[ryock2000]

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.

 

[km1066]

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.

 

[ryock2000]

Hi,

thanks, but there's no table that maps the relation application-skill ?

 

[effort1584]

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.