sap_basis probe monitoring on Redo Log Backup

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Would like to know how sap_basis probe monitors below metric:

The state of the SAP HANA redo log backups at a particular instance of time.

Possible values are (0 - Successful, 1 - Failed, 2 - Running, 3 - Cancel Pending, 4 - Cancelled)

Environment

Any supported UIM version 

sap_basis probe 2.22.0

Resolution

Below is the query used by the sap_basis probe to monitor redo Logbackup:

SELECT temp.HOST host,temp.SERVICE_TYPE_NAME SERVICE_TYPE_NAME,temp.ENTRY_TYPE_NAME ENTRY_TYPE_NAME,B.STATE_NAME STATE_NAME FROM M_BACKUP_CATALOG B INNER JOIN M_BACKUP_CATALOG_FILES BF ON B.BACKUP_ID=BF.BACKUP_ID
INNER JOIN (SELECT BF.HOST host,BF.SERVICE_TYPE_NAME SERVICE_TYPE_NAME,B.ENTRY_TYPE_NAME ENTRY_TYPE_NAME,max(B.SYS_START_TIME) START_TIME FROM M_BACKUP_CATALOG B INNER JOIN  M_BACKUP_CATALOG_FILES BF 
ON B.BACKUP_ID=BF.BACKUP_ID GROUP BY BF.HOST,BF.SERVICE_TYPE_NAME,B.ENTRY_TYPE_NAME)as temp
ON BF.HOST=temp.HOST
AND BF.SERVICE_TYPE_NAME=temp.SERVICE_TYPE_NAME
AND B.ENTRY_TYPE_NAME=temp.ENTRY_TYPE_NAME
AND temp.START_TIME=B.SYS_START_TIME