The "usp_kpi" (Key Performance Indicator) tables are listed in the documentation as:
- usp_kpi Table
- usp_kpi_data Table
- usp_kpi_ticket_data Table
Normally, these documented table names may be used with CA Service Desk Manager tools such as "pdm_extract."
However, attempting to use the above table names will fail with "not a recognizable table" messages:
usp_kpi is not a recognizable table.
usp_kpi_data is not a recognizable table.
usp_kpi_ticket_data is not a recognizable table.
This problem is in all current documentation for CA Service Desk Manager and IT Service Management.
It is not tied to a specific operating system, database, browser or other environment element.
This is a documentation error.
A CA Support issue has been opened to correct new documentation and the CA Wiki.
The correct table names to use are as follows:
- usp_kpi Table >> Kpi Table
- usp_kpi_data Table >> Kpi_Data Table
- usp_kpi_ticket_data Table >> Kpi_Ticket_Data Table
Note that these table names are case sensitive.
Here is an example showing that these names are recognised:
<<12 rows removed for example>>
Data Element Dictionary contains the relationships between these data structures for ITSM 14.1.
CA Support for logging an issue about incorrect documentation or for assistance with data structures, tools, and more.
Wiki for CA Service Management - 14.1 has all of the product documentation for ITSM 14.1.
CA Communities for CA Service Management – Ask a question, discuss with other customers and sites, find out latest information and more.