Create Database Metric Plugin

Overview

Creating a Database Metric Plugin in Motadata AIOps allows you to define custom metrics for monitoring purposes using data retrieved from databases. This enables you to monitor specific parameters within your databases and incorporate them into your overall monitoring strategy.

Navigation

Go to Menu, Select Settings . After that, Go to Plugin Library . Select Metric. The Metric Plugin screen is displayed.

Select to create a metric plugin. The screen to create HTTP/HTTPS is selected by default. Select Database to create a Database Metric Plugin.

Database Metric Plugin Fields

When creating a Database Metric Plugin, you'll need to complete the following fields:

Field	Description
Metric Name	Name of the metric you're defining.
Type	Type of monitor for which you're creating the plugin.
Monitor/Group	Choose whether you want to assign the plugin to a specific monitor or a group of monitors. The Plugin will be tested against the monitors selected here when you click on the Test button.
Monitors/Groups	Select the specific monitor(s)/group(s) to which you want to assign the plugin.
Credential Profile	Select the credential profile to access the selected monitors.
Port	Specify the Database Port.
Timeout	Specify the timeout to establish the connection with the port.
SQL Script	Write the SQL script in this window.
Script Language	Choose the language for writing the parsing script (GO or Python).
Parsing Script	Write the script here to parse the retrieved data.
Add Variable	Add any variables needed in the parsing script.

Once you've filled in these fields, you'll be able to define custom metrics using the Database Metric Plugin.

Select Create Metric to create the metric plugin based on the configurations specified.

Select Test to test the script against the monitors selected.

Select Reset to erase all the current field values, if required.