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

• SSH to the vRA node as?root
• Connect to the vRA DB: vracli dev psql?

(type yes for the session to be recorded)?????????????????????????

• Navigate to?the catalog-db : \c catalog-db
• ?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';?
• ?Exit???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
• This will return an output the VM name and its origin status from vRA as below (examples from my lab)???: