The "usp_kpi" (Key Performance Indicator) tables are listed in the documentation as:
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:
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.
Release: SDMU0M99000-14.1-Service Desk Manager-Full License