1 of 1 people found this helpful
Out of the box there is a nice report showing Applications which could be affected by a host. Just go to Explore -> Reports. Find the report "Applications that could be impacted by a Host"
That gives you a nice report with some host details, which you can customize using the UI to your liking
The query is available on the raw query tab if you want to adapt this to a report on a custom channel or a shared query.
Please try the below query:
This should serve your requirement.
2 of 2 people found this helpful
Why would you not start from the BusinessApplicationInstance? This is significantly less efficient.