RCM Queries

When do you use a Query in RCM? (1) For data that is not - or hard - to reach directly in the IMS tool, for example: PLE’s: created, assigned and used. Functions and Functional Failures on Systems. Criticalities, Residual Risks, Approved analys...

Working with queries can be tough so here a few recommendations are given: Use the "Copy&Paste' functionality to test queries out on different fields, selections and criteria; while keeping the original. Create extra query folders, like 'Qual...

Note This query shows statistics on System regarding the Functional Failures, Flocs, Equipment and Analyses. When working in RCM the overview of Systems does not enable to list the number of Functional Failures applied...

Take Note This article provides the steps to make a table of number of FM's per Lo cation type/ Equipment group   To verify the depth of RCM analyses done on Floc's or Equipment, an overview of the number of FM's found per Floc/Eq can be us...

Take Note This article describes the Analyses Overview Query. For RCM quality checks, it can be valuable to have an overview of all the Approved Analyses, with Criticalities and Residual Risk. This "Analyses Overview (changes)" Query provides t...

Take Note This article will explain how to list when changes were made to RCM analyses and by who. In IMS there are two standard ways to list the RCM activities that have been done over time. Alternatively, if the list is long, a Query can b...

This query shows if tasks are approved in the MEC board: Approval on the various stages confirms the quality is verified: A query can be used to see if tasks are approved in the MEC board: The result looks like this table: ...

Take Note: This article describes how to list MEI thresholds and TA data stored at the unit level, by making use of a Query. MEI Thresholds  and TA dates and intervals are stored on Unit level, and can be cumbersome to retrieve in a list...

This online manual explains how to create Queries to show PLEs defined, PLEs assigned and PLEs used.  These Queries can be used to manage and update PLEs in RCM . Query - PLEs Defined (with Rates and Timing) This "PLE Defined" Q...

This query provides the Eco and Env consequence classes and Notes, from the Prioritization step done in a System: Note in this example, K101-02 is a Floc with prioritization data in the System, and C101-02-eq is an Equipment with prioritization dat...

Take Note: This query lists to which System Functional-Failures the  RSL Failure Modes are assigned to. When an RSL is applied to a Floc or Eq, the Failure Modes (FM) in the RSL can be assigned to various  Functional-Failures (FF) ...

What to check – in case you get no output from your query: Copy-paste into 2nd query - to investigate, check details and try out to resolve Check the fields selected (like: do select all) – maybe these objects are not present in the dB... (test: ...