Source of truth for Agents / Skills

[kumar1396]

Hi,

I am working on creating some reports by pulling data from Avaya CMS db. I am using Synonym table to get the list of Agent's name or Skill name to show in the report. But what I noticed that not all the agents or skills entries are there in Synonym table.

I would like to know, is Synonym right table to look for all the agents and skills list? If not (which seems to be the case), can you please suggest other tables which can be the source of truth for all the agents and Skills?

Thanks,
Niraj

[tcanla]

There are limits to the duration that some of the transaction summary tables are allowed to hold data. The most time sensitive data is in the Hsplit and Hagent table where they can retained for a MAX of 62 days (your local site parameters might be set below that max number of days). There is NOTHING you can do to have rows older than 62 day be retained. And your system may be set to a shorter duration. To keep that data you must pull it out of CMS to a separate files or database.

[marzahn]

Split/Skill - Agent Table Source

Perhaps I do not understand the question. But my answer would be to run a list agent in ASA and export the result to a comma delimited file. This provides "raw date" with which, you can do anything.

[kumar1396]

Thanks for your response. Basically I am looking for a table in CMS database, from where I can get list of all the agents ID and name and split/skill ID and name?
When you mention ASA, do you mean Avaya Site Administration? Can you please suggest how do I do using ASA?

[marzahn]

Quick Data Dump from Avaya Site Admin (ASA)

Thanks for your response. Basically I am looking for a table in CMS database, from where I can get list of all the agents ID and name and split/skill ID and name?
When you mention ASA, do you mean Avaya Site Administration? Can you please suggest how do I do using ASA?

Sure can Kumar!
Open ASA.
Run the command: "list agent-loginID"
Click on the word "File" in the upper left corner.
From the drop-down menu select export.

I have attached a Job Aid I made in MS Word to explain the process to my teammates.