Workflow Insights Filters

Each Workflow Insights dashboard displays aggregates of metrics of your Control-M workflows, such as when a job executes some of the saved metrics include: job name, folder, Application, Sub-Application, Control-M/server, execution start time, execution stop time, end status. These sets of metrics are called Filters. You can filter the data by the metric fields to view more focused and relevant insights.

The following table describes the available filters for each Workflow Inisights dashboard:

Dashboard	Available Filters
Workflow Health	Job Execution Filters
Workflow Trends and Peak Volumes	Job Execution Filters Job Run Filters The first step in defining a filter for this dashboard is to select the filter index you want to work with.
Workflow Distribution	Job Execution Filters
Workflow Alerts	Alerts Filter
Workflow Definition Updates	Definition Updates Filter
SLA Management Services	SLA Service Filters
Optimization Insights	Job Execution Filters
Job Executions	Job Execution Filters

Job Execution Filters

The Job Executions filter includes the following fields:

Field	Description
Application	Shows the job executions with the specified Application.
EndTime	Shows the job executions with the specified end date and time.
EndedStatus	Shows the job executions with the chosen end status: EndedOK EndedNotOK
ExecutedDay	Shows the job executions with the specified start date and time in Elasticsearch Keyword Format to allow aggregation.
ExecutionEndHour	Shows the job executions that ended at the specified hour.
ExecutionEndHour.integer	Shows the job executions that ended at the specified hour in integer format.
ExecutionStartHour	Shows the job executions that started at the specified hour.
ExecutionStartHour.integer	Shows the job executions that started at the specified hour in integer format.
Folder	Shows the job executions with the specified folder.
Host	Shows the job executions with the specified host.
JobName	Shows the job executions with the specified job name.
JobType	Shows the job executions with the specified job type.
RunCount	Shows the job executions with the specified number of executions.
RunDate	Shows the job executions with the specified run date in UTC Epoch Format, for example: 2021-08-02T00:00:00.000+03:00 The run date is not calculated according to Control-M New Day time setting, unless the New Day is set to midnight.
RunDay	Shows the job executions with the specified run date in Elasticsearch Keyword Format to allow aggregation. The run date is not calculated according to Control-M New Day time setting, unless the New Day time setting is set to midnight.
RunId	Shows the job executions with the specified unique ID (Run ID).
RunTime	Shows the job executions with the specified duration in milliseconds. This field is calculated from end and start time.
Server	Shows the job executions with the specified Control-M/Server.
Services	Shows the job executions with the specified SLA Management.
StartTime	Shows the job executions with the specified start date and time.
SubApplication	Shows the job executions with the specified Sub-Application.
TaskType	Shows the job executions with the specified task type.
_id	Internal Elasticsearch field
_index	Internal Elasticsearch field
_type	Internal Elasticsearch field

Job Run Filters

The Job Run filter includes the following fields:

Field	Description
Application	Shows the job runs with the specified Application.
Folder	Shows the job runs with the specified folder.
Host	Shows the job runs with the specified host.
id	Shows the job runs with the specified folder Run ID (composed of the Control-M/Server:RunId:RunCount job fields).
JobName	Shows the job runs with the specified job name.
JobType	Shows the job runs with the specified job type.
RunCount	Shows the job runs with the specified run count.
RunDate	Shows the job runs with the specified run date in UTC Epoch Format, such as: 2021-08-02T00:00:00.000+03:00 The run date is not calculated according to the Control-M New Day time setting, unless the New Day time is set to midnight.
RunDay	Shows the job runs with the specified run date in Elasticsearch Keyword Format, to allow for aggregation.
RunId	Shows the job runs with the specified Run ID.
Server	Shows the job runs with the specified Control-M/Server.
SubApplication	Shows the job runs with the specified Sub-Application.
TaskType	Shows the job runs with the specified task type.
_id	Internal Elasticsearch field
_index	Internal Elasticsearch field
_type	Internal Elasticsearch field

Alerts Filter

