Sybase 12.5.1, User Manual

Page: 68 / 210

hs_create_filter
54
Historical Server
• For each key data item:
• Name of the data item
• Value of that data item for the row of sample data that
triggered the alarm
• When an alarm condition occurs and alarm_action is
execute
, the
specified file is executed by the account that started Historical Server,
not by the account that created the alarm. This means that the access
privileges of the person who starts Historical Server are available to
users who define alarms.
Warning!
It is possible that a user who normally cannot execute a file
can execute that file through an Historical Server alarm.
hs_create_filter
Description Specifies filtering criteria on a data item. A filter limits the scope of
collected data for a single data item in a view. Filters are optional.
Syntax hs_create_filter view_name, data_item_name, data_item_stat,
filter_type, value_spec
Parameters view_name
name of the view that contains the data item to filter.
data_item_name
data item to which the filter applies. If the data item contains embedded
spaces, surround it with quotation marks.
data_item_stat
statistic type for data_item_name. The data_item_name and
data_item_stat combination must exist in the view definition. Surround
the statistic type with quotation marks.
filter_type
type of filter to use. Valid values are:
•
eq
– passes values that match any of a list of values. That is, a value
passes the filter if it equals the first filter value, or the second filter
value, or any other value in the list. Specify the list of values in the
value_spec parameter.