Hvreventview

  Since    v5.5.5/2  

Contents

Name

hvreventview - Display events from hvr_event and hvr_event_result

Synopsis

hvreventview [-h class] [-u user] [-optshubdb

Description

Command hvreventview displays events and their results from the catalog tables - hvr_event and hvr_event_result.

Options

This section lists and describes all options available for hvreventview.

ParameterDescription
-bbegin_idDisplay only events with event ids newer than begin_id. Value begin_id must have form YYYY-MM-DD HH:MM:SS[.MSECS]YYYY-MM-DDTHH:MM:SS[.MSECS]+TZD or YYYY-MM-DDTHH:MM:SSZ[.MSECS].

-Bbegin_updated
  Since    v5.5.5/5   

Display only events which were updated since begin_updated. Value begin_updated must have form YYYY-MM-DD HH:MM:SS[.MSECS] YYYY-MM-DDTHH:MM:SS[.MSECS]+TZD or YYYY-MM-DDTHH:MM:SSZ[.MSECS].
-cchnDisplay only events for channel chn. This option can be supplied multiple times.
-CDisplay only the current event. This is either the earliest event with state PENDING or, if no such event exists, the latest event with state DONE or FAILED. This option requires -j.
-eend_idDisplay only events with event ids older than end_id. Value end_id must have form YYYY-MM-DD HH:MM:SS[.MSECS]YYYY-MM-DDTHH:MM:SS[.MSECS]+TZD or YYYY-MM-DDTHH:MM:SSZ[.MSECS].

-Eend_updated
  Since    v5.5.5/5  

Display only events which were updated before end_updated. Value end_updated must have form YYYY-MM-DD HH:MM:SS[.MSECS]YYYY-MM-DDTHH:MM:SS[.MSECS]+TZD or YYYY-MM-DDTHH:MM:SSZ[.MSECS].
-fFollow mode. Displays events that get updated after hvreventview was invoked. Runs in an endless loop. If specific event ids are specified with -i, then it terminates as soon as all of these events have state DONE.
-hclassHub class, for connecting to hub database.
-iev_idDisplay only event with event id ev_id. This option can be supplied multiple times.
-jjob_nameDisplay only events for job job_name. This option can be supplied multiple times.

-lloc
  Since    v5.5.5/5  

Display only event results for either source or target location loc. This option can be supplied multiple times. This option requires -r or -R.
-Lloc

Display only event results for target location loc. This option can be supplied multiple times. This option requires -r or -R.

This option is not available since HVR 5.5.5/5.

-nresDisplay only latest event plus results where one of the results matches res.

-Nnum
  Since    v5.5.5/5  

Display only the number of events specified in num. This option displays only the latest events. For example, if -N5 is supplied then it displays the latest 5 events.
-oofileWrite output to file ofile instead of displaying it.
-rAlso display results from events. All results are shown except ones starting whose name starts with '_' (these are advanced/internal).
-Rres_pattDisplay only event results with result names matching res_patt. Value res_patt may contain alphanumerics and any of the symbols '*', '?', '|', '_' and '-'. This option implies -r. To see all results (including advanced/internal results starting with '_') use -R *.
-sstateDisplay only events with state state. Value state may be PENDINGDONE or FAILED. This option can be supplied multiple times.
-Sbody_pattDisplay only events with contents of body matching body_patt. Value body_patt may contain alphanumerics and any of the symbols '*', '?', '|', '_' and '-'.
-ttblDisplay only event results for table tbl. This option can be supplied multiple times.
-Ttype_pattDisplay only events with event types matching type_patt. Value type_patt may contain alphanumerics and any of the symbols '*', '?', '|', '_' and '-'.
-uuser[/pwd]Connect to hub database using DBMS account user. For some databases (e.g. SQL Server) a password must also be supplied.

Example

To display all pending refresh events for channel test_channel for the 12th of december 2018, use the following;

hvreventview -b "2018-12-12T00:00:00.000Z" -e "2018-12-12T23:59:59.000Z" -c test_channel -s PENDING -T Refresh myhub/myhubpwd

To monitor all compare events as they run, including their results, use the following;

hvreventview -f -T Compare myhub/myhubpwd