How to list the number of models of each model type within SpectroSERVER database via CLI?

Products

• CA Spectrum

Issue/Introduction

How to list the number of models of each model type within SpectroSERVER database via CLI?

You may want to know how many models of each model type within your SpectroSERVER database to understand the composition of models within your Spectrum system or to find certain model types that contribute much to the size of SpectroSERVER database.

Environment

Release: Any
Component: SPCCSS

Resolution

To list the number of models of each model type within SpectroSERVER database via CLI

1. Log into the SpectroSERVER system as the user that owns the Spectrum installation

2. If on Windows, start a bash shell by running "bash -login"

3. cd to the $SPECROOT/vnmsh.sample_scripts directory and execute the following command where <HOST> is the hostname of this system (not the fully qualified hostname):

./database_tally <HOST>

4. Output will be printed to the screen

NOTE: You can redirect the output to a file by entering the following command:

./database_tally <HOST> > dbtally.out

This will output the data to a file called dbtally.out in the $SPECROOT/vnmsh.sample_scripts directory.

Additional Information

Please reference the "database_tally Script" section of the documentation for more information.