Filtering Processes

Built-in Filters

Default filters are already available:

For the processes monitor:

All (Non-Maintenance) Processes - This includes processes from definitions that do not have the Maintenance property set.
For the Last 24 Hours - This includes processes that have been scheduled to run over the last 24 hours.
For the Next 24 Hours - This includes processes that have been scheduled to run over the next 24 hours.
For a Window of 24 Hours - This includes processes that have been schedule to run between the last 12 hours and the next 12 hours.
For the Last 7 Days - This includes processes that have been scheduled to run over the last 7 days.
For the Next 7 Days - This includes processes that have been scheduled to run over the next 7 days.
For a Window of 7 Days - This includes processes that have been schedule to run between the past 84 hours and the next 84 hours.
In an Initial State - This include processes with a status of either New or Scheduled. It excludes standard or custom maintenance processes.
In a Pending State - This includes processes with a status of Chained, queue Held, EventWait, LockWait, Queued, Dispatched, Assigned, or Canceling. It excludes standard or custom maintenance processes.
In an Active State - This includes a process with a status of Running, Waiting, or Killing. It excludes standard or custom maintenance processes.
In a Final State - This includes a process with a status of Skipped, Disabled, Ignored, Unknown, Completed, Error, Killed, or Canceled. It excludes standard or custom maintenance processes.
In a Console State - This includes a process with a status of either Restart or Console. It excludes standard or custom maintenance processes.
In a Console State (Include Child Processes) - This includes a process that has a status of either ConsoleRestart or Console. It excludes a standard or custom maintenance process.
In a Manual Intervention State (Include Child Processes) - This includes a process that has a status of Never, Overdue, ConsoleRestart, Held, Modified, Console, or that has an operator message as well as any child processes of the process. It excludes a standard or custom maintenance process.
In a Manual Intervention State - This includes a process that has a status of Never, Overdue, ConsoleRestart, Held, Modified, Console, or that has an operator message that requires a reply and has not been replied to. It excludes a standard or custom maintenance process.
With Status "Error" - This includes a process that has reached status Error.
With Status "Completed" - This includes a process that has reached status Completed.
With Status "Overdue" - This includes a process that has reached status Overdue.
With Status "Running" - This includes a process that has reached status Running.
With Status "Never" - This includes a process that has been scheduled to run more than 2 years in the future or for which the scheduling criteria cannot met, for example, there is no running process server capable of executing it in its queue.
All Process Resolutions - This includes a process that has been scheduled and that have not yet started.
Not current master - This includes a processes of which the definition has changed.
Delayed in remote system - This includes a process that has been delayed in a remote system.
Custom Maintenance (Background) Processes - This includes system (non-housekeeping) processes and processes from definitions that have the Maintenance property set.
Standard Maintenance (Background) Processes - This includes standard housekeeping processes.

note

Child processes are usually included in standard monitor filters for which an ancestor matches the filter, the only exceptions being filters In a Console State and In a Manual Intervention State.

Custom Filters

You can also define your own filters using a subset of the conditions listed below. Each condition can have one or more values. For each value entered, conditions can be used to show or hide specific processes.

The following conditions can be used to create customized filters:

Where the process has no parent
Where the process is for maintenance
Where the description contains specific keywords
Where the process is on a Process Server
Where the process is in Queue
Where the Remote System name contains specific keywords
Where the Remote Status contains text
Where the process was scheduled to Start less than some time ago
Where the Run Date was less than some time ago
Where the End Date was less than some time ago
Where the process time field is before relative date/time in time zone
Where the process time field is after relative date/time in time zone
Where the process ran/runs in the current 24-hour period starting/ending at time in time zone
Where the process has Status
Where the process is from Process Definition
Where the process is from a Process Definition whose name starts with prefix
Where the process is from a Process Definition whose name contains specific keywords
Where the process is of Definition Type
Where the process belongs to Application
Where the process belongs to Application containing specific keywords
Where the Priority is value
Where the process is scheduled to Start within the last time period or within the next time period
Where the process is scheduled to start after date
Where the process is Owned by user or role
Where the process complies with IntelliSearch search string
Extend filter with user-defined SQL

tip

When parent and descendant processes match a filter, the descendants will be listed multiple times. Once for matching the filter and once more for being a descendant of a process that matches the filter. You use the Where the process has no parent condition to only display them once, as descendants of a process matching the filter.

Relative Date/Time

The following filters can be defined based on time expressions.

Where the process time field is before relative date/time in time zone
Where the process time field is after relative date/time in time zone

The time field is any of the following process DateTimeZone fields. Default is ScheduledStartTime.

KeepExpiration
LastModificationTime
LastStatusChangeTime
NextSubmitBaseTime
RemoteCreationTime
RemoteRunEnd
RemoteRunStart
RunEnd
RunStart
RuntimeExpiration
ScheduledStartTime (default)

The relative date/time criterion (Required, no default) is either:

A time (defaults to current system time) with a positive or negative offset of days from today. Example: Time: 10:51:32 AM, offset: -, days: 7 -> last seven days, starting at 10:51:32 AM 7 days ago)
A time expression as accepted by Time.expressionNow().

The time zone criterion defaults to the user's time zone, accepts a valid time zone from the list.

User Defined SQL

You can use the ANSI SQL92 standard where-clause syntax, for user defined SQL, you have to omit the where keyword. See the Filter Columns section for a list of columns.

Using User Defined SQL to display all processes with a id above 12345 except standard maintenance (housekeeping) processes:

JobId > 12345 and Behavior <> 2

The Behavior column can be used to differentiate maintenance processes from others, maintenance processes have a behavior set to 2 (standard maintenance, processes doing housekeeping activities) or 3 (custom maintenance). You can combine the different preset and user defined clauses, so Where the process is for maintenance Standard on the Include tab is equivalent to Behavior = 2 and Where the process is for maintenance Custom_ on the Include tab is equivalent to Behavior = 3.

The above example using the Where the process is for maintenance and Extend filter with user-defined SQL on the Include tab:

[x] Where the process is for maintenance Standard [x] Extend filter with user-defined SQL with the below WHERE clause in user-defined SQL

JobId > 12345

Procedure

Defining a filter

Navigate to "Monitoring > Processes".
Choose Filter > New Filter from the context-menu.
Specify a name, a description (display name), and a number of conditions that are to be met.
For each condition, specify one or more values by choosing the blue text.
1. In the new window you must choose Add for each value of a condition.
2. Choose OK to close the window.
Choose Save and Close.

Product Documentation

Built-in Filters

note

Custom Filters

tip

Relative Date/Time

User Defined SQL

Procedure

See Also