Viewing database row counts

In the Administration Console, select Database > Count Rows.

On the Count Rows in Business Classes form, specify this information:

Include

Select the tables for which to count rows. These are the options you can select:

All: Count rows in all tables.
Module: Count rows in all tables within a specified module.
Business Class: Count rows in all tables for a specified business class.
Other: Count rows in all tables that match a file name pattern. For example, you can specify Action* for all business classes with names that begin with Action.

Subdirectory

To export the row count report to a sub-directory of the FTP site directory, specify that directory.

Command Output Filename

Specify a name for the command output file to override the default value of dbcount.txt.

Suppress Business Classes with No Rows

Select this check box to exclude business classes with no rows from the report.

Show Total Rows for All Business Classes

Select this check box to include the total count of rows for all business classes in the report.

Include User Business Classes

Select this check box to include the count for user business classes in the report.

Only User Business Classes

Select this check box to include only the count for user business classes in the report. All delivered business classes are ignored.

Include Delete Count

Select this check box to include a count of rows associated with logically deleted business objects in the report.

Filter

Limit the count of rows based on the specified filter value for the index keys of the table.

Click Submit to process the database row count immediately or Schedule to schedule the database row count.