Field	Description
AlertCloseTime	Shows the alerts that were closed at the specified time.
AlertOpenTime	Shows the alerts that were triggered at the specified time.
AlertStatus	Shows the alerts with the specified record status: Open Closed Every alert that was triggered creates two documents in Elasticsearch. The first when the alert was opened, and the second when the alert was closed.
AlertType	Shows the alerts with the specified type (the entity that generated the alert): Job System The Workflow Alerts Dashboard shows insights about job alerts only.
Application	Shows the Application of the job that triggered the alert.
Host	Shows the host of the job that triggered the alert.
JobKey	Shows the job key of the job that triggered the alert. The job key is composed of the Control-M/Server:Application:SubApplication:JobName fields
JobName	Shows the job name of the job that triggered alert.
Message	Shows the job that triggered the alert with the specified alert message. The message is a text field that allows better searching capabilities for alert message content.
Server	Shows the Control-M/Server of the job that triggered the alert.
SubApplication	Shows the Sub-Application of the job that triggered the alert.
Urgency	Shows the alert urgency of the triggered alert: Normal Urgent Critical
_id	Internal Elasticsearch field
_index	Internal Elasticsearch field
_type	Internal Elasticsearch field
Message.keyword	Shows the alert message defined in the job. The Message.keyword is a Keyword type field that is used to create the most common alert messages aggregation.

Definition Updates Filter

The Definition Updates filter includes the following fields:

Field	Description
Application	Shows the Application of the folder or job that was changed.
Folder	Shows the folder of the job that was changed.
Host	Shows the host of the job that was changed.
Name	Shows the name of the folder or job that was changed.
Server	Shows the Control-M/Server of the folder or job that was changed.
SubApplication	Shows the Sub-Application of the folder or job that was changed.
Type	Shows the type of the folder or job that was changed.
UpdateTime	Shows the definition change time. The value is in UTC Epoch Format, for example: 2021-08-02T00:00:00.000+03:00
UpdateType	Shows the definition change type: Add Delete Modified
UpdateEntityType	Shows the entity type that was changed: Folder Job
User	Shows the user that checked in the definition change.
_id	Internal Elasticsearch field
_index	Internal Elasticsearch field
_type	Internal Elasticsearch field

SLA Service Filters

The following table describes the available fields for the SLA Service filter index.

Field	Description
Application	Shows the Application of the job that affects the Service critical path completion in both duration and time gap. (the job after the time gap).
ApplicationPre	Shows the Application of the job that preceded the time gap and that affects the Service critical path completion.
EndTime	Shows the end time of the SLA Management Service execution. The value is in UTC Epoch Format, such as: 2021-08-02T00:00:00.000+03:00
EndedStatus	Shows the SLA Management Service executions with the specified end status: EndedOK EndedLate
Folder	Shows the folder of the job that affects the Service critical path completion in both duration and time gap, (the job after the time gap).
FolderPre	Shows the folder of the job that preceded the time gap and affects the Service critical path completion.
Gap	Shows the time in milliseconds, between predecessor job end time and successor job start time.
Host	Shows the host of the job that affects Service critical path completion in both duration and time gap, (the job after the time gap).
HostPre	Shows the host of the job that preceded the time gap and affects the Service critical path completion.
JobName	Shows the name of the job that affects Service critical path completion in both duration and time gap, (the job after the time gap).
JobNamePre	Shows the name of the job that preceded the time gap and affects the Service critical path completion.
JobRunId	Shows the job run ID of the jobs that are part of the Service critical path.
JobRunTime	Shows the run time of jobs that are part of the Service critical path.
NumJobs	Shows the number of jobs in the SLA Management Service.
RunTime	Shows the SLA Management Service run time.
Server	Shows the Control-M/Server of the job that affects the Service critical path completion in both duration and time gap, (the job after the time gap).
ServerPre	Shows the Control-M/Server of the job that preceded the time gap and affects the Service critical path completion.
ServiceExecutionKey	Shows the unique ID for the Service execution.
ServiceName	Shows the name of the SLA Management Service (SLA Management job).
ServiceRecordType	Internal Elasticsearch field that holds the Service record type: Service, Critical job or Gap.
SlackTime	Shows the Service Slack time. Slack time is how long a job can be delayed beyond its earliest start point without causing any problems in the completion of the workflows due date and time.
StartTime	Shows the start time of the SLA Management Service execution. The value is in UTC Epoch Format, for example: 2021-08-02T00:00:00.000+03:00
SubApplication	Shows the Sub-Application of the job that affects the Service critical path completion in both duration and time gap, (the job after the time gap).
SubApplicationPre	Shows the Sub-Application of the job that preceded the time gap and affects the Service critical path completion.
_id	Internal Elasticsearch field
_index	Internal Elasticsearch field
_type	Internal Elasticsearch field