This is actually a really interesting idea.
I *think* the trick would be with IVIM for you. Add your vCenters and Hosts into your virtualization monitoring with NPM. Then you should be able to get some cool SQL alerts based on the current architecture of VM to Host at all times.
This is by no means exact, but the basic concept:
"Alert me when there is a problem with Host WHEN HostID IN (SELECT HostID from VMs WHERE VM is running that special application)"
Again, sorry it's not more exact. But if this is the general idea you are having, that would be fun to work on for sure. Let me know
Loop1 Systems: SolarWinds Training and Professional Services