This document explains the importance of "Product id" and "Product key" in a CA Workflow install.
In R11, the MDB database is shared among different products. Several products employ CA Workflow and share the workflow tables. The following are the CA Workflow tables in MDB.
All the above tables may contain data from different products. The data is partitioned between each product by means of a unique value called the product id. All CA Workflow tables have a "productid" column, the value in it denotes which application uses it.
The list of possible product ids in an environment is available in "productids" table. The important columns to look at in product ids table are
"productkey": It is a unique identifier code for a specific product. The product id for CA Service Desk is "USD:2003". This key is post fixed with an integer that gets incremented each time Workflow is installed.
"description": General description of the embedding product
"productid": the value that is used to mark data in other tables (in the "productid" column) as owned by the application specified in "productkey".
If CA Service Desk is currently only application running CA Workflow in the MDB, then only one row will be available in the "productids" table (see Figure 1):
The definitions table show the "productid" of the ServiceDesk install (see Figure 2):