The ETL Export database is based on a predefined schema that is not to be changed but populated with data.

The schema is graphically represented here ETL Export Database Schema (Latest)

Info

Please make sure to understand the Database Information State for the ETL import database. The information state is important since it is used for "bookkeeping" of data in the data base

 

Description of Tables, Relations and Classifications

Table: SCHEMA_VERSION

The SCHEMA_VERSION table contains only one record which is used to indicate the version of this database schema.
The current schema-version is 1.0.0, as can be seen in the overview found below 

Version

StruxureWare Data Center Operation Version

Description

1.0.0

7.3.0, 7.4.0, 7.4.5, 7.5, 8.0

Initial schema design for the StruxureWare Data Center Operation ETL feature


The schema version is used by the StruxureWare Data Center Operation server for validation of the ETL setup. 

Table: CONFIGURATION_ITEM

The table will contain a complete list of equipment in the datacenter model. This represents StruxureWare Data Center Operation's view of the datacenter.

CONFIGURATION_ITEM 

Field

Datatype

Description

Sampledata

ci_id

varchar(36)

Unique identifier of item (primary key). This is a UUID.

"550e8400-e29b-41d4-a716-446655440000"

ci_type

varchar(64)

Specifies the type of this item in a readable form.

Server

ci_parent_id

varchar(36)

Reference to the item which is the parent of this item. Represents the physical relationship location-room-row-cage-rack-server. 

 

ci_manufacturer

varchar(255)

Manufacturer of equipment as known by the StruxureWare Data Center Operation model

 

ci_model_name

varchar(255)

The equipment model information/name

 

ci_part_number

varchar(255)

Part number of equipment

 

ci_name

varchar(255)

Name ofequipment

 

ci_description

varchar(255)

Description for equipment

 

ci_barcode

varchar(255)

Single barcode for equipment

 

ci_install_date

date

Date of installation in the data center

 

ci_u_position

int

If the piece of equipment is rack mounted, this will contain the top U position of the equipment.

31

ci_u_height

int

If the equipment is mounted in a rack, this will contain the height of the equipment measured in (rack) units.

 

ci_mounting

varchar(64)

For rack mounted equipment, this will show whether the equipment is mounted in the front, back or sides of the rack

 

ci_last_log_entry_time

long Timestamp indicating when a change related to this configuration item has been recorded  
ci_last_log_user_id varchar(64) User responsible for the last change recorded on this configuration item  

ci_power_draw

double

If a power draw (Adjusted Nameplate) is known it will be stored here

 

ci_max_power_draw double If Manufacturer's Nameplate is set  

ci_power_redundancy

varchar(16)

Any known redundancy information will be stored in this field

 

ci_status

varchar(255)

Indicate the status of an equipment in the change module. Possible values are "EXISTING", "PENDING DELETE", "PENDING MOVE", "PENDING ADD", "PLANNED"

 

ci_logic_name

varchar(255)

The logic name of the equipment

 

ci_rack_uuid

varchar(36)

If the equipment is placed in a rack, this field will contain the UUID of the rack

"550e8400-e29b-41d4-a716-446655440000"

ci_rack_label

varchar(255)

If the equipment is placed in a rack, this field will contain the name of the rack

 

ci_room_uuid

varchar(255)

This field will contain the UUID of the room in which the equipment is placed

"550e8400-e29b-41d4-a716-446655440000"

ci_room_label

varchar(255)

Contains the name of the room where the equipment is placed.

 

ci_row_label

varchar(255)

Contains the label of the row in which the equipment is placed – if any

 

ci_location

varchar(255)

The "complete" location string that indicates the placement of the equipment.

 

ci_serial_number varchar(255) If a Serial number is provided on the device in the properties section  
ci_floor_coordinate_x varchar(255)

The equipment floor tile X coordinate (from 8.0.1)

A
ci_floor_coordinate_y varchar(255) The equipment floor tile Y coordinate (from 8.0.1)

1

ci_subtype varchar(255) The equipments subtype (from 8.2.0) Server

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed,

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 




Table: CONFIGURATION_ITEM_PROPERTY

