Service Desk Manager - Where can we find the Expiration Date field for CI Server Class in MDB?

Products

• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

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

Environment

Release : 17.x

Component : SERVICE DESK MANAGER

Resolution

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.