This article is one of the worked examples in RCM. It shows how to build an overview of all Approved Analyses, with their Criticalities and Residual Risk — valuable for RCM quality checks. For when and why to use a query in RCM, see RCM Queries – Background; for day-to-day query tips, see Working with Queries.
Note
This article describes the Analyses Overview Query.
Building the Query
The "Analyses Overview (changes)" Query provides this data, and uses the Base view: "vwRCMData":
Query Output
This query provides this output:
Note
Using the FLOC and Tag fields helps to get insight into whether analyses are done on Floc level or on Equipment level.
Interpreting the Results
After exporting to Excel, you can create a pivot table to compare Criticality against Residual Risk, split by Approval status:
From a table like this, one could observe:
7% of the Analyses are in the higher criticalities (E-H-MH-M) — which is quite low.
45% of all analyses are Automatically Approved — which seems high considering so many low criticalities.
There are 9 H residual risk analyses — which is too high.
There are 70 MH residual risk analyses — which is also too high.
There are 2 M criticality analyses with a residual risk of H — which is incorrect as risk should be reduced, not increased.
There are quite a few analyses where the residual risk level exceeds the criticality level, which is worth investigating.
To create, modify, and manage Queries, also see the Custom Queries Editor.