In the StruxureWare Data Center Operation data model, a DataCenterItem can have DataCenterProperties associated. These are listed in the CONFIGURATION_ITEM_PROPERTY table.

CONFIGURATION_ITEM_PROPERTY

Field

Datatype

Description

Sampledata

ci_id

varchar(36)

Identifier of item. The ci_id field is a foreign key to CONFIGURATION_ITEM

"550e8400-e29b-41d4-a716-446655440000"

cip_name

varchar(255)

The name of the property.

"servicetag"

cip_value

varchar(255)

Value of property.

"KN20623BY9"

cip_type

varchar(255)

Specifies the type of this property.

 

cip_class

varchar(64)

Specifies the class of this property.

 

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 



Table: CONFIGURATION_ITEM_TAG

Any tags associated with the items in CONFIGURATION_ITEM, are exported to CONFIGURATION_ITEM_TAG.
No information about relationship between tags (grouping) is exported. 

CONFIGURATION_ITEM_TAG

 

 

 

Field

Datatype

Description

Sampledata

ci_id

varchar(36)

Identifier of item. The ci_id field is a foreign key to CONFIGURATION_ITEM

"550e8400-e29b-41d4-a716-446655440000"

cit_tag

varchar(255)

The name of the tag.

"sales"

cit_description

varchar(255)

Descriptionof property.

"Equipment supporting the sales team"

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 

 

Table: CONFIGURATION_ITEM_POWER_PATH

Any power path associated with the items in CONFIGURATION_ITEM, are exported to CONFIGURATION_ITEM_POWER_PATH.

CONFIGURATION_ITEM_POWER_PATH

Field

Datatype

Description

Sampledata

pp_id varchar(36)   "09899e3400-e29b-41d4-a716-89373538282"
pp_average_power varchar(255)  

"#L1:103.92304845413264 #L2:NaN #L3:72.74613391789285,"

pp_breaker_derating double   "0.8"
pp_breaker_label varchar(36)   "label-24"
pp_breaker_module_number Integer    
pp_breaker_module_size Integer    
pp_breaker_panel_circuit_number Integer   "12"
pp_breaker_size Integer   "3"
pp_breaker_poles Integer   "3"
pp_breaker_power_phase varchar(16)   "L1_L2_L3"
pp_breaker_rating double   "30.0"
pp_breaker_panel_label varchar(255)   "Panel A"

ci_id

varchar(36)

Identifier of item. The ci_id field is a foreign key to CONFIGURATION_ITEM

"550e8400-e29b-41d4-a716-446655440000"

ci_name

varchar(255)

Name of the configuration_item

"PDU 2"

ci_type

varchar(64)

Type of configuration_item

"RackMountPdu"

ci_parent_X_id varchar(36) Identifier of the X level item in power path. X goes from 1 to max. 11 (depending on what number the chosen item is in the power path) "550e8400-e29b-41d4-a716-446655445090"
ci_parent_X_name varchar(255) Name of the X level item in power path. X goes from 1 to max. 11 (depending on what number the chosen item is in the power path) "UPS-1"
ci_parent_X_type varchar(64) Type of the X level item in power path. X goes from 1 to max. 11 (depending on what number the chosen item is in the power path) "Ups"
pp_peak_power varchar(255) Peak power of the item in the power path "#L1:103.92304845413264 #L2:NaN #L3:72.74613391789285,"
pp_redundancy varchar(16)    
pp_predicted_peak_power varchar(255) Predicted peak power of the item in the power path "#L1:110.76534433413267 #L2:NaN #L3:82.74613391789285,"
pp_peak_amps varchar(255) Measured peak amps of the item in the power path "#L1:10.392304845413264 #L2:NaN #L3:7.274613391789285,"

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 



Table: CUSTOM_PROPERTY

Any CustomProperties associated with the equipment in the CONFIGURATIONS_ITEM table, are stored in the CUSTOM_PROPERTY table. 

CUSTOM_PROPERTY

 

 

 

Field

Datatype

Description

Sampledata

ci_id

varchar(36)

Identifier of item. The ci_id field is a foreign key to CONFIGURATION_ITEM 

