Table Row Counts Report

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > Standard Reports > Database Metrics >

Table Row Counts Report

Report Name: Table Row Counts (example)

File Name: EarthSoft.Reports.Library.18095.dll

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

 

Description: The Table Row Counts Report generates the total number of rows per table in the database (TOTAL_ROWS), the number of these rows in the current FACILITY_ID or facility group (IN_FACILITY), the number of reference values per reference table with STATUS_FLAG = "A" and "R" (STATUS_FLAG_A and STATUS_FLAG_R, respectively).

 

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.

 

 

Report Parameters

Tables

Select one or more tables. No selection will return all tables.

 

Report Output

TABLE_NAME

TOTAL_ROWS

IN_FACILITY

STATUS_FLAG_A

STATUS_FLAG_R

 

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.