Database queries to check device details

Products

• VMware Smart Assurance

Issue/Introduction

This article addresses the following questions:

1. How to query the device OS description and other details from Smarts NCM database;
2. How to get details on devices that have been unmanaged in Smarts NCM but not removed from the database

Environment

NCM - 10.1.X

Resolution

To query the device OS description, device status, device name and device IP address from the Smarts NCM database, do the following:

 

1. Login to NCM DB by using the command:
       su - pgdba
2. Now enter below command:
        psql voyencedb voyence
3. Give the db password which you had set during the time of installation of the product.
4. Enter the below query:
   

   select os_description, device_status, device_name, management_ip_address from cm_device;