"550e8400-e29b-41d4-a716-446655440000"

cp_name

varchar(255)

The name of the property.

"servicetag"

cp_value

varchar(255)

Value of property.

"KN20623BY9"

cp_type

varchar(255)

This value indicates the type of the property value

 

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 



Table: SWO_KPI

StruxureWare Data Center Operation creates many different KPI's (key performance indicators) for the datacenter when running.
The newest KPI's are exported to the StruxureWare Data Center Operation_KPI table. 

SWO_KPI

Field

Datatype

Description

Sampledata

kpi_id

varchar(255)

Identifier of KPI (primary key).

"550e8400-e29b-41d4-a716-446655440000"

ci_id

varchar(36)

Identifier of item. The ci_id field is a foreign key to CONFIGURATION_ITEM 

"550e8400-e29b-41d4-a716-446655440000"

kpi_serie_type

varchar(64)

Indication of the type of KPI (ETL Export Database)

"total_free_u_positions"

kpi_value_type

varchar(64)

Type of the value for the KPI

217

kpi_value

varchar(255)

The measured/calculated value

 

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 


Inside StruxureWare Data Center Operation, KPI have a history – this history is NOT reflected in the export database – only the newest known values are currently available. 

Table: EXTERNAL_SYSTEM_RELATION

If a DataCenterItem is associated with a physical (or virtual) device through an external system, the link is represented by a record in this table. 

EXTERNAL_SYSTEM_RELATION

 

 

 

Field

Datatype

Description

Sampledata

ci_id

varchar(36)

Identifier of item. The ci_id field is a foreign key to CONFIGURATION_ITEM

"550e8400-e29b-41d4-a716-446655440000"

esr_system_name

varchar(300)

The name of the external system through which this relation is made.

"ETL Excel Import"

esr_system_type

varchar(63)

The type of the external system.

"ETLImport"

esr_item_id

varchar(255)

The ID of the external item that represents the foreign end of the relation(association).

"KN20623BY9"

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 



Table: CONFIGURATION_ITEM_RELATION

Relationship between configuration items are modelled in the configuration_item_relation table. One example of a relations is power cables. 

CONFIGURATION_ITEM_RELATION

 

 

 

Field

Datatype

Description

Sampledata

cir_id

varchar(36)

Unique id of relation

"550e8400-e29b-41d4-a716-446655440000"

ci_id_a

varchar(36)

Id of first endpoint of the relation

"31925392-e29b-41d4-a716-446655440000"

ci_id_b

varchar(36)

Id of second endpoint of the relation

"22909021-e29b-41d4-a716-446655440000"

cir_type

varchar(64)

Type of the relation

a_connected_to_b

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 


The type of relation is not classifies. 

Table: CONFIGURATION_ITEM_RELATION_CUSTOM_PROPERTY

Any CustomProperties associated with the relation in CONFIGURATION_ITEM_RELATION table are stored in the CONFIGURATION_ITEM_RELATION_CUSTOM_PROPERTY table. 

CONFIGURATION_ITEM_RELATION

 

 

 

Field

Datatype

Description

Sampledata

ci_id varchar(36) Unique id to retrieve the custom property name and value in CUSTOM_PROPERTY table  

cir_id

varchar(36)

Unique id of relation

"550e8400-e29b-41d4-a716-446655440000"

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 

Table: RELATION_PROPERTY

Each relation between configuration items may have a number of associated properties containing information specific for that relation.
One example is the power and phase information for power-cables connecting equipment. 

RELATION_PROPERTY

 

 

 

Field

Datatype

Description

Sampledata

cir_id

varchar(36)

Unique id of relation

"550e8400-e29b-41d4-a716-446655440000"

rp_name

varchar(255)

Name of property

"powerPhase"

rp_value

varchar(255)

Value of property

"L1-L2"

rp_type

varchar(16)

Type of property

"powerPhase"

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 


The relation property type (rp_type) is not classified.


Table: RELATION_ENDPOINT_PROPERTY

If a relation has special information associated with the "endpoints" of the relations (this is the case for network cables), the endpoint related information is exported to the relation_endpoint_property table. 

