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

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

book

Article ID: 303497

calendar_today

Updated On:

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)