What are the differences in the MDB schema for CA Service Desk Manager (CA SDM) 12.9 with cumulative patch 1 and CA SDM 14.1 with cumulative patch 1?

Document ID : KB000056954
Last Modified Date : 14/02/2018
Show Technical Document Details

Scenario

You have an environment with the out-of-the-box CA Service Desk Manager 12.9 Cumulative #1 installed, and another environment with the out-of-the-box CA Service Desk Manager 14.1 Cumulative #1 installed, and you need to know the differences in the MDB schema between these two environments.

Solution

Compare the $NX_ROOT\site\ddict.sch files from the two environments.

The results from that comparison would show the differences described below.

Comparison of 12.9 Cum#1 to 14.1 Cum#1+Hyper
Note: There is a Hyper patch required if your CA SDM 14.1 has Cumulative patch #1 applied.
 
Columns added to existing tables for 14.1+Cum1+hyper:


 For "TABLE Notify_Log_Header":
retry_count INTEGER ;

For "TABLE Change_Request":
usm_request_id INTEGER ;
usm_request_itemid INTEGER ;

For "TABLE Prob_Category":
flow_flag_in INTEGER ;
flow_flag_pr INTEGER ;
caextwf_start_id_in INTEGER REF usp_caextwf_start_forms ;
caextwf_start_id_pr INTEGER REF usp_caextwf_start_forms ;
caextwf_split_flag INTEGER ;

For "TABLE Attached_SLA":
_mapped_cr_wf INTEGER REF Request_Workflow_Task ;

For "TABLE app_esx":
ProcessID INTEGER ;
AccessedViaTcpPort INTEGER ;
ProcessDistinguishingID STRING 256 ;

For "TABLE app_hyp":
ProcessID INTEGER ;
AccessedViaTcpPort INTEGER ;
ProcessDistinguishingID STRING 256 ;

For "TABLE har_stgvol":
ContextID STRING 256 ;

For "TABLE ci_twa_ci":
DeviceIPV4Address STRING 64 ;
DeviceIPV4AddressWithDomain STRING 256 ;
DeviceIPV6Address STRING 40 ;
DeviceIPV6AddressWithDomain STRING 256 ;
OSNumeric INTEGER ;
ContainingIndex INTEGER ;
IsPhysical INTEGER ;
ContextID STRING 256 ;
DeviceAssetNumber STRING 64 ;
DeviceBiosSystemID STRING 256 ;
DeviceDnsName STRING 256 ;
DeviceSysName STRING 256 ;
DevicePhysSerialNumber STRING 64 ;
DeviceMacAddress STRING 64 ;
FilePathUrl STRING 1024 ;
SizeInMB STRING 15 ;
ProcessID INTEGER ;
AccessedViaTcpPort INTEGER ;
ProcessDistinguishingID STRING 256 ;
SpeedInGHz STRING 15 ;
capabilities STRING 512 ;
ContextType STRING 64 ;
ApiVersion STRING 64 ;
CapacityInMB STRING 15 ;
IsMultiHost INTEGER ;
OSDriveName STRING 64 ;
IsBootable INTEGER ;
IsPrimary INTEGER ;
IsMigrationEnabled INTEGER ;
ComputeResourceIndex STRING 256 ;
HostIndex STRING 256 ;
DatacenterPath STRING 512 ;
FTVersion STRING 64 ;
NumberOfPrimaryVMs INTEGER ;
NumberOfSecondaryVMs INTEGER ;
DefaultExternalDataRoot STRING 1024 ;
DefaultVhdPath STRING 1024 ;
MinimumMacAddress STRING 64 ;
MaximumMacAddress STRING 64 ;
IsHAEnabled INTEGER ;
IsMonitoringMembers INTEGER ;
MaxFailures INTEGER ;
MemberCriteria STRING 512 ;
GroupType STRING 64 ;
HomePage STRING 2048 ;
BusinessRelevance STRING 2048 ;
CapacityInGB STRING 15 ;
RaidLevel STRING 64 ;
LogicalUnitNumber INTEGER ;
PortID STRING 256 ;
PortWWName STRING 24 ;
IsThinlyProvisioned INTEGER ;
IsDeDupeEnabled INTEGER ;
IsMasked INTEGER ;
MaskedWWNames STRING 1024 ;
service_impact INTEGER ;

For "TABLE usp_contact":
cost REAL ;
currency_type INTEGER REF usp_currency ;

 

Tables added for 14.1+Cum1+hyper:


 TABLE usp_lrel_attachments_nr {
id INTEGER UNIQUE KEY ;
nr UUID REF ca_owned_resource ;
attmnt INTEGER REF Attachment ;
last_mod_dt LOCAL_TIME ;
last_mod_by UUID REF ca_contact ;
tenant UUID REF ca_tenant ;
}

TABLE usp_currency {
id INTEGER UNIQUE KEY ;
last_mod_dt LOCAL_TIME ;
last_mod_by UUID REF ca_contact ;
country STRING 512 ;
currency_type_code STRING 3 ;
description STRING 256 ;
in_use INTEGER ;
name STRING 64 ;
symbol STRING 16 ;
version_number INTEGER ;
}

TABLE usp_itsm_msg_queue {
id INTEGER UNIQUE NOT_NULL KEY ;
status INTEGER NOT_NULL ;
timestamp LOCAL_TIME ;
msg STRING 6192 ;
node STRING 256 ;
retries INTEGER ;
type INTEGER ;
product STRING 64 ;
col1 STRING 256 ;
col2 STRING 256 ;
col3 STRING 256 ;
col4 STRING 256 ;
last_mod_by UUID REF ca_contact ;
last_mod_dt LOCAL_TIME ;
}

TABLE Request_Workflow_Task LARGE {
id INTEGER UNIQUE NOT_NULL KEY ;
persid STRING 30 ;
del INTEGER NOT_NULL ;
object_type STRING 30 NOT_NULL ;
object_id STRING 30 NOT_NULL ;
task STRING 12 NOT_NULL REF Task_Type ;
wf_template INTEGER REF Workflow_Task_Template ;
sequence INTEGER NOT_NULL ;
status STRING 12 REF Task_Status ;
group_task INTEGER NOT_NULL ;
asset UUID REF ca_owned_resource ;
creator UUID REF ca_contact ;
date_created LOCAL_TIME ;
assignee UUID REF ca_contact ;
group UUID REF ca_contact ;
support_lev STRING 30 REF Service_Desc ;
done_by UUID REF ca_contact ;
start_date LOCAL_TIME ;
est_completion_date LOCAL_TIME ;
completion_date LOCAL_TIME ;
est_duration DURATION ;
actual_duration DURATION ;
est_cost INTEGER ;
cost INTEGER ;
description STRING 1000 ;
last_mod_dt LOCAL_TIME ;
last_mod_by UUID REF ca_contact ;
tenant UUID REF ca_tenant ;
}

 Other additions in ddict.sch for 14.1+Cum1+hyper:

 

 p1 usp_lrel_attachments_nr -> CURR_PROV usp_lrel_attachments_nr ;

_mapped_cr_wf -> mapped_cr_wf {
ingres -> _mapped_cr_wf ;
}

p1 usp_currency -> CURR_PROV usp_currency ;

p1 usp_itsm_msg_queue -> CURR_PROV usp_itsm_msg_queue ;

p1 Request_Workflow_Task -> CURR_PROV crwf {
group -> group_id ;
est_completion_date -> est_comp_date ;
}

TABLE_INFO usp_lrel_attachments_nr {
INDEX SORT ASCENDING nr ;
INDEX SORT ASCENDING attmnt ;
INDEX SORT ASCENDING tenant ;
INDEX SORT ASCENDING UNIQUE ( ORDER_BY ) nr attmnt ;
}

For TABLE_INFO Attached_SLA:
INDEX SORT ASCENDING _mapped_cr_wf ;

TABLE_INFO Request_Workflow_Task {
INDEX SORT ASCENDING UNIQUE ( ORDER_BY ) object_id sequence ;
INDEX SORT ASCENDING assignee ;

 

 

 

Changes in ddict.sch for 14.1+Cum1+hyper:

Changed in 14.1+Cum1+hyper to: 

  INDEX SORT ASCENDING UNIQUE ( ORDER_BY ) object_type object_attrname object_attrval sequence ; 

from 12.9+Cum1: 

   INDEX SORT ASCENDING UNIQUE ( ORDER_BY ) object_attrname object_attrval sequence ;