CONFIGURATION_ITEM_RELATION

 

 

 

Field

Datatype

Description

Sampledata

cir_id

varchar(255)

Unique id of the relation

"0583d972-2ce5-499a-9a61-1ec27798925e##10#RJ45_REGULAR#true"

ci_id

varchar(36)

Unique id of the endpoint that this property is related to

"31925392-e29b-41d4-a716-446655440000"

cir_endpoint varchar(255) Indentifies the endpoint

"A" and "B" for properties of network connection endpoints

rep_name

varchar(255)

Name of the property

"portSpeed"

rep_value

varchar(255)

Value of the property

"1Gbps"

rep_type

varchar(64)

Type of the property

"networkSpeed"

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 

The relation endpoint property type is not classified. 

Table: PORT_CONFIGURATION

NOTE: This table is only available in the export database from 7.5 Service Pack 2 and newer.

PORT_CONFIGURATION

Field

Datatype

Description

Sampledata

ci_id varchar(255) Identifier of item. The ci_id field is a foreign key to CONFIGURATION_ITEM "123882d5-cebe-4563-a1fc-b7855c7e423e"

connector_type

varchar(255)

Connector type for the port configuration

"RJ45_REGULAR"

module_name varchar(255) Module name "Module A"
start_port integer Start port number 1
port_count integer Number of ports in the configuration 48
port_speed varchar(255) Transmission speed for the port configuration

"1 Gbps"

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 

Cages and Rows

In the internal StruxureWare Data Center Operation model neither rows nor cages are part of the equipment parent-child hierarchy. 
When exporting configuration items from StruxureWare Data Center Operation, this is hidden from the user, and the natural parent-child hierarchy is build.
The relation is realized by having each configuration item reference its parent through the parent_id field. 
The area of cages are fetched from the StruxureWare Data Center Operation webservices and associated with the configuration items representing the individual cages, in the table configuration_item_property.
The area-property is named CageArea, and the area is expressed in whatever unit the webservice returns.


 

Table: FREE_SPACE

NOTE: FREE_SPACE is currently not being used. It is here for possible future usage.

FREE_SPACE

Field

Datatype

Description

Sampledata

ci_id

varchar(255)

Identifier of item. The ci_id field is a foreign key to CONFIGURATION_ITEM

"550e8400-e29b-41d4-a716-446655440000"

free_space

varchar(16)

Free space calculated

 

ci_name

varchar(255)

Name of item

 

ci_type

varchar(64)

Type of item

 

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 

 


Table: CUSTOMER_DATA

CUSTOMER_DATA

Field

Datatype

Description

Sampledata

customer_id

varchar(255)

Unique id of the customer

"000654"

customer_company

varchar(255)

Company of the customer

"Schneider Electric"

customer_contact

varchar(255)

Main contact of customer

"Mr Black"

customer_type

varchar(36)

Type of customer

 

customer_department

varchar(255)

Department where customer contact is registered

"000654"

customer_phonenumber varchar(36) Phone number of customer "111-111-1111"

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 


 

Table: CUSTOMER_RELATION

CUSTOMER_RELATION

Field

Datatype

Description

Sampledata

ci_id

varchar(36)

Unique id of the relation

"550e8400-e29b-41d4-a716-446655440000"

customer_id

varchar(36)

Id of the customer

"000654"

power_sold

double

Power in kW that is sold by contract to the customer

"4.2"

reserved_for

varchar(255)

Reservation of area made for a customer

"Future customer"

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 


 

Table: WORK_ORDER

WORK_ORDER

Field

Datatype

Description

Sampledata

wo_id

varchar(40)

Unique id of the work order

"029882d9-ccbe-4233-a1fc-b8a94050e3bb"

assigned_to

varchar(64)

Name of assignee of the work order

"Mr Black"

comment

varchar(3000)

Comment made on work order

"This must be done!"

completed_date bigInt Date in epoch format "1362608169502"
created_date bigInt Date in epoch format "1362608169502"

needed_by_date

bigInt

Date in epoch format

"1362608169502"

