ConfigurationItems Normal 1 / db_database db_hostname db_password db_port db_username timestamp 0 xls_filename xls_folder ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDTRANSNAMEYTRANSNAMESTATUSYSTATUSLINES_READYLINES_READLINES_WRITTENYLINES_WRITTENLINES_UPDATEDYLINES_UPDATEDLINES_INPUTYLINES_INPUTLINES_OUTPUTYLINES_OUTPUTLINES_REJECTEDYLINES_REJECTEDERRORSYERRORSSTARTDATEYSTARTDATEENDDATEYENDDATELOGDATEYLOGDATEDEPDATEYDEPDATEREPLAYDATEYREPLAYDATELOG_FIELDYLOG_FIELDEXECUTING_SERVERNEXECUTING_SERVEREXECUTING_USERNEXECUTING_USERCLIENTNCLIENT ID_BATCHYID_BATCHSEQ_NRYSEQ_NRLOGDATEYLOGDATETRANSNAMEYTRANSNAMESTEPNAMEYSTEPNAMESTEP_COPYYSTEP_COPYLINES_READYLINES_READLINES_WRITTENYLINES_WRITTENLINES_UPDATEDYLINES_UPDATEDLINES_INPUTYLINES_INPUTLINES_OUTPUTYLINES_OUTPUTLINES_REJECTEDYLINES_REJECTEDERRORSYERRORSINPUT_BUFFER_ROWSYINPUT_BUFFER_ROWSOUTPUT_BUFFER_ROWSYOUTPUT_BUFFER_ROWS ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDLOG_DATEYLOG_DATELOGGING_OBJECT_TYPEYLOGGING_OBJECT_TYPEOBJECT_NAMEYOBJECT_NAMEOBJECT_COPYYOBJECT_COPYREPOSITORY_DIRECTORYYREPOSITORY_DIRECTORYFILENAMEYFILENAMEOBJECT_IDYOBJECT_IDOBJECT_REVISIONYOBJECT_REVISIONPARENT_CHANNEL_IDYPARENT_CHANNEL_IDROOT_CHANNEL_IDYROOT_CHANNEL_ID ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDLOG_DATEYLOG_DATETRANSNAMEYTRANSNAMESTEPNAMEYSTEPNAMESTEP_COPYYSTEP_COPYLINES_READYLINES_READLINES_WRITTENYLINES_WRITTENLINES_UPDATEDYLINES_UPDATEDLINES_INPUTYLINES_INPUTLINES_OUTPUTYLINES_OUTPUTLINES_REJECTEDYLINES_REJECTEDERRORSYERRORSLOG_FIELDNLOG_FIELD ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDLOG_DATEYLOG_DATEMETRICS_DATEYMETRICS_DATEMETRICS_CODEYMETRICS_CODEMETRICS_DESCRIPTIONYMETRICS_DESCRIPTIONMETRICS_SUBJECTYMETRICS_SUBJECTMETRICS_TYPEYMETRICS_TYPEMETRICS_VALUEYMETRICS_VALUE 0.0 0.0 10000 50 50 N Y 50000 Y N 1000 100 - 2014/01/13 14:09:41.788 - 2015/08/26 13:32:23.418 Staging ${db_hostname} POSTGRESQL Native ${db_database} 5432 ${db_username} ${db_password} FORCE_IDENTIFIERS_TO_LOWERCASEN FORCE_IDENTIFIERS_TO_UPPERCASEN IS_CLUSTEREDN PORT_NUMBER5432 PRESERVE_RESERVED_WORD_CASEN QUOTE_ALL_FIELDSN SUPPORTS_BOOLEAN_DATA_TYPEY SUPPORTS_TIMESTAMP_DATA_TYPEY USE_POOLINGN Microsoft Excel InputRename Rows 2Y Rename Rows 2Sort rowsY Sort rowsUnique rowsY Add item type constantSelect valuesY Filter ci_id nullDummy (do nothing) 2 2Y Filter ci_id nullTimestampY Merge itemsSynchronize itemsY Sort rows 2 2Merge itemsY TimestampAdd item type constantY Unique rowsFilter ci_id nullY Select valuesMerge itemsY Table inputSort rows 2 2Y Add item type constant Constant Y 1 none cit_id Integer 0 -1 -1 N

650 150 Y Dummy (do nothing) 2 2 Dummy Y 1 none

450 50 Y Filter ci_id null FilterRows Y 1 none Dummy (do nothing) 2 2 Timestamp N ci_id IS NULL constantNumber0.0-1-1N#.#;-#.#

450 150 Y Merge items MergeRows N 1 none ci_id ci_id state_last_updated cit_id ci_name state_flag Sort rows 2 2 Select values

850 150 Y Microsoft Excel Input ExcelInput N 1 none

Y

Y N 0 Y N ${xls_folder}${xls_filename} N N name String -1 -1 none N id String -1 -1 none N port_type String -1 -1 none N start_port_number Number -1 -1 none N port_count Number -1 -1 none N module_name String -1 -1 none N port_speed String -1 -1 none N PortConfigurations 0 0 N N N warning error line JXL

50 150 Y Rename Rows 2 SelectValues Y 1 none name ci_name -2 -2 id ci_id -2 -2 Y port_type start_port_number port_count module_name port_speed

150 150 Y Select values SelectValues N 1 none ci_name -2 -2 ci_id -2 -2 state_last_updated -2 -2 cit_id -2 -2 N state_last_updated state_last_updated Integer 15 -2 false false

750 150 Y Sort rows SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N ci_id Y Y N

250 150 Y Sort rows 2 2 SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N Y ci_id Y Y N

850 250 Y Synchronize items SynchronizeAfterMerge Y 1 none Staging 100 N N Y state_flag new changed configuration_item ci_id ci_id = ci_id ci_id Y state_last_updated state_last_updated Y cit_id cit_id Y ci_name ci_name Y state_flag state_flag Y

950 150 Y Table input TableInput Y 1 none Staging SELECT ci_name, ci_id, state_last_updated, cit_id FROM configuration_item 0 N N N

850 350 Y Timestamp GetVariable Y 1 none state_last_updated ${timestamp} String 0 0 none

550 150 Y Unique rows Unique Y 1 none N N ci_id N

350 150 Y N