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

(warning) PLEASE NOTE: This documentation applies to Pentaho 8.1 and earlier. For Pentaho 8.2 and later, see Get System Info on the Pentaho Enterprise Edition documentation site.

Description

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

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

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

TODO

Date when the transformation was modified last

TODO

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, 5.0.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

JVM max memory

TODO

JVM total memory

TODO

JVM free memory

TODO

JVM available memory

TODO

Available processors

TODO

JVM CPU time (milliseconds)

TODO

Total physical memory size (bytes)

TODO

Total swap space size (bytes)

TODO

Committed virtual size (bytes)

TODO

Free physical memory size (bytes)

TODO

Free swap space size (bytes)

TODO

First day of last week 00:00:00

TODO

Last day of last week 23:59:59

TODO

Last working day of last week 23:59:59

TODO

First day of last week 00:00:00 (US)

TODO

Last day of last week 23:59:59 (US)

TODO

First day of this week 00:00:00

TODO

Last day of this week 23:59:59

TODO

Last working day of this week 23:59:59

TODO

First day of this week 00:00:00 (US)

TODO

Last day of this week 23:59:59 (US)

TODO

First day of next week 00:00:00

TODO

Last day of next week 23:59:59

TODO

Last working day of next week 23:59:59

TODO

First day of next week 00:00:00 (US)

TODO

Last day of next week 23:59:59 (US)

TODO

First day of last quarter 00:00:00

TODO

Last day of last quarter 23:59:59

TODO

First day of this quarter 00:00:00

TODO

Last day of this quarter 23:59:59

TODO

First day of next quarter 00:00:00

TODO

Last day of next quarter 23:59:59

TODO

First day of last year 00:00:00

TODO

Last day of last year 23:59:59

TODO

First day of this year 00:00:00

TODO

Last day of this year 23:59:59

TODO

First day of next year 00:00:00

TODO

Last day of next year 23:59:59

TODO

Previous job entry result

TODO

Previous job entry exit status

TODO

Previous job entry nr

TODO

Previous job entry nr errors

TODO

Previous job entry nr lines input

TODO

Previous job entry nr lines output

TODO

Previous job entry nr lines read

TODO

Previous job entry nr lines updated

TODO

Previous job entry nr lines written

TODO

Previous job entry nr lines deleted

TODO

Previous job entry nr lines rejected

TODO

Previous job entry nr rows

TODO

Previous job entry stopped

TODO

Previous job entry nr files

TODO

Previous job entry nr files retrieved

TODO

Previous job entry log text

TODO

  • No labels