(DI-2311) Example: Number of Inactive Objects on the System

Owned by SNP
Nov 16, 2023
2 min read

This example shows how you can create your KPI to collect information about the number of inactive objects on the monitored system. 


Define a custom KPI for SQL Collector

  1. Go to Settings > Collector settings (or transaction /DVD/MON_COL).
  2. Select the collector /DVD/MON_CL_COL_SQL.
  3. Double-click KPI.
  4. Click New Entries (F5).
  5. Fill in all required fields for custom KPI as display in the figure. All field descriptions can be found in the chapter Define a Custom KPI.
  7. Save your KPI (CTRL + S).

Choose how data is collected into the custom KPI through a SQL SELECT statement

  1. Double-click Inputs & rules.
  2. Select Edit next to the Input table /DVD/MON_KPISQL1.
  3. Click Edit (Ctrl + F1) and then Create new records (F6). 

  4. In the next dialog enter the KPI name 'ZCUSTOM_INACTIVE_OBJECT' and fill in the SQL statement.
    The SQL Statement for inactive objects is SELECT count(*) FROM DWINACTIV WHERE delete_flag <> 'X'.

  6. Save the changes (CTRL + S).

Create a Monitoring profile for the custom KPI 

Before you start to collect the custom KPI, you must assign it to a Monitoring profile. To create a custom Monitoring profile and assign it to this custom KPI, follow these steps:  

  1. Go to the Settings > Monitoring settings (or transaction /DVD/MON_CUST).
  2. Double-click Profile definition. 
  3. Click New Entries (F5).
  4. Fill in the profile name ZCUSTOM.
  5. Double-click Assigned KPIs.
  6. Click New Entries (F5).
  7. Fill in the custom KPI name ZCUSTOM_INACTIVE_OBJECT.
  8. Save (CTRL+S).

Schedule the monitoring of a custom KPI 

Custom KPI "ZCUSTOM_INACTIVE_OBJECT" is now assigned to a valid Monitoring profile "ZCUSTOM". The last step is to execute the monitoring of KPIs for a specific system with the created Monitoring profile:

  1. On the main screen, go the the Collector Jobs tab.
  2. Select Create collector job.
  3. Fill in the System ID on which you want to monitor the KPI.
  4. Fill in the Monitoring profile with the value ZCUSTOM.
  5. Adjust the Period and Retention time according to your requirements.
  6. Click (Re)Start collector job.`

For information on how to schedule and start a Collector job, see the chapter Schedule the Monitoring of KPIs.

When the Collector job was executed successfully, you may display the results of your custom KPI on the main screen. For further information on how to display a KPI, see the chapter Display KPIs.