iQExplore to better account for vmhost counts

Owned by Conor McCann
Last updated: Mar 21, 2016

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.