Queries Folder

The Catalog folder \\Public\Meridium\Modules\RCM contains subfolders which contain baseline queries that are used by default in RCM. The following table identifies the folder locations and results of these queries.

Query	Behavior and Usage
Baseline queries for RCM in folder \\Public\Meridium\Modules\RCM
Analysis Without Assets	Returns the analyses which have no associated asset.
RCM AnalysisTeam	Returns all team members for an analysis. The query is also used to support the RCM AnalysisTeamSubReport report.
Template List	Returns all RCM templates of the selected template type. The query is used to support the Select Template window of the Apply Template Builder for RCM.
Baseline queries for RCM in folder \\Public\Meridium\Modules\RCM\Analysis
Overview Page - RCM Analyses	Returns all RCM analyses for the Overview page list.
Overview Page - Template	Returns all RCM templates for the Overview page list.
RCM Equipment by System	Returns select equipment records based on Analysis System ID. The query is also used to support the RCM Analysis Description report.
RCM FailureModeEffects	Returns analysis details based on function, failure mode, and failure effects. This query is also used to support the RCM FailureModeEffectsAnalysis report.
RCM Recommendations by System	Returns recommendations based on the Analysis System ID. The query is also used to support the RCM Recommendations report.