CA SDM Loading model pdm_load

Document created by TMACUL Champion on Aug 29, 2016Last modified by TMACUL Champion on Oct 7, 2017
Version 2Show Document
  • View in full screen mode

The first thing what you need know: VERY Important! Using pdm_load can be destructive so always back up your database before you perform a pdm_load, and use pdm_userload unless instructed to use pdm_load.

 

Important! Make a backup copy of the database before running pdm_load with this option. After old database records are removed, you must restore the CA SDM database with this backup copy if you want to recover any deleted records, use pdm_extract for this procedure.

 

1. BACKUP

 

BACKUP COMMAND
pdm_extract ca_model_def > modelt.txt

 

1. BACKUP GROUPS

Extract - groups
pdm_extract ca_model_def

 

2. Structure table

bop_sinfo -dq mfrmod
Factory mfrmod < ca_model_def >
Attributes:
id <model_uuid> UUID UNIQUE
producer_id LOCAL STRING(20)
persistent_id LOCAL STRING(60)
delete_flag inactive SREL -> actbool.enum REQUIRED
last_mod_dt last_update_date DATE
last_mod_by last_update_user STRING(64)
sym name STRING(100) REQUIRED
manufacturer manufacturer_uuid SREL -> ca_cmpny.id REQUIRED
model_name description STRING(255)
resource_class class_id SREL -> grc.id

 

.Description

TABLE ca_model_def
abbreviation class_id creation_date creation_user current_as_of_date del
ete_time
description exclude_registration family_id id inactive last_update_date
last_update_user manufacturer_uuid name operating_system preferred_selle
r_uuid
tenant version_number
{ "" ,"1000028" ,"08/24/2016 15:26:52" ,"uapmadmin" ,"" ,"" ,"" ,"",
"603" ,"BA2258408C071C45B2FDBB68B77FBA99" ,"0" ,"08/24/2016 17:25:47",
"ServiceDesk" ,"C73B4FF6B2C9C74B9A2048C6F5492D8B" ,"DELL OPTIPLEX 780" ,
"",
"" ,"" ,"0" }

1. Create loading_group.txt file
2. pdm_load -i  -f loading_group.txt

 

 

SQL Commands - Groups

select * from ca_model_def

 

 

Tiago Macul

 

 

 

DEREF - pdm_deref - Everthing do you need know

CA Service Desk Manager Load Category using pdm_load - pcat - Prob_Category - User view Prob_Ctg Category.xlsx

Is it possible  to extract and load  group information

 CA SDM pdm_load 537 Invalid character encountered in input - error /  CA SDM caractere inválido na carga - pdm_load -  Invalid character 

 

CA Service Desk Manager Load Category using pdm_load - pcat - Prob_Category - Prob_Ctg 

CA SDM Load department using pdm_load - dept - ca_resource_department 

CA SDM Loading contacts pdm_load    /   CA SDM carregando contatos ca_contact/usp_contact usando pdm_load 

CA Service Desk Manager Load Category using pdm_load - pcat - Prob_Category - Prob_Ctg  / Category.xlsx 

CA SDM Loading site 

CA SDM::. loading priority - pri 

Loading Survey - Survey_Answer_Template  - svy_atpl 

Loading Survey - survey_template svy_tpl 

Loading Survey - Survey_Question_Template  - svy_qtpl  

 

CA SDM Loading Change category 

CA SDM Loading location 

CA SDM loading Special Handling - VIP 

CA SDM Loading model pdm_load 

CA SDM::. position - ca_job_title 

CA SDM Loading groups pdm_load 

Root Cause - rootcause - rc / Causa raiz - 根本原因 - 

CA SDM Load department using pdm_load - dept - ca_resource_department 

 

 

Was this information helpful? Give your feedback.

1 person found this helpful

Attachments

    Outcomes