Move Event and Macro Configuration Between Environments

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

Would like to move CA Service Desk Manager (CA SDM) Event and Macro data between two CA SDM environments.

What MDB tables need to be considered?

Environment

CA Service Desk Manager 17.x

Resolution

The following MDB tables are involved with CA SDM Event and Macros (SQL tables names are in parenthesis):

evt (Events)
splmac (Spell_Macro)
bpwshft (Workshift)
atomic_cond (Atomic Condition)
atyp_asc (Act_Type_Assoc)

The usage of pdm_extract and pdm_load commands is the recommended and supported mechanism to move data between CA SDM environments.

It is strongly recommended to take a database backup prior to making any changes and to test in a non-PROD environment first.