Troubleshooting guide

230 Avaya CMS Supervisor Report Designer
How CMS retrieves data
This section includes the following topics:
● Three types of information on page 230
● How to tell CMS to retrieve data on page 230
● Identify rows on page 230
● Indexes for search on page 231
● About creating new database tables on page 231
Three types of information
CMS retrieves data from the database based on the following types of information that you
supply when you design a report:
● The name of the table
● The database items in the table
● The rows of data in the table
How to tell CMS to retrieve data
To tell CMS how to retrieve data, you must tell CMS to access the appropriate database
table. Then, for each report field, you assign the appropriate database items. When you
run the report, CMS will find in the table the columns of data associated with the database
items.
Identify rows
Next, you identify the appropriate rows that supply data. If you want agents in Split 1, you
must tell CMS to find rows that have the value 1 for the SPLIT database item. When you
run the report, CMS finds the appropriate rows of data in the cagent table.