order_number

Integer

Number of work order

"54"

priority Integer Priority of work order "2"
project_code varchar(255) Project code name that work order is part of "DC improvement"
status varchar(255) Status of work order "COMPLETE"
summary varchar(255) Summary title of work order "New Work Order"

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 


 

Table: WORK_ORDER_REMOVE_TASK

WORK_ORDER_REMOVE_TASK

Field

Datatype

Description

Sampledata

id varchar(40) Unique id of the task "123882d5-cebe-4563-a1fc-b7855c7e423e"

wo_id

varchar(40)

Unique id of the work order

"029882d9-ccbe-4233-a1fc-b8a94050e3bb"

ci_id

varchar(255)

Unique id of the configuration_item

"550e8400-e29b-41d4-a716-446655440000"

assigned_to

varchar(255)

Name of assignee of the task

"Mr Black"

created_date bigInt Date in epoch format "1362608169502"

completed_date

bigInt

Date in epoch format

"1362608169502"

needed_by_date

bigInt

Date in epoch format

"1362608169502"

note

varchar(3000)

Note made on the task

"This must be done!"

order_number

Integer

Number of work order that task is part of

"54"

status varchar(255) Status of work order "COMPLETE"

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 



 

Table: WORK_ORDER_MOVE_TASK 

WORK_ORDER_MOVE_TASK

Field

Datatype

Description

Sampledata

id varchar(40) Unique id of the task "123882d5-cebe-4563-a1fc-b7855c7e423e"

wo_id

varchar(40)

Unique id of the work order

"029882d9-ccbe-4233-a1fc-b8a94050e3bb"

source_ci_id

varchar(255)

Unique id of the source configuration_item

"550e8400-e29b-41d4-a716-446655440045"

target_ci_id

varchar(255)

Unique id of the target configuration_item

"550e8400-e29b-41d4-a716-446655440046"

assigned_to

varchar(255)

Name of assignee of the task

"Mr Black"

created_date bigInt Date in epoch format "1362608169502"

completed_date

bigInt

Date in epoch format

"1362608169502"

needed_by_date

bigInt

Date in epoch format

"1362608169502"

note

varchar(3000)

Note made on the task

"This must be done!"

order_number

Integer

Number of work order that task is part of

"54"

status varchar(255) Status of work order "COMPLETE"

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 


 

Table: WORK_ORDER_CUSTOM_TASK

WORK_ORDER_CUSTOM_TASK

Field

Datatype

Description

Sampledata

id varchar(40) Unique id of the task "123882d5-cebe-4563-a1fc-b7855c7e423e"

wo_id

varchar(40)

Unique id of the work order

"029882d9-ccbe-4233-a1fc-b8a94050e3bb"

assigned_to

varchar(255)

Name of assignee of the task

"Mr Black"

created_date bigInt Date in epoch format "1362608169502"

completed_date

bigInt

Date in epoch format

"1362608169502"

needed_by_date

bigInt

Date in epoch format

"1362608169502"

note

varchar(3000)

Note made on the task

"This must be done!"

order_number

Integer

Number of work order that task is part of

"54"

status varchar(255) Status of work order "COMPLETE"

description

varchar(3000)

Note made on the task

"This must be done!"

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 

 


Table: WORK_ORDER_CUSTOM_EQUIPMENT_TASK 

WORK_ORDER_CUSTOM_EQUIPMENT_TASK

Field

Datatype

Description

Sampledata

id varchar(40) Unique id of the task "123882d5-cebe-4563-a1fc-b7855c7e423e"

wo_id

varchar(40)

Unique id of the work order

"029882d9-ccbe-4233-a1fc-b8a94050e3bb"

ci_id

varchar(255)

Unique id of the configuration_item

"550e8400-e29b-41d4-a716-446655440000"

assigned_to

varchar(255)

Name of assignee of the task

"Mr Black"

created_date bigInt Date in epoch format "1362608169502"

completed_date

bigInt

Date in epoch format

"1362608169502"

needed_by_date

bigInt

Date in epoch format

"1362608169502"

note

varchar(3000)

Note made on the task

