Nexpose Dynamic Discovery VMWARE - Hosts list?

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

@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.

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?

There is a dim_host_type table which provides the following classifications for hosts:

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.

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';

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

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

1 Like