Hitachi Vantara Pentaho Community Wiki
Child pages
  • Get System Info
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Description

This Get System Info step retrieves information from the Kettle environment. The table below contains the available information to retrieve.

Screen shot



Information types

Item

Description

system date (variable)

System time, changes every time you ask a date.

system date (fixed)

System time, determined at the start of the transformation.

start date range (Transformation)

Start of date range, based upon information in ETL log table. See, also .08 Transformation Settings.

end date range (Transformation)

End of date range, based upon information in ETL log table. See, also .08 Transformation Settings.

start data range (Job)

Start of date range based upon information in the ETL log table. See also .08 Transformation Settings.

End date range (Job)

End of date range based upon information in the ETL log table. See also .08 Transformation Settings.

Yesterday 00:00:00

Start of yesterday.

Yesterday 23:59:59

End of yesterday.

Today 00:00:00

Start of today.

Today 23:59:59

End of today.

Tomorrow 00:00:00

Start of tomorrow.

Tomorrow 23:59:59

End of tomorrow

First day of last month 00:00:00

Start of last month.

Last day of last month 23:59:59

End of last month.

First day of this month 00:00:00

Start of this month.

Last day of this month 23:59:59

End of this month.

First day of next month 00:00:00

Start of next month.

Last day of next month 23:59:59

End of next month.

copy of step

Copy nr of the step. See also Launching several copies of a step.

Transformation name

Name of the transformation.

Transformation file name

File name of the transformation (XML only).

User that modified the transformation last

 

Date when the transformation was modified last

 

Transformation batch ID

ID_BATCH value in the logging table, see .08 Transformation Settings.

Hostname

Returns the hostname of the server.

IP address

Returns the IP address of the server.

Command line argument 1

Argument 1 on the command line

Command line argument 2

Argument 2 on the command line

Command line argument 3

Argument 3 on the command line

Command line argument 4

Argument 4 on the command line

Command line argument 5

Argument 5 on the command line

Command line argument 6

Argument 6 on the command line

Command line argument 7

Argument 7 on the command line

Command line argument 8

Argument 8 on the command line

Command line argument 9

Argument 9 on the command line

Command line argument 10

Argument 10 on the command line

Kettle version

Returns the Kettle version (for example, 2.5.0)

Kettle Build Version

Returns the build version of the core Kettle library (for example, 13)

Kettle Build Date

Returns the build date of the core Kettle library

Options

There table below describes the options for configuring the Get System info step:

Option

Description

Step Name

Name of the step; this name has to be unique in a single transformation

Fields

The fields to output

Usage

This step generates a single row with the fields containing the requested information.
From version 2.3.0 on, this step also accepts input rows. The selected values are added to the rows found in the input stream(s)

  • No labels