RCM analyses changes query

This article is one of the worked examples in RCM. It shows how to list when changes were made to RCM analyses, and by whom. For when and why to use a query in RCM, see RCM Queries – Background; for day-to-day query tips, see Working with Queries.

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 be used.

Standard Methods

Option 1

In the Systems Main Screen (Grid List), the column #ALHY shows the number of analyses done in the last six months.

Example: In the first system shown here there are 4 FLOCs, 4 FMs, and 2 analyses done in the last six months:

Option 2

Take a look at the Event History on the FLOC/Equipment details page.

Overview of Pump001 with highlighted Event History section for tracking changes.

Example: There are 10 events listed for Pump001.

Note
You can export the Event history to Excel, if the list is (too) long. However, these methods are ineffective if you would like to list a large set of RCM changes.

Using a Query

If you would like to list a large set of RCM changes, you should use a query. See Custom Queries Editor for how to open and build a query in general. The video below also shows the process step-by-step:

To create a specific query, do the following:

Go to the Custom Reports Main Screen.
Click the Plus Button.
Enter the Query Name: "RCM Analyses changes".
Select the Base View: "RBITagAnalysis".
Then select these objects:
1. FLOC
2. Equipment
3. CMMS type
4. Equipment group
5. Location Type
6. vwRCMSitePlantUnit
7. Failure Mode

Query item details for RCM analyses changes with selected fields and criteria.

Select the fields shown below for these objects.

Overview of equipment analysis fields including selected fields for each object.

Select the following criteria for the fields - by clicking the Plus button. Active Equipment may be removed if not needed, by clicking the X button.