DF_QCfaxlog

DF_QCfaxlog — Examine the transmission date/time and status of faxed/emailed Query Reports

Synopsis

DF_QCfaxlog {study} [-l #] [-m string] [-s]

Description

DF_QCfaxlog displays journal entries from the study

A journal entry is written to for each Query Report transmission, by fax or email, that is attempted by DF_QCfax. If transmission is attempted to multiple destinations a separate record is written for each destination.

When a Query Report is sent to multiple destinations, the first destination in the list is considered to be the PRIMARY destination, and all others (if any) are considered to be secondary destinations. This is true whether the destination list is set in DF_QCfax using the -f option or by using the destinations listed in the Primary Fax field of the sites database. The keyword PRIMARY in a entry identifies a record for a primary destination.

For each destination, whether primary or secondary, a record is written to after all retries have been completed, that shows whether the transmission was successful. The keyword FAXED identifies a successful transmission, and the keyword FAILED identifies a failure. If the transmission to the primary destination is successful the log also shows the number of queries included in the report, and indicates that they have been updated to status sent in the Query database.

[Warning]Warning

Query Reports sent by email are always considered successful, because there is no accurate way to determine the ultimate success or failure of an email transmission.

The following excerpt from displays entries for a single Query Report that was successfully faxed to two different fax numbers and one email address.

001-170820  FAXED  to PRIMARY   905-555-9999  Mon Aug 20 11:14:38 2017 (marked 8 queries)
001-170820  FAILED to   905-444-1111  Mon Aug 20 11:15:38 2017
001-170820  FAXED  to mailto:dan@hotmail.com  Mon Aug 20 11:16:38 2017

These entries indicates that the Query Report, named 001-170820, was successfully sent to the first and third destinations, but failed to the second destination. Successful faxing to the first (PRIMARY) destination also caused the 8 queries in this report to be marked as sent.

If a Query Report is successfully sent to the primary destination, but it contains no queries, the log entry would indicate (marked 0 queries).

Records can be selected from with the -l and -m options. If both selection criteria are used, they are applied in the order specified; altering the order can produce different results, as illustrated by the last 2 examples below. If no selection criteria are specified, all reports listed in QC_NEW (i.e. reports created by the last execution of DF_QCreports) are selected.

Options

-l #

Include only the last # lines

-m string

Include only lines which match on the specified string; matching is case sensitive

-s

Sort the output by report ID rather than chronologically (default)

Examples

Example 2.48. Display the last 5 lines from

-l 5

DF_QCfaxlog: Transmittal Status for Query Reports.      DFstudy 7. Apr 01,2017 14:55

013-170322  FAXED  to PRIMARY    ###-####  Wed Mar 22 13:34:43 2017  (marked 100 queries)
013-170323  FAXED  to PRIMARY    ###-####  Thu Mar 23 13:06:51 2017  (marked   6 queries)
026-170323  FAXED  to PRIMARY    ###-####  Thu Mar 23 13:45:24 2017  (marked   4 queries)
009-170323  FAXED  to PRIMARY    ###-####  Thu Mar 23 14:16:56 2017  (marked  37 queries)
010-170323  FAXED  to PRIMARY    ###-####  Thu Mar 23 15:27:42 2017  (marked  84 queries)

Example 2.49. Display the status for all Query Reports created on 17/03/23, sorted by report ID

-s -m 170323


DF_QCfaxlog: Transmittal Status for Query Reports.      DFstudy 7. Apr 01,2017 15:00

009-170323  FAXED  to PRIMARY    ###-####  Thu Mar 23 14:16:56 2017  (marked  37 queries)
010-170323  FAXED  to PRIMARY    ###-####  Thu Mar 23 15:27:42 2017  (marked  84 queries)
013-170323  FAXED  to PRIMARY    ###-####  Thu Mar 23 13:06:51 2017  (marked   6 queries)
026-170323  FAXED  to PRIMARY    ###-####  Thu Mar 23 13:45:24 2017  (marked   4 queries)

Example 2.50. Display the last 20 FAILED transmissions

-m FAIL -l 20

Example 2.51. Display any FAILED transmissions among the last 20 transmissions registered

-l 20 -m FAIL

See Also

DF_QCfax