HCL Workload Automation, Version 9.4

PLAN_WORKSTATIONS_V

The PLAN_WORKSTATIONS_V view displays information about workstations in the plan.
Table 1. The PLAN_WORKSTATIONS_V view
Column name Description Type Length
Workstation_id The identifier of the workstation. character 16
Domain_id The identifier of the domain of the workstation specified in the Workstation_id column. character 16
Host_workstation_id The identifier of the workstation that hosts the workstation specified in the Workstation_id column. character 16
Method The name of the access method for extended agents workstations. string 40
Workstation_type The workstation type status. Possible values are:
M
Manager
F
FTA
X
XA
S
SA
B
Broker
A
Agent
L
Pool
Y
Dynamic_pool
E
Remote_engine
character 1
Behind_firewall If the workstation in behind the firewall. Possible values are:
Y
Yes
N
No
character 1
Fence The job fence for the workstation specified in the Workstation_id column. integer 3
Agent_initialized If the jobman process is initialized. Possible values are:
Y
Yes
N
No
character 1
Agent_running If the jobman process is running. Possible values are:
Y
Yes
N
No
character 1
Limit The total number of jobs that can be run concurrently on the workstation specified in the Workstation_id column. integer 4
Link_status The workstation link status. Possible values are:
L
Linked
U
Unlinked
F
Fully_linked
N
Not_applicable
character 1
Workstation_name The name of the workstation. string 16
Node_name The node name of the workstation. string 51
Ssl_communication The workstation SSL communication level. Possible values are:
O
On
N
None
E
Enabled
F
Force
H
Http
S
Https
character 1
Mailman_server The name of the mailman server responsible for the Workstation_id on the domain manager. It is for fault-tolerant and standard agents only. character 1
Ssl_port The number of the secure port to be used for SSL communication. integer 5
Monitor_config_updated If the monitor configuration is updated. Possible values are:
Y
Yes
N
No
character 1
Start_time The date and time when the batchman process was started on the workstation. timestamp 10
Run_number The run number of the current plan running on the workstation. This is used to synchronize the workstations in a HCL Workload Automation network. integer 10
Node_port The port number of the workstation. integer 5
Time_zone The time zone set on the workstation. string 40
Node_information The operating system information of the workstation. string 64
Version The HCL Workload Automation version that runs on the workstation. string 8
Writer_running If the writer is running. Possible values are:
Y
Yes
N
No
character 1
Event_processor If the event processor is running. Possible values are:
Y
Yes
N
No
character 1
Event_monitoring If the event monitoring is running. Possible values are:
Y
Yes
N
No
character 1