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

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

Function Description Serialization code (for metadata injection)

Function	Description	Serialization code (for metadata injection)
System date (variable)	System time, changes every time you ask a date.	`system date (variable)`
System date (fixed)	System time, determined at the start of the pipeline.	`system date (fixed)`
Start date range (Pipeline)	Start of date range, based upon information in ETL log table. See, also .08 Pipeline Settings.	`start date range`
End date range (Pipeline)	End of date range, based upon information in ETL log table. See, also .08 Pipeline Settings.	`end date range`
Start date range (Workflow)	Start of date range based upon information in the ETL log table. See also .08 Pipeline Settings.	`workflow start date range`
End date range (Workflow)	End of date range based upon information in the ETL log table. See also .08 Pipeline Settings.	`workflow end date range`
Yesterday 00:00:00	Start of yesterday.	`yesterday start`
Yesterday 23:59:59	End of yesterday.	`yesterday end`
Today 00:00:00	Start of today.	`today start`
Today 23:59:59	End of today.	`today end`
Tomorrow 00:00:00	Start of tomorrow.	`tomorrow start`
Tomorrow 23:59:59	End of tomorrow.	`tomorrow end`
First day of last month 00:00:00	Start of last month.	`last month start`
Last day of last month 23:59:59	End of last month.	`last month end`
First day of this month 00:00:00	Start of this month.	`this month start`
Last day of this month 23:59:59	End of this month.	`this month end`
First day of next month 00:00:00	Start of next month.	`next month start`
Last day of next month 23:59:59	End of next month.	`next month end`
Copy of transform	Copy nr of the transform. See also Launching several copies of a transform.	`copy of transform`
Pipeline name	Name of the pipeline.	This code has a leading white space: `pipeline name`
Pipeline file name	File name of the pipeline (XML only).	This code has leading white space : `pipeline file name`
User that modified the pipeline last		`User modified`
Date when the pipeline was modified last		`Date modified`
Hostname (Network setup)	Returns the hostname of the server.	`Hostname`
Hostname (Real)		`Hostname real`
IP address	Returns the IP address of the server.	`IP address`
Current process identifier (PID)	The PID under which the Java process is currently running	`Current PID`
JVM max memory		`jvm max memory`
JVM total memory		`jvm total memory`
JVM free memory		`jvm free memory`
JVM available memory		`jvm available memory`
Available processors		`available processors`
JVM CPU time (milliseconds)		`jvm cpu time`
Total physical memory size (bytes)		`total physical memory size`
Total swap space size (bytes)		`total swap space size`
Committed virtual size (bytes)		`committed virtual memory size`
Free physical memory size (bytes)		`free physical memory size`
Free swap space size (bytes)		`free swap space size`
First day of last week 00:00:00		`last week start`
Last day of last week 23:59:59		`last week end`
Last working day of last week 23:59:59		`last week open end`
First day of last week 00:00:00 (US)		`last week start us`
Last day of last week 23:59:59 (US)		`last week end us`
First day of this week 00:00:00		`this week start`
Last day of this week 23:59:59		`this week end`
Last working day of this week 23:59:59		`this week open end`
First day of this week 00:00:00 (US)		`this week start us`
Last day of this week 23:59:59 (US)		`this week end us`
First day of next week 00:00:00		`next week start`
Last day of next week 23:59:59		`next week end`
Last working day of next week 23:59:59		`next week open end`
First day of next week 00:00:00 (US)		`next week start us`
Last day of next week 23:59:59 (US)		`next week end us`
First day of last quarter 00:00:00		`prev quarter start`
Last day of last quarter 23:59:59		`prev quarter end`
First day of this quarter 00:00:00		`this quarter start`
Last day of this quarter 23:59:59		`this quarter end`
First day of next quarter 00:00:00		`next quarter start`
Last day of next quarter 23:59:59		`next quarter end`
First day of last year 00:00:00		`prev year start`
Last day of last year 23:59:59		`prev year end`
First day of this year 00:00:00		`this year start`
Last day of this year 23:59:59		`this year end`
First day of next year 00:00:00		`next year start`
Last day of next year 23:59:59		`next year end`
Previous action result		`previous result result`
Previous action exit status		`previous result exist status`
Previous action nr		`previous result entry nr`
Previous action nr errors		`previous result nr errors`
Previous action nr lines input		`previous result nr lines input`
Previous action nr lines output		`previous result nr lines output`
Previous action nr lines read		`previous result nr lines read`
Previous action nr lines updated		`previous result nr lines updated`
Previous action nr lines written		`previous result nr lines written`
Previous action nr lines deleted		`previous result nr lines deleted`
Previous action nr lines rejected		`previous result nr lines rejected`
Previous action nr rows		`previous result nr rows`
Previous action stopped		`previous result is stopped`
Previous action nr files		`previous result nr files`
Previous action nr files retrieved		`previous result nr files retrieved`
Previous action log text		`previous result log text`