"This must be done!"

order_number

Integer

Number of work order that task is part of

"54"

status varchar(255) Status of work order "COMPLETE"

description

varchar(3000)

Note made on the task

"This must be done!"

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 

 

Table: WORK_ORDER_CONNECT_CABLE_TASK   

WORK_ORDER_CONNECT_CABLE_TASK

Field

Datatype

Description

Sampledata

id varchar(40) Unique id of the task "123882d5-cebe-4563-a1fc-b7855c7e423e"

wo_id

varchar(40)

Unique id of the work order

"029882d9-ccbe-4233-a1fc-b8a94050e3bb"

source_ci_id

varchar(255)

Unique id of the source configuration_item

"550e8400-e29b-41d4-a716-446655440045"

target_ci_id

varchar(255)

Unique id of the target configuration_item

"550e8400-e29b-41d4-a716-446655440046"

assigned_to

varchar(255)

Name of assignee of the task

"Mr Black"

created_date bigInt Date in epoch format "1362608169502"

completed_date

bigInt

Date in epoch format

"1362608169502"

needed_by_date

bigInt

Date in epoch format

"1362608169502"

note

varchar(3000)

Note made on the task

"This must be done!"

order_number

Integer

Number of work order that task is part of

"54"

status varchar(255) Status of work order "COMPLETE"

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 

 

Table: WORK_ORDER_ADD_TASK

WORK_ORDER_ADD_TASK

Field

Datatype

Description

Sampledata

id varchar(40) Unique id of the task "123882d5-cebe-4563-a1fc-b7855c7e423e"

wo_id

varchar(40)

Unique id of the work order

"029882d9-ccbe-4233-a1fc-b8a94050e3bb"

ci_id

varchar(255)

Unique id of the configuration_item

"550e8400-e29b-41d4-a716-446655440000"

assigned_to

varchar(255)

Name of assignee of the task

"Mr Black"

created_date bigInt Date in epoch format "1362608169502"

completed_date

bigInt

Date in epoch format

"1362608169502"

needed_by_date

bigInt

Date in epoch format

"1362608169502"

note

varchar(3000)

Note made on the task

"This must be done!"

order_number

Integer

Number of work order that task is part of

"54"

status varchar(255) Status of work order "COMPLETE"

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 

 

Table: WORK_ORDER_CHANGE_TICKET 

WORK_ORDER_CHANGE_TICKET

Field

Datatype

Description

Sampledata

work_order_wo_id varchar(40) Unique id of the work order "123882d5-cebe-4563-a1fc-b7855c7e423e"

links_change_ticket_id

varchar(32)

Unique id of the change ticket

"029882d9-ccbe-4233-a1fc-b8a94050e3bb"

links_external_system_id

varchar(36)

Unique id of the external system

"550e8400-e29b-41d4-a716-446655440000"


Table: WORK_ORDER_NETWORK_CONNECTION_TASK  

WORK_ORDER_NETWORK_CONNECTION_TASK

Field

Datatype

Description

Sampledata

id varchar(40) Unique id of the task "123882d5-cebe-4563-a1fc-b7855c7e423e"

assigned_to

varchar(255)

Name of assignee of the task

"Mr Black"

completed_date

bigInt

Date in epoch format

"1362608169502"

created_date bigInt Date in epoch format "1362608169502"

needed_by_date

bigInt

Date in epoch format

"1362608169502"

note

varchar(3000)

Note made on the task

"This must be done!"

order_number

Integer

Number of work order that task is part of

"54"

wo_id

varchar(40)

Unique id of the work order

"029882d9-ccbe-4233-a1fc-b8a94050e3bb"

disconnect

Integer

Boolean telling if connection is disconnected or connected

1 = disconnected, 0 = connected

from_connector_type

varchar(255)

Port type used in connection starting device

"RJ45"

from_ci_id

varchar(255)

Unique id of the configuration_item

"550e8400-e29b-41d4-a716-446655440000"

from_module_name

varchar(255)

Name of module containing port in connection starting device

"Module Name"

from_patch_panel_rear

Integer

