Hi Anusha-
Details on the VDB status are found under /source in the CLI and API. Here's an example request from a CLI session collecting the values you requested. In the following output, VDBs would be indicated where "virtual" is TRUE:
delphix-engine> source list display=name,runtime.status,runtime.activeInstances.0.hostName,mountBase,virtual
NAME RUNTIME.STATUS RUNTIME.ACTIVEINSTANCES.0.HOSTNAME MOUNTBASE VIRTUAL DBOMSRCECB2A RUNNING gi-rh75-base - false iotest RUNNING gi-rh75-base /mnt/provision true joyful RUNNING - - false dx99vvel5XXIt95QI7keQ_joyful RUNNING - /work/4213dcf3-bfdd-3848-397b-047a98cc5714-staging-1 false
Details on the
/source API can be found on your Engine by accessing the relevant API page (note, you will need to login to the usual Admin interface first to obtain an authenticated session)
http://delphix-engine/api/#SourceYou may also consider exploring
dxToolkit, a free utility developed and supported by our Services team. One of the dxToolkit utilities,
dx_get_db_env generates this report detail for you as well. Here's an example using commands from the page at
https://github.com/delphix/dxtoolkit/wiki/dx_get_db_envSeans-MacBook:dxtoolkit2 $ ./dx_get_db_env -engine seans-engine.delphix.com -type vdb Appliance Hostname Database Group Type SourceDB Parent snapshot Used(GB) Status Enabled Unique Name Parent time VDB creation time -------------------- -------------------- ------------------------------ --------------- -------- ------------------------------ ----------------------------------- ---------- ---------- ---------- ------------------------------ ----------------------------------- ----------------------------------- seans-engine.delphix seanora122tgt iotest Oracle VDB DBOMSRCECB2A 2019-03-14 14:58:55 PDT 1.45 RUNNING enabled iotest N/A 2019-03-14 16:17:47