This article is one of the worked examples in RCM Queries. It walks through building a query that reports System-level statistics — Functional Failures, Flocs, Equipment, and Analyses. 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 query shows statistics on Systems, covering Functional Failures, Flocs, Equipment, and Analyses.
The System overview in IMS doesn't let you see how many Functional Failures are applied per System. Building this query gives you that insight — for example, you'll typically find an average of 4 Functional Failures per System, with a minimum of 0 and a maximum of 26 FF/System.
Creating the Query
You can create this query from the Base View Systems, with 12 fields selected, as shown below.
Example Output
Running the query gives you an output like this:
After Export
Once you export the results, you can produce statistics like this:
You can use these statistics to compare current RCM work against previous analyses.