Boolean telling if starting patch panel is connected in front or rear

1 = rear, 0 = front

from_port_number

Integer

Port number of connection on starting device

1

port_count

Integer

Number of contiguous ports to be connected/disconnected

8

to_connector_type

varchar(255)

Port type used in connection ending device

"RJ45"

to_ci_id

varchar(255)

Unique id of the configuration_item

"550e8400-e29b-41d4-a716-446655440000"

to_module_name

varchar(255)

Name of module containing port in connection ending device

"Module Name 2"

to_patch_panel_rear

Integer

Boolean telling if starting patch panel is connected in front or rear

1 = rear, 0 = front

to_port_number

Integer

Port number of connection on starting device

1

connection_usage

varchar(255)

Description of connection

"Internet provider 2"

status varchar(255) Status of work order "COMPLETE"

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 


 

Table: CHANGE_TICKET 

CHANGE_TICKET

Field

Datatype

Description

Sampledata

change_ticket_id varchar(32) Unique id of the change ticket "123882d5-cebe-4563-a1fc-b7855c7e423e"

external_system_id

varchar(36)

Unique id of the external system

"550e8400-e29b-41d4-a716-44665544030

change_ticket_status varchar(26) Status of the change ticket "COMPLETE"
name varchar(255) Name of the change ticket "Move server"

state_flag

varchar(16)

Indicates the state of the information. See section on information state above

new, changed, deleted

state_last_updated

long

Timestamp set by the external system whenever the information in the row/record is changed.

 

state_last_synchronized

long

Timestamp used by StruxureWare Data Center Operation to indicate when the row was last successfully read and synchronized.

 

 

 

Table: SYNCHRONIZATION_STATUS

In ETL each object class (tags, configuration-items etc.) have specialized synchronizers.
During synchronization track is kept with the number of new, updated and deleted ETL entities (rows in the ETL import tables)
After synchronization this information is stored in the SYNCHRONIZATION_STATUS table.

SYNCHRONIZATION_STATUS

Field

Datatype

Description

Sampledata

configuration_name

varchar(255)

For future use

 

synchronizer_name

varchar(255)

For future use

 
timestamp bigInt For future use  

deleted_objects

bigInt

For future use  

new_objects

bigInt

For future use  

updated_objects

bigInt

For future use

 


Table: PERFORMANCE_DATA_POINT 

PERFORMANCE_DATA_POINT

Field

Datatype

Description

Sampledata

conf_id

varchar(255)

For Schneider Electric use only, needs developer specific agent to be populated with data

 

step_id

varchar(255)

For Schneider Electric use only, needs developer specific agent to be populated with data

 

timestamp bigInt For Schneider Electric use only, needs developer specific agent to be populated with data  

conf_name

varchar(255)

For Schneider Electric use only, needs developer specific agent to be populated with data

 

duration_ns bigInt For Schneider Electric use only, needs developer specific agent to be populated with data  

occurences

Integer

For Schneider Electric use only, needs developer specific agent to be populated with data

 

Skip to end of metadata
Go to start of metadata
  • No labels

7 Comments

  1. The top sections says "Please make sure to understand the Database Information State for the ETL import database. The information state is important since it is used for "bookkeeping" of data in the data base" and provides a link for "Data Information State". When I click on the link, it brings me back to the same page. I cannot find any information on this "Database Information State", please advise? 

  2. Hi, can some pls explain in a little detail the entry titled "Cages and Rows" above FREE_SPACE and explain with what the FREE_SPACE table will populated.

    Thanks 

  3. Can someone please reply to Ed's question, I would like to know also what data does the FREE_SPACE table contains?  I am seeing an empty table even though I have many rooms, cages and rows created. 

     

    John MacDonald, Matthew Farnell – Please assist if you can.

  4. FREE_SPACE is currently not being used! It is basically there for possible future usage.

  5. Thanks Jef.

    Would someone please note this next to the table info on this page to avoid future confusion.  Thanks

    1. Hi Ed, 

      It's been added.

      Thanks,

      Stine

RELATED COMMUNITY QUESTIONS
WAS THIS ARTICLE HELPFUL?