Get System Info
- Former user (Deleted)
- Virginia Agnew
- Former user (Deleted)
PLEASE NOTE: This documentation applies to an earlier version. For the most recent documentation, visit 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 |