Problem

iQExplore to better account for VMHOST counts

Solution

There is a general SQL patch update for explore_v2.VMHostprocess that needs to be applied.
The is also an optional patch to resolve a problem that I identified within data hub when deviceinstance is not correctly tied to device. This may not be present in your EDW.
If it is present then this requires a once-off application script patch9299.
The symptoms that identify this is that explore_v2.device and summary_v1.device have different counts (when found devices are excluded from summary_v1.device)

The fix is two parts.

a) an import of the a new .qvw file.

b) SQL commands that rectifies the problems in the with device counts between summery_v1 and explore_v2 not matching.

.SQL files below.

 

 

 

 

 

You may want to use a panel to highlight important steps.
  1. Use numbered lists to provide step-by-step help.
  2. Copy and paste or drag and drop images to add them to this page.

Related articles

Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.

Related issues