Service Desk Manager - Where can we find the Expiration Date field for CI Server Class in MDB?
Article ID: 190107
CA Service Management - Asset Portfolio Management
CA Service Management - Service Desk Manager
Question: Which table stores the field Expiration_Date for a Class Server (in example), in the following form:
Administration / CA CMDB / CI List / Tab 5 - Inventory / Expiration Date
Release : 17.x
Component : SERVICE DESK MANAGER
Run the command:
pdm_logstat -f sqlclass.c MILESTONE
and update the field in GUI
We can see in the log:
05/05 06:14:59.61 xxxxxx sqlagt:upinde 71132 MILESTONE sqlclass.c 1060 The following statement took 15 milliseconds: Clause (UPDATE usp_owned_resource SET nr_exp_dt = ? WHERE owned_resource_uuid = ?) Input (05/26/2020 06:14:00|716B69B7EBAFE741B141D54A904055E3)
So, the field is nr_exp_dt, the table is usp_owned_resource.