Get System Info
Description
The Get System Info transform retrieves system information from the Hop project, or the environment or system Hop is running on.
The transform includes a table where you can designate a name and assign it to any available system info type you want to retrieve. This transform generates a single row with the fields containing the requested information.
It can also accept any number of input streams, aggregate any fields defined by this transform, and send the combined results to the output stream.
Options
| Option | Description |
|---|---|
Transform name | Name of the transform this name has to be unique in a single pipeline. |
Name | The name you want to give a specific data type |
Type | A list of the available system data types |
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 pipeline. |
start date range (Pipeline) | Start of date range, based upon information in ETL log table. See, also .08 Pipeline Settings. |
end date range (Pipeline) | End of date range, based upon information in ETL log table. See, also .08 Pipeline Settings. |
start data range (Workflow) | Start of date range based upon information in the ETL log table. See also .08 Pipeline Settings. |
End date range (Workflow) | End of date range based upon information in the ETL log table. See also .08 Pipeline 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 transform | Copy nr of the transform. See also Launching several copies of a transform. |
Pipeline name | Name of the pipeline. |
Pipeline file name | File name of the pipeline (XML only). |
User that modified the pipeline last | |
Date when the pipeline was modified last | |
Hostname | Returns the hostname of the server. |
IP address | Returns the IP address of the server. |
Current process identifier (PID) | The PID under which the Java process is currently running |
JVM max memory | |
JVM total memory | |
JVM free memory | |
JVM available memory | |
Available processors | |
JVM CPU time (milliseconds) | |
Total physical memory size (bytes) | |
Total swap space size (bytes) | |
Committed virtual size (bytes) | |
Free physical memory size (bytes) | |
Free swap space size (bytes) | |
First day of last week 00:00:00 | |
Last day of last week 23:59:59 | |
Last working day of last week 23:59:59 | |
First day of last week 00:00:00 (US) | |
Last day of last week 23:59:59 (US) | |
First day of this week 00:00:00 | |
Last day of this week 23:59:59 | |
Last working day of this week 23:59:59 | |
First day of this week 00:00:00 (US) | Last day of this week 23:59:59 (US) |
First day of next week 00:00:00 | |
Last day of next week 23:59:59 | |
Last working day of next week 23:59:59 | |
First day of next week 00:00:00 (US) | |
Last day of next week 23:59:59 (US) | |
First day of last quarter 00:00:00 | |
Last day of last quarter 23:59:59 | |
First day of this quarter 00:00:00 | |
Last day of this quarter 23:59:59 | |
First day of next quarter 00:00:00 | |
Last day of next quarter 23:59:59 | |
First day of last year 00:00:00 | |
Last day of last year 23:59:59 | |
First day of this year 00:00:00 | |
Last day of this year 23:59:59 | |
First day of next year 00:00:00 | |
Last day of next year 23:59:59 | |
Previous workflow action result | |
Previous workflow action exit status | |
Previous workflow action nr | |
Previous workflow action nr errors | |
Previous workflow action nr lines input | |
Previous workflow action nr lines output | |
Previous workflow action nr lines read | |
Previous workflow action nr lines updated | |
Previous workflow action nr lines written | |
Previous workflow action nr lines deleted | |
Previous workflow action nr lines rejected | |
Previous workflow action nr rows | |
Previous workflow action stopped | |
Previous workflow action nr files | |
Previous workflow action nr files retrieved | |
Previous workflow action log text |