Unable to get table name for Tables or Table histories > 1 billion rows from SAP Focused Run alerts

[Sanddeep]

As part of SAP Focused Run alerts, we could see alerts for "Tables or Table histories > 1 billion rows" but unable to get what is that table name where records or more than 1 billion rows.
From the alert graph we can see how many tables are more than 1 billion like (2 or 3etc).

How we can get exact table name where rows are more than 1 billion from SAP Focused RUN ?

[stefan_hoyer · Accepted solution]

Hi Sanddeep,

The metric in FRUN System Monitoring is only a numeric value which provides you the number of tables with more than one billion rows.
You can find the relevant SQL statements that are used by the Hostagent to collect the metric data in the KBA 3447912 - Change threshold of HANA Tables or Table histories > 1 billion rows alert

In case you are looking for the exact table names please check the content of table M_CS_TABLES on HANA side. (RECORD_COUNT)
For further details please have a look at https://help.sap.com/docs/SAP_HANA_PLATFORM/4fe29514fd584807ac9f2a04f6754767/20ad60f77519101498ccb61...

Best regards
Stefan
SAP Support