Home
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)
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.1.3.
|
Version |
DCO version |
Description |
|
1.0.0 |
DCO 7.3.0, 7.4.0, 7.4.5, 7.5, 8.0 |
Initial schema design for the StruxureWare Data Center Operation ETL feature |
| 1.1.3 |
DCO 8.3 ITA 9.x |
Updated schema design with new properties added to configuration_item table |
The schema version is used by the Data Center Operation server for validation of the ETL setup.
Table: CONFIGURATION_ITEM
The table will contain a complete list of equipment in the data center model. This represents Data Center Operation's view of the data center.
|
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 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 of equipment |
|
|
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_width | int | Width of the equipment in millimeters. Available for free standing and rack-mounted equipment. | |
| ci_height | int | Height of the equipment in millimeters. Available for free standing and rack-mounted equipment. | |
| ci_depth | int | Depth of the equipment in millimeters. Available for free standing and rack-mounted equipment. | |
| ci_weight | double | Weight of equipment in grams | |
|
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_design_limit | double | Design limit of the equipment in watts if is set | |
|
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 Data Center Operation to indicate when the row was last successfully read and synchronized. |
|
Table: CONFIGURATION_ITEM_PROPERTY
In the 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 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 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 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 |
text |
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 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 |
"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 Data Center Operationto indicate when the row was last successfully read and synchronized. |
|
Inside 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 Data Center Operation to indicate when the row was last successfully read and synchronized. |
|
Table: CONFIGURATION_ITEM_RELATION
Relationship between configuration items are modeled 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 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 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 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 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 Data Center Operation to indicate when the row was last successfully read and synchronized. |
|
Cages and Rows
In the internal Data Center Operation model, neither rows nor cages are part of the equipment parent-child hierarchy.
When exporting configuration items from DCO, 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 DCO web services 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 web service 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 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 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 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 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 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 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 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 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 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 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 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 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 |
|
0 comments
Please sign in to leave a comment.