# Nexpose Dynamic Discovery VMWARE - Hosts list?

**URL:** <https://discuss.rapid7.com/t/nexpose-dynamic-discovery-vmware-hosts-list/3576>\
**Category:** InsightVM\
**Created:** [February 17, 2021, 10:42am UTC](https://discuss.rapid7.com/t/nexpose-dynamic-discovery-vmware-hosts-list/3576 "2021-02-17T10:42:36Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![nicolas\_designori](https://discuss.rapid7.com/letter_avatar_proxy/v4/letter/n/4491bb/32.png) [@nicolas\_designori](https://discuss.rapid7.com/u/nicolas_designori)\
**Post date:** [February 17, 2021, 10:42am UTC](https://discuss.rapid7.com/t/nexpose-dynamic-discovery-vmware-hosts-list/3576/1 "2021-02-17T10:42:36Z")

</div>

Hi there,

On Nexpose, the /discoveryAsset/assetStatistics.jsp screen provides us with statistics after the syncing of Nexpose and Vsphere.  
Number of virtual machines/number of hosts…all good

We can then get access to virtual machine information on the same screen or through the site you can create, but how do we get access to the hosts list ?

Thanks for your responses

Nicolas  
Nice/France

---

<div class="post-metadata">

**Author:** ![tyler\_schmidtke](https://discuss.rapid7.com/user_avatar/discuss.rapid7.com/tyler_schmidtke/32/226_2.png) [@tyler\_schmidtke](https://discuss.rapid7.com/u/tyler_schmidtke)\
**Post date:** [February 17, 2021, 3:02pm UTC](https://discuss.rapid7.com/t/nexpose-dynamic-discovery-vmware-hosts-list/3576/2 "2021-02-17T15:02:32Z")

</div>

@nicolas_designori,

I’m not aware of a way to explicitly get the Vsphere hosts that are added as part of the discovery connection. You could try using an asset group to match on an operating system of `VMware` or similar. That might get close to the results that you’re looking for if I understand correctly.

---

<div class="post-metadata">

**Author:** ![nicolas\_designori](https://discuss.rapid7.com/letter_avatar_proxy/v4/letter/n/4491bb/32.png) [@nicolas\_designori](https://discuss.rapid7.com/u/nicolas_designori)\
**Post date:** [February 18, 2021, 8:52am UTC](https://discuss.rapid7.com/t/nexpose-dynamic-discovery-vmware-hosts-list/3576/3 "2021-02-18T08:52:31Z")

</div>

Thanks for your response Tyler.

We do have a Tag with that filter but it captures what we had discovered by an IP discovery scan (network) only…  
We are trying the leverage out the dynamic aspect of the VsphereConnection. As the count of hosts is shown it means that this was learned through the connection process. Could there be a SQL table I could query through a report? Do you know?

---

<div class="post-metadata">

**Author:** ![tyler\_schmidtke](https://discuss.rapid7.com/user_avatar/discuss.rapid7.com/tyler_schmidtke/32/226_2.png) [@tyler\_schmidtke](https://discuss.rapid7.com/u/tyler_schmidtke)\
**Post date:** [February 18, 2021, 2:35pm UTC](https://discuss.rapid7.com/t/nexpose-dynamic-discovery-vmware-hosts-list/3576/4 "2021-02-18T14:35:52Z")

</div>

There is a [dim\_host\_type](https://docs.rapid7.com/insightvm/understanding-the-reporting-data-model-dimensions#dim_host_type) table which provides the following classifications for hosts:

```auto
Virtual Machine
Hypervisor
Bare Metal
Mobile
Unknown

```

I don’t know for certain how the values are populated, so I can’t say if the `Hypervisor` type will be applied to the Vsphere hosts from the discovery connection, but give this query a go and let me know how it works.

```auto
SELECT da.asset_id, da.ip_address, da.host_name, dht.description
FROM dim_asset da
JOIN dim_host_type dht on da.host_type_id = dht.host_type_id WHERE description = 'Hypervisor';

```

---

<div class="post-metadata">

**Author:** ![nicolas\_designori](https://discuss.rapid7.com/letter_avatar_proxy/v4/letter/n/4491bb/32.png) [@nicolas\_designori](https://discuss.rapid7.com/u/nicolas_designori)\
**Post date:** [February 18, 2021, 4:43pm UTC](https://discuss.rapid7.com/t/nexpose-dynamic-discovery-vmware-hosts-list/3576/5 "2021-02-18T16:43:32Z")

</div>

Hi Tyler,

thanks for this, we had to adjust slightly to this  
td,div {font-family:Arial;font-size:10pt;vertical-align:top} /\* Copyright IBM Corp. 2020 All Rights Reserved. \*/ body { margin: 0 0 0 0; padding:0 0 0 0; overflow:hidden; background-color:#fafafa; } .grayBackground { background-color:#f6f6f6; } .transcript { background-color:#d2d2d2;} .messageBlock {padding-left:10px; padding-right:10px;padding-top:0px;padding-bottom:0px;} .expansion{height:10px;width:100%;overflow:hidden;} .line{height:1px;background-color:#cccccc;overflow:hidden;} .message { padding-left:0px; padding-right:65px;margin-left:0px; word-wrap:break-word; white-space:-moz-pre-wrap; \_white-space:pre; white-space:pre-wrap; } .messageCont { padding-left:0px; margin-left:95px; word-wrap:break-word; white-space:-moz-pre-wrap; \_white-space:pre;white-space:pre-wrap;} .other { font-size:11px;color:#1970b0;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; white-space:nowrap; padding-top:2px; } .myself { font-size:11px;color:#222222;font-style:normal;font-weight:bold;font-style:normal;float:left; width:95px; white-space:nowrap; padding-top:2px; } .otherCont { font-size:8px;text-align:right; color:#1970b0;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; } .myselfCont { font-size:8px;text-align:right; color:#222222;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; } .system { font-size:11px; word-wrap:break-word;color:#d13f08;font-style:normal;font-weight:normal; white-space:-moz-pre-wrap; \_white-space:pre;white-space:pre-wrap; } .showTimestamp { padding-left:20px;font-size:11px; float:right; color:#999999;font-style:normal;font-weight:normal; } .other1 { font-size:11px; color:#ba006e;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; padding-top:2px; } .otherCont1 { font-size:8px;text-align:right; color:#ba006e;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; } .other2 { font-size:11px; color:#007670;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; padding-top:2px; } .otherCont2 { font-size:8px;text-align:right; color:#007670;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; } .other3 { font-size:11px; color:#3b0256;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; padding-top:2px; } .otherCont3 { font-size:8px;text-align:right; color:#3b0256;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; } .other4 { font-size:11px; color:#00512b;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; padding-top:2px; } .otherCont4 { font-size:8px;text-align:right; color:#00512b;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; } .other5 { font-size:11px; color:#a91024;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; padding-top:2px;} .otherCont5 { font-size:8px;text-align:right; color:#a91024;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; } .other6 { font-size:11px; color:#b8471b;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; padding-top:2px;} .otherCont6 { font-size:8px;text-align:right; color:#b8471b;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; } .other7 { font-size:11px; color:#7f1c7d;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; padding-top:2px;} .otherCont7 { font-size:8px;text-align:right; color:#7f1c7d;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; } .highlight { background-color:#bed6f8; } .datestamp { padding-right:0px; font-size:11px; cursor:default;padding-top:1px;padding-bottom:1px; background-color:#a7a7a7; width:100%; float:left; text-align:right; color:#333333; font-weight:bold; font-style:italic; } #chatAlert { float:left; border-bottom:1px solid #E8D091; padding:6px; width:100%; color:#A5754C; background: url(‘file:/C:/Users/pb19600/AppData/Local/HCL/Notes/Data/workspace/.config/org.eclipse.osgi/844/0/.cp/images/chat\_gradient.gif’);} #chatAlertImage { float:left; } #chatAlertText { float:left; margin-left:6px; margin-right:10px;} #chatAlertClose { float:right; margin-right:10px; padding-right:6px; margin-top:0px; } #chatAlertText a { color:#A5754C; } #chatAlertText a:hover { color:#A5754C; text-decoration:none; } .displayNone {display:none;} .tsDisplay { display:block }.dsDisplay { display:none }

SELECT da.asset\_id AS “Asset ID”, da.ip\_address AS “IP Address”, da.host\_name AS “Host Name”, dht.description AS “Description”  
FROM dim\_asset da  
JOIN dim\_host\_type dht on da.host\_type\_id = dht.host\_type\_id WHERE description = ‘Hypervisor’;

It has extracted the vmware hosts from the DB.  
What we are going to do is ask the VMWARE team to let us know when they add a new machine on the network ans see if the query picks it up

I shall comme back to you on this

All the best

---

<div class="post-metadata">

**Author:** ![nicolas\_designori](https://discuss.rapid7.com/letter_avatar_proxy/v4/letter/n/4491bb/32.png) [@nicolas\_designori](https://discuss.rapid7.com/u/nicolas_designori)\
**Post date:** [February 18, 2021, 4:44pm UTC](https://discuss.rapid7.com/t/nexpose-dynamic-discovery-vmware-hosts-list/3576/6 "2021-02-18T16:44:22Z")

</div>

Sorry…  
SELECT da.asset\_id AS “Asset ID”, da.ip\_address AS “IP Address”, da.host\_name AS “Host Name”, dht.description AS “Description”  
FROM dim\_asset da  
JOIN dim\_host\_type dht on da.host\_type\_id = dht.host\_type\_id WHERE description = ‘Hypervisor’;

Here you go
