Unable to run pdm_extract on the "usp_kpi" (Key Performance Indicator) tables.

Document ID : KB000032424
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem:

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:

C:\>pdm_extract usp_kpi

usp_kpi is not a recognizable table.

C:\>pdm_extract usp_kpi_data

usp_kpi_data is not a recognizable table.

C:\>pdm_extract usp_kpi_ticket_data

usp_kpi_ticket_data is not a recognizable table.

 

Environment:

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.

 

Cause:

This is a documentation error.
A CA Support issue has been opened to correct new documentation and the CA Wiki.

Resolution:

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:

C:\>pdm_extract Kpi_Ticket_Data

Kpi_Ticket_Data

<<12 rows removed for example>>

        rows:12

 

 

Additional Information:

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.