DF_QCfaxlog — Examine the transmission date/time and status of faxed/emailed Query Reports
DF_QCfaxlog
{study}
[-l #]
[-m string]
[-s]
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 |
|---|---|
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.
-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) |
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.51. Display any FAILED transmissions among the last 20 transmissions registered
-l 20 -m FAIL