Smarts NCM: How to find severity of a Regex Test from database?

Products

• VMware Smart Assurance

Environment

VMware Smart Assurance - NCM

Resolution

Login to NCM Combination/Database server with root privileges:
1) Switch to pgdba user with following command:
      su - pgdba
2) Login to postgres DB with below command:
     psql voyencedb voyence 
3) When prompted for password, enter the Database password.
4) To view severity on a particular Regex Test, execute below query:
     select severity,test_name from cm_compliance_audit_test where test_name like  <Regex Test Name>';
   
     Ex:
     voyencedb=# select severity,test_name from cm_compliance_audit_test where test_name like 'Complaince_Test_default-TST';
     severity |          test_name
     ----------+-----------------------------
               3 | Complaince_Test_default-TST
     (1 row)
     voyencedb=#

5) To know the available severities to set on a Regex Test, execute below query:
     select stringkey,stringvalue from  voyence.md_compliance_severity_translation;
   
      Ex:
      voyencedb=# select stringkey,stringvalue from  voyence.md_compliance_severity_translation;
      stringkey | stringvalue
       -----------+-------------
          0         | Unknown
          1         | Information
          2         | Warning
          3         | Minor
          4         | Major
          5         | Critical
      (6 rows)
      voyencedb=#