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 7 Next »

Description

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

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.

Parent job batch ID

The PDI batch ID of the parent job taken from the job logging table. You need to enable logging in the job and set "Pass batch ID" in the job 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

Current process identifier (PID)

The PID under which the Java process is currently running

TODO - jvm max memory

TODO

TODO - jvm total memory

TODO

TODO - jvm free memory

TODO

TODO - jvm available memory

TODO

TODO - available processors

TODO

TODO - jvm cpu time

TODO

TODO - total physical memory size

TODO

TODO - total swap space size

TODO

TODO - committed virtual memory size

TODO

TODO - free physical memory size

TODO

TODO - free swap space size

TODO

TODO - last week start

TODO

TODO - last week end

TODO

TODO - last week open end

TODO

TODO - last week start us

TODO

TODO - last week end us

TODO

TODO - this week start

TODO

TODO - this week end

TODO

TODO - this week open end

TODO

TODO - this week start us

TODO

TODO - this week end us

TODO

TODO - next week start

TODO

TODO - next week end

TODO

TODO - next week open end

TODO

TODO - next week start us

TODO

TODO - next week end us

TODO

TODO - prev quarter start

TODO

TODO - prev quarter end

TODO

TODO - this quarter start

TODO

TODO - this quarter end

TODO

TODO - next quarter start

TODO

TODO - next quarter end

TODO

TODO - prev year start

TODO

TODO - prev year end

TODO

TODO - this year start

TODO

TODO - this year end

TODO

TODO - next year start

TODO

TODO - next year end

TODO

TODO - previous result result

TODO

TODO - previous result exist status

TODO

TODO - previous result entry nr

TODO

TODO - previous result nr errors

TODO

TODO - previous result nr lines input

TODO

TODO - previous result nr lines output

TODO

TODO - previous result nr lines read

TODO

TODO - previous result nr lines updated

TODO

TODO - previous result nr lines written

TODO

TODO - previous result nr lines deleted

TODO

TODO - previous result nr lines rejeted

TODO

TODO - previous result nr rows

TODO

TODO - previous result is stopped

TODO

TODO - previous result nr files

TODO

TODO - previous result nr files retrieved

TODO

TODO - previous result log text

TODO

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