beautypg.com

HP Neoview Release 2.4 Software User Manual

Page 69

background image

Dimensions

:

Description

Filter

Select application IDs from the list. Click on the icon at the right
side of the blank field for a list of IDs.

Applications

Select client IDs from the list. Click on the icon at the right side
of the blank field for a list of IDs.

Clients

Select data sources from the list. Click on the icon at the right
side of the blank field for a list of data sources.

DataSources

Custom date and time field. Click the icon at the right side of the
blank field for a list of options.

TimePeriod

Select user name from the list. Click on the icon at the right side
of the blank field for a list of IDs.

Users

Facts

:

Description

Filter

Custom Neoview qualifier (Neoview platform filter).

Custom_Filter

The elapsed time equal to or more in the format hh:mm:ss
(client-side filter). You can either filter on the elapsed time or
you can filter on queries that ran with periods of time. The period
of time can be specified as a relative time value or an absolute
value.

Elapsed_Time

Indicates whether to filter statements with errors (client-side
filter). Choices are Yes, No, or Any.

Error

Lower limit for estimated query cost.

Estimated_Cost

Filter on number of insert, update, and delete operations.

IUD_Count

Minimum number of rows retrieved.

Row_Count

Minimum number of rows accessed.

Rows_Accessed

Filter based on the query state (client-side filter). Choices are
Any

, Completed, Error, Running, or Abnormally Terminated.

State

A free format text box that allows you to filter on query text
containing some value. You can use a wildcard character on one
or more characters using the % or * symbols. For a single
character wildcard, use the ? or _ symbols.

Text

Indicates the SQL statement type (client-side filter). Choices are:
Any

, Select, Insert, Delete, Update, Call, DDL, Management,

Control

, or Other.

Type

Identifiers

:

Description

Filter

Filter based on query ID.

Query_ID

Filter based on session ID.

Session_ID

If you enter more than one filter criteria, the operation is translated to an AND operation.

Filter the Queries

69