...
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 An import of the a new .qvw file.
...