Queries Folder

The Catalog folder \\Public\Meridium\Modules\AMS Asset Portal\Queries contains the following items.

Note: Only the Catalog items used in the current version of GE Digital APM are included in this table. However, items used in previous versions are still available in the Catalog.

Item Name	Behavior and Usage
Active Alerts by Asset Criticality	The results of this query are used by the Active Alerts by Asset Criticality graph on the AMS Analytics Overview page.
Active Alerts by Severity	The results of this query are used by the Active Alerts by Severity graph on the AMS Analytics Overview page.
Active AMS Alerts By Duration	The results of this query are used by the Active AMS Alerts By Duration graph on the AMS Analytics Overview page.
Alert Trend by Asset	The results of this query are used by the Asset Alert Trend by Severity graph.
Alert Trend by Asset by Event Description	The results of this query are used by the Asset Alert Trend by Description graph.
Alert Trend Over Year by Hierarchy	The results of this query are used by the Alert Trend graph on the AMS Analytics Overview page.
All Assets by Type	The results of this query are used by the Assets by Type graph on the AMS Analytics Overview page.
AMS Overview - Active Alerts	Returns AMS Asset Alerts that are marked as active and related to a selected level of the Asset Hierarchy. The results of this query are displayed in the Active Alerts list on the AMS Analytics Overview page.
AMS Overview - Active Recommendations	Returns open AMS Asset Recommendations (i.e., recommendations where the state is not closed, superseded, or rejected) related to a selected level of the Asset Hierarchy (i.e., linked directly to an asset in the selected level or linked to an AMS Asset that is linked to an asset in the selected level). The results of this query are displayed in the Recommendations list on the AMS Analytics Overview page.
AMS Overview - AMS Assets by Asset Hierarchy	Returns the AMS Asset records related to a selected level of the Asset Hierarchy. The results of this query are displayed in the AMS Assets list on the AMS Analytics Overview page.
AMS Overview - Events	Returns AMS Asset Events related to a selected level of the Asset Hierarchy and whose date is within a specified time range. The results of this query are displayed in the Events list on the AMS Analytics Overview page.
AMS Overview - Reports	Returns a list of the reports located in the Catalog folder \\Public\Meridium\Modules\AMS Asset Portal\Summary Reports. The results of this query are displayed in the Reports list on the AMS Analytics Overview page.
Asset Events By Type	The results of this query are used by the Events By Type graph on the AMS Analytics Overview page.
Assets by Criticality	The results of this query are used by the Assets by Criticality graph on the AMS Analytics Overview page.
Assets by Health Index	The results of this query are used by the Assets by Health graph on the AMS Analytics Overview page.