Automation Rule queries must contain:
-
All of the fields needed for mapping to the selected analysis type (Reliability Distribution, Reliability Growth). For all analysis types, the following fields should be selected:
- Asset ID (required).
- Asset Installation Date (optional).
- Failure Date (required).
- Downtime (optional).
- The fields that will be used for grouping populations of events (including system fields such as Family ID and Family Key and the entity family caption)
- Filtering criteria.
Note: Filtering is disabled in the Reliability Automation Rule Builder if a query is used to build analyses.
We recommend that you use a query that contains the metadata information in the Asset ID and Failure Date fields (which are required fields) and that these two fields are defined in two separate entity families. This precludes the use of Group By queries, complex (non metadata-based) queries in the SQL Editor, and system fields or calculated fields for Asset ID and Failure Date information.
The master query cannot contain parameters. The master query should be stored in a public directory in the Catalog and must not be deleted. We recommend that you store this query in the GE Digital APM Catalog in the following folder: \\Public\Meridium\Modules\ReliabilityManager.
If you require additional fields for mapping or population grouping in the Reliability Automation Rule, you must change the master query. The master query should be accessible to members of the MI Reliability Administrators Security Group who will be working with Reliability Automation Rules. When the Reliability Automation Rule is executed to generate the analyses, sub-queries will be created using the master query as the source. If the master query is deleted, the sub-queries will cease to operate.