System date (variable)

System time, changes every time you ask a date.

system date (variable)

System date (fixed)

System time, determined at the start of the pipeline.

system date (fixed)

Start date range (Pipeline)

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

start date range

End date range (Pipeline)

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

end date range

Start date range (Workflow)

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

workflow start date range

End date range (Workflow)

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

workflow end date range

Yesterday 00:00:00

Start of yesterday.

yesterday start

Yesterday 23:59:59

End of yesterday.

yesterday end

Today 00:00:00

Start of today.

today start

Today 23:59:59

End of today.

today end

Tomorrow 00:00:00

Start of tomorrow.

tomorrow start

Tomorrow 23:59:59

End of tomorrow.

tomorrow end

First day of last month 00:00:00

Start of last month.

last month start

Last day of last month 23:59:59

End of last month.

last month end

First day of this month 00:00:00

Start of this month.

this month start

Last day of this month 23:59:59

End of this month.

this month end

First day of next month 00:00:00

Start of next month.

next month start

Last day of next month 23:59:59

End of next month.

next month end

Copy of transform

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

copy of transform

Pipeline name

Name of the pipeline.

This code has a leading white space: pipeline name

Pipeline file name

File name of the pipeline (XML only).

This code has leading white space : pipeline file name

User that modified the pipeline last

User modified

Date when the pipeline was modified last

Date modified

Hostname (Network setup)

Returns the hostname of the server.

Hostname

Hostname (Real)

Hostname real

IP address

Returns the IP address of the server.

IP address

Current process identifier (PID)

The PID under which the Java process is currently running

Current PID

JVM max memory

jvm max memory

JVM total memory

jvm total memory

JVM free memory

jvm free memory

JVM available memory

jvm available memory

Available processors

available processors

JVM CPU time (milliseconds)

jvm cpu time

Total physical memory size (bytes)

total physical memory size

Total swap space size (bytes)

total swap space size

Committed virtual size (bytes)

committed virtual memory size

Free physical memory size (bytes)

free physical memory size

Free swap space size (bytes)

free swap space size

First day of last week 00:00:00

last week start

Last day of last week 23:59:59

last week end

Last working day of last week 23:59:59

last week open end

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

last week start us

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

last week end us

First day of this week 00:00:00

this week start

Last day of this week 23:59:59

this week end

Last working day of this week 23:59:59

this week open end

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

this week start us

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

this week end us

First day of next week 00:00:00

next week start

Last day of next week 23:59:59

next week end

Last working day of next week 23:59:59

next week open end

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

next week start us

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

next week end us

First day of last quarter 00:00:00

prev quarter start

Last day of last quarter 23:59:59

prev quarter end

First day of this quarter 00:00:00

this quarter start

Last day of this quarter 23:59:59

this quarter end

First day of next quarter 00:00:00

next quarter start

Last day of next quarter 23:59:59

next quarter end

First day of last year 00:00:00

prev year start

Last day of last year 23:59:59

prev year end

First day of this year 00:00:00

this year start

Last day of this year 23:59:59

this year end

First day of next year 00:00:00

next year start

Last day of next year 23:59:59

next year end

Previous action result

previous result result

Previous action exit status

previous result exist status

Previous action nr

previous result entry nr

Previous action nr errors

previous result nr errors

Previous action nr lines input

previous result nr lines input

Previous action nr lines output

previous result nr lines output

Previous action nr lines read

previous result nr lines read

Previous action nr lines updated

previous result nr lines updated

Previous action nr lines written

previous result nr lines written

Previous action nr lines deleted

previous result nr lines deleted

Previous action nr lines rejected

previous result nr lines rejected

Previous action nr rows

previous result nr rows

Previous action stopped

previous result is stopped

Previous action nr files

previous result nr files

Previous action nr files retrieved

previous result nr files retrieved

Previous action log text

previous result log text