Smarts NCM: How do I tell how many entries there are in a Smarts NCM (Voyence) database table?

Products

• VMware Smart Assurance

Environment

VMware Smart Assurance - NCM

Resolution

How do I tell how many entries there are in a Smarts Network Configuration Manager (Smarts NCM/Voyence) database table?

To tell how many entries there are in a Smarts NCM database table, do the following:

1. Launch a command prompt window and log into the postgres as follows:
   
   su - pgdba
   psql voyencedb voyence
   
   
2. Once logged in run the following:

3. select count(*) from <table>;

   Example

   select count(*) from cm_device;

   (Where the name of the table is cm_device.)
   
   The output of this command would be as follows:

   voyencedb=# select count(*) from voyence.cm_device;
    count
   -------
        4
   (1 row)