Queries Folder

The Catalog folder \\Public\Meridium\Module\AHI\Queries contains the following items.

Query	Behavior and Usage
Health Overview- Alert Acknowledgement	Compares the number of health indicators with warning or alert statuses that are acknowledged vs. not acknowledged. This query can be filtered by asset. The results of this query are used by the Health Overview- Alert Acknowledgement graph which is displayed in the Health Overview page.
Health Overview- Parameters	Contains the asset context parameter used in the page-level filter of the Health Overview page. The parameter is passed to the other queries used in the page.
Health Overview- Recommendation Status	Summarizes the statuses of health-related recommendations (i.e., General Recommendation, AMS Asset Recommendation, Policy Recommendation, and Operator Rounds Recommendation). This query can be filtered by asset. The results of this query are used by the Health Overview- Recommendation Status graph which is displayed in the Health Overview page.
Health Overview - Recommendations Tile	Returns the list of recommendations that is displayed in the Recommendations list in the Asset Health Manager Overview page.
Health Overview- Status by Asset	Returns the top 20 assets and a summary of the health indicator statuses for each. This query can be filtered by asset. The results of this query are used by the Health Overview - Status by Asset graph which is displayed in the Health Overview page.
Health Overview- Tiles	Returns the lists of assets that are displayed in the Health Overview page (i.e., No Status, Normal, Warning, or Alert).