In SAP Focused Run there is no standard mechanism to identify and display all grey metrics in System Monitoring, a grey metric can cause critical situations not being captured and alerted in monitoring hence we need to monitor such grey metrics.
In this blog we explain how you can list all the grey metrics by directly reading from database tables that store the monitoring data.
Focused Run system monitoring metric aggregate data is stored in table AEM_METRIC_AGGR. We can filter on metric status = Grey to see the list of grey metrics.
Open the table in transaction SE16:
Increase the width and no of hits and click on execute
Now you have all the data that you can export to an excel sheet. For this select the following menu option.
Select file type as Text with Tabs.
Provide the path and filename to save the file and then click on Generate button.
Now open the .txt file in MS Excel.
In the Home tab select option for filtering as shown below
Now set the following filter for the column LAST_RAT
Now you will get the list of all grey metrics as shown below.
Note: The Context_ID value will give you the ID of the managed object, Metrtric_type_ID will give you the ID of the metric name and the Last_text will give you the return text of the last data collection which will give you the reason for grey metric.
In order to get the managed object name and metric type you can use the following in transaction MAI_TOOLS –> Metric Event Alert Details.
In the selection screen for Managed Object ID enter the Context ID from the excel and for Metric Type ID enter the same from the excel. Also select the checkboxes as shown below and execute.
Now you will get the info on the Template as well as the Metric name which is currently in grey.
You can also check the instructions from SAP in OSS note 2859574 – How to list all current Grey Metrics in FRUN.
Alerting on important grey metrics
If a critical metric turns grey (meaning it can be good, or bad), you can set a specific alert when this happens. For example Oracle system in stalled mode might turn grey in stead of red. In this case grey is the same as red: system will not work.
For setup instructions: read this dedicated blog.