DFstatus
Prev 3.4. Alphabetical Listing Next

DFstatus

DFstatus — Display database status information in plain text format

Synopsis

DFstatus [-l] [-m] [-h] [-c] [-n #, #-#] [-i #, #-#] [-v #, #-#] [-p #, #-#] [-s #]

Description

This command-line invocation of the DFexplore Status View generates a tabular representation of the database status in plain text format and writes the results to standard output.

Options

-c

execute DFstatus in command-line mode. This option is retained for backward compatibility but is no longer necessary as DFstatus now runs only in command line mode.

-l

displays a list of current user logins with the hostname of the system running their DFdiscover applicataion.

-h

removes the title header when executed with the -l option.

-m

displays current seat usage statistics for the current DFdiscover server.

-n #, #-#

select only the requested site IDs for inclusion in the database status table. Default is all sites.

-i #, #-#

select only the requested subject IDs for inclusion in the database status table. Default is all subject IDs.

-v #, #-#

select only the requested visit numbers for inclusion in the database status table. Default is all visit numbers.

-p #, #-#

select only the requested plate numbers for inclusion in the database status table. Default is all plate numbers in the range 1 to 500, inclusive.

-s #

the study number (required unless -l or -m option is used).

Exit Status

DFstatus exits with one of the following statuses:

0

The command was successful.

36

The required command-line arguments were not present or were incorrectly specified.

> 0

The command failed because the database server could not be contacted, or communication with the database server failed.

Examples

Example 3.73. Display record status and current user connections for study 253

%  DFstatus -s 253
#Database Status of Study 253
#Date           Mon Mar 14 09:45:34 2011
#Sites
#Subjects
#Visits
#Plates
 Level       Pending        Missed    Incomplete         Final         Total
     0             7             0             0             0             7
     1             0             2            32            43            77
     2             0             0             4             2             6
     3             0             0             3             1             4
     4             0             0             1             7             8
     5             0             0             0             1             1
     6             0             0             0             0             0
     7             0             0             0             0             0
 Total             7             2            40            54           103

#Records awaiting validation: 18
#Records being validated: 0

#Connected Users
User             Program          Host
---------------- ---------------- ------------------------------
datafax          DFexplore        vncdemo.datafax.com
datafax          Status Tool      dhcp214.datafax.com

Example 3.74. Display current seat usage on the server

%  DFstatus -m
Seats in Use:
 Admin   2 of 10
 General 122 of 150
 Total   124 of 160

Prev Up Next
DFsqlload Home DFtextps