How to generate/list managed/onboarded/discovered VM's in vRA 8.x

Products

• VMware Aria Suite

Issue/Introduction

The article will help you to generate/list the VM's with status managed/onboarded/discovered in VRA.
Currently, there is no option to export that data directly from the vRA 8.x UI.

Environment

VMware vRealize Automation 8.x

Resolution

We can generate the list by running the below DB query against catalog-db in vRA Database.

Note: Take snapshots of all nodes of vRA as a precautionary measure. Please contact VMware Support if not confident to carry out the below steps.

1. SSH to the vRA node as root
2. Connect to the vRA DB:
    vracli dev psql 
    (type yes for the session to be recorded)                                                
3. Navigate to  the catalog-db :
    \c catalog-db
4.  Run the below query to list all VM resources with their name and origin status:
    select name,state,origin from dep_resource where type='Cloud.vSphere.Machine'; 
5.  Exit the database:\q                                                                                                                                                                                                                                                                                                            This will return an output the VM name and its origin status from vRA as below (examples from my lab)