Navigation:  Integration via database > Published interfaces > Asset >

ASTCMDBINSERT - Add relationship - CMDB

Previous  Top  Next

This import template enables to add:

Relationships between CMDB objects.

 

To insert each of these items, it is necessary to follow the standard documented below.

Insert

Column

Required

Type

Precision

Description

OIDINTERFACE

X

TEXT

32

Sequential code - Identifies an item to be imported into SoftExpert Suite.

FGIMPORT

X

NUMERIC

2

Import status:

1 – New;

2 – In progress;

3 – Finished;

4 – Error.

CDISOSYSTEM

X

NUMERIC

10

System code where the integration will be performed to:

109 - Code of component SoftExpert Asset.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

25 – Add relationship;

NMFIELD01

X

TEXT

255

Source object type:

1 - Asset;

2 – Process;

3 – Process activity.

NMFIELD02

X

TEXT

255

Source object ID #

NMFIELD03

X

TEXT

255

Destination object type:

1 - Asset;

2 – Process;

3 – Process activity.

NMFIELD04

 

X

TEXT

255

Destination object ID #

NMFIELD05

X

TEXT

255

Relationship name

NMFIELD06

X

TEXT

255

Reverse relationship:

1 – Yes;

2 – No.

 

Note: It is not possible to add a relationship between processes, between activities or between processes and activities.