SQL Query to obtain vmware probe details for EXSI hosts

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Is there a SQL Query that can be used to extract a list of EXSI hosts that are configured for VMware probe monitoring?

Environment

• UIM 20.4+
• vmware probe (all versions)

Resolution

The following query will return the details for all QOS metrics that have been collected in the last 1 hour with their host and target information.

SELECT * FROM S_QOS_DATA AS qd
JOIN S_QOS_SNAPSHOT AS snap ON snap.table_id = qd.table_id
/* Following will subtract 1 hours in today's date. */
WHERE snap.[sampletime] > dateadd(hour, -1, getdate())
AND probe = 'vmware' 

Please note that construction of specific queries is generally beyond the scope of support; you should consult with a qualified DBA to construct additional queries or modify this one as needed, but it provides a logical starting point.