Create a Database Runbook

Overview

Database Runbooks in Motadata AIOps are instrumental for executing specific actions on a database, such as performing queries, releasing memory, and executing various other database operations. Utilizing the JDBC protocol, the Database Runbook establishes a connection with the database to perform the specified actions securely and efficiently.

Navigation

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

Select to start creating a Runbook. Select Database to create a Database Runbook.

Database Runbook Configuration

The Database Runbook creation screen presents various parameters to define the Runbook's functionality and assign it to monitors or groups. Below is a detailed breakdown of each parameter:

Diagnostics

Field	Description
Runbook Name	Assign a logical and unique name that identifies the task performed by the runbook.
Description	Provide a description of the Runbook.
Type	Select the type of database for which you are creating the runbook.
Monitor/Group/IP-Host	Select Monitor, Group, or IP/Host based on the device(s) to which you want to assign the runbook.
Monitors	Select desired monitor from the 'Monitors' dropdown if you want to assign the Runbook to an individual monitor. This option is available when you select Monitor in the previous field.
Groups	Select desired group from the 'Groups' dropdown if you want to assign the Runbook to a group of monitors. This option is available when you select Group in the previous field.
IP/Host	Specify the IP/Host if you want to assign the Runbook to a device that is not discovered in Motadata AIOps as a Monitor. This option is available when you select IP/Host in the previous field.
Credential Profile	This field is optional. You can select a credential profile if needed; otherwise, the profile used during discovery will be applied automatically.
Create Credential Profile	Select this option if you need to create a new credential profile.
Port	Specify the port number in this field. In case you select a credential profile, the port number specified in the credential profile will be used. You can override the port number from the credential profile by specifying a port number in this field.
Timeout	Specify the timeout in this field. In case you select a credential profile, the timeout specified in the credential profile will be used. You can override the timeout from the credential profile by specifying a timeout in this field.
Database Script	Write the script detailing the task that you wish to execute using the Runbook.
Script Language	Specify the language(Go or Python) you want use to write the parsing script.
Parsing Script	Write the script to parse the output derived post database script execution.
Add Variable	Add a variable if required in the parsing script.

Troubleshooting

Field	Description
Runbook Name	Assign a logical and unique name that identifies the task performed by the runbook.
Description	Provide a description of the Runbook.
Type	Select the type of database for which you are creating the runbook.
Monitor/Group/IP-Host	Select Monitor, Group, or IP/Host based on the device(s) to which you want to assign the runbook.
Monitors	Select desired monitor from the 'Monitors' dropdown if you want to assign the Runbook to an individual monitor. This option is available when you select Monitor in the previous field.
Groups	Select desired group from the 'Groups' dropdown if you want to assign the Runbook to a group of monitors. This option is available when you select Group in the previous field.
IP/Host	Specify the IP/Host if you want to assign the Runbook to a device that is not discovered in Motadata AIOps as a Monitor. This option is available when you select IP/Host in the previous field.
Credential Profile	This field is optional. You can select a credential profile if needed; otherwise, the profile used during discovery will be applied automatically.
Create Credential Profile	Select this option if you need to create a new credential profile.
Port	Specify the port number in this field. In case you select a credential profile, the port number specified in the credential profile will be used. You can override the port number from the credential profile by specifying a port number in this field.
Timeout	Specify the timeout in this field. In case you select a credential profile, the timeout specified in the credential profile will be used. You can override the timeout from the credential profile by specifying a timeout in this field.
Database Script	Write the script detailing the task that you wish to execute using the Runbook.
Script Language	Specify the language(Go or Python) you want use to write the parsing script.
Parsing Script	Write the script to parse the output derived post database script execution.
Add Variable	Add a variable if required in the parsing script.

Integration

Field	Description
Runbook Name	Assign a logical and unique name that identifies the task performed by the runbook.
Description	Provide a description of the Runbook.
Type	Select the type of database for which you are creating the runbook.
Monitor/Group/IP-Host	Select Monitor, Group, or IP/Host based on the device(s) to which you want to assign the runbook.
Monitors	Select desired monitor from the 'Monitors' dropdown if you want to assign the Runbook to an individual monitor. This option is available when you select Monitor in the previous field.
Groups	Select desired group from the 'Groups' dropdown if you want to assign the Runbook to a group of monitors. This option is available when you select Group in the previous field.
IP/Host	Specify the IP/Host if you want to assign the Runbook to a device that is not discovered in Motadata AIOps as a Monitor. This option is available when you select IP/Host in the previous field.
Credential Profile	This field is optional. You can select a credential profile if needed; otherwise, the profile used during discovery will be applied automatically.
Create Credential Profile	Select this option if you need to create a new credential profile.
Port	Specify the port number in this field. In case you select a credential profile, the port number specified in the credential profile will be used. You can override the port number from the credential profile by specifying a port number in this field.
Timeout	Specify the timeout in this field. In case you select a credential profile, the timeout specified in the credential profile will be used. You can override the timeout from the credential profile by specifying a timeout in this field.
Database Script	Write the script detailing the task that you wish to execute using the Runbook.
Script Language	Specify the language(Go or Python) you want use to write the parsing script.
Parsing Script	Write the script to parse the output derived post database script execution.
Add Variable	Add a variable if required in the parsing script.

Log Collection

Field	Description
Runbook Name	Assign a logical and unique name that identifies the task performed by the runbook.
Description	Provide a description of the Runbook.
Type	Select the type of database for which you are creating the runbook.
Monitor/Group/IP-Host	Select Monitor, Group, or IP/Host based on the device(s) to which you want to assign the runbook.
Monitors	Select desired monitor from the 'Monitors' dropdown if you want to assign the Runbook to an individual monitor. This option is available when you select Monitor in the previous field.
Groups	Select desired group from the 'Groups' dropdown if you want to assign the Runbook to a group of monitors. This option is available when you select Group in the previous field.
IP/Host	Specify the IP/Host if you want to assign the Runbook to a device that is not discovered in Motadata AIOps as a Monitor. This option is available when you select IP/Host in the previous field.
Credential Profile	This field is optional. You can select a credential profile if needed; otherwise, the profile used during discovery will be applied automatically.
Create Credential Profile	Select this option if you need to create a new credential profile.
Port	Specify the port number in this field. In case you select a credential profile, the port number specified in the credential profile will be used. You can override the port number from the credential profile by specifying a port number in this field.
Timeout	Specify the timeout in this field. In case you select a credential profile, the timeout specified in the credential profile will be used. You can override the timeout from the credential profile by specifying a timeout in this field.
Database Script	Write the script detailing the task that you wish to execute using the Runbook.
Script Language	Specify the language(Go or Python) you want use to write the parsing script.
Parsing Script	Write the script to parse the output derived post database script execution.
Add Variable	Add a variable if required in the parsing script.

Network Config

Field	Description
Runbook Name	Assign a logical and unique name that identifies the task performed by the runbook.
Description	Provide a description of the Runbook.
Type	Select the type of database for which you are creating the runbook.
Monitor/Group/IP-Host	Select Monitor, Group, or IP/Host based on the device(s) to which you want to assign the runbook.
Monitors	Select desired monitor from the 'Monitors' dropdown if you want to assign the Runbook to an individual monitor. This option is available when you select Monitor in the previous field.
Groups	Select desired group from the 'Groups' dropdown if you want to assign the Runbook to a group of monitors. This option is available when you select Group in the previous field.
IP/Host	Specify the IP/Host if you want to assign the Runbook to a device that is not discovered in Motadata AIOps as a Monitor. This option is available when you select IP/Host in the previous field.
Credential Profile	This field is optional. You can select a credential profile if needed; otherwise, the profile used during discovery will be applied automatically.
Create Credential Profile	Select this option if you need to create a new credential profile.
Port	Specify the port number in this field. In case you select a credential profile, the port number specified in the credential profile will be used. You can override the port number from the credential profile by specifying a port number in this field.
Timeout	Specify the timeout in this field. In case you select a credential profile, the timeout specified in the credential profile will be used. You can override the timeout from the credential profile by specifying a timeout in this field.
Vendor	Specify the vendor of the device for which you are creating the runbook.
Database Script	Write the script detailing the task that you wish to execute using the Runbook.
Script Language	Specify the language(Go or Python) you want use to write the parsing script.
Parsing Script	Write the script to parse the output derived post database script execution.
Add Variable	Add a variable if required in the parsing script.

System Management

Field	Description
Runbook Name	Assign a logical and unique name that identifies the task performed by the runbook.
Description	Provide a description of the Runbook.
Type	Select the type of database for which you are creating the runbook.
Monitor/Group/IP-Host	Select Monitor, Group, or IP/Host based on the device(s) to which you want to assign the runbook.
Monitors	Select desired monitor from the 'Monitors' dropdown if you want to assign the Runbook to an individual monitor. This option is available when you select Monitor in the previous field.
Groups	Select desired group from the 'Groups' dropdown if you want to assign the Runbook to a group of monitors. This option is available when you select Group in the previous field.
IP/Host	Specify the IP/Host if you want to assign the Runbook to a device that is not discovered in Motadata AIOps as a Monitor. This option is available when you select IP/Host in the previous field.
Credential Profile	This field is optional. You can select a credential profile if needed; otherwise, the profile used during discovery will be applied automatically.
Create Credential Profile	Select this option if you need to create a new credential profile.
Port	Specify the port number in this field. In case you select a credential profile, the port number specified in the credential profile will be used. You can override the port number from the credential profile by specifying a port number in this field.
Timeout	Specify the timeout in this field. In case you select a credential profile, the timeout specified in the credential profile will be used. You can override the timeout from the credential profile by specifying a timeout in this field.
Database Script	Write the script detailing the task that you wish to execute using the Runbook.
Script Language	Specify the language(Go or Python) you want use to write the parsing script.
Parsing Script	Write the script to parse the output derived post database script execution.
Add Variable	Add a variable if required in the parsing script.

Performance Monitoring

Field	Description
Runbook Name	Assign a logical and unique name that identifies the task performed by the runbook.
Description	Provide a description of the Runbook.
Type	Select the type of database for which you are creating the runbook.
Monitor/Group/IP-Host	Select Monitor, Group, or IP/Host based on the device(s) to which you want to assign the runbook.
Monitors	Select desired monitor from the 'Monitors' dropdown if you want to assign the Runbook to an individual monitor. This option is available when you select Monitor in the previous field.
Groups	Select desired group from the 'Groups' dropdown if you want to assign the Runbook to a group of monitors. This option is available when you select Group in the previous field.
IP/Host	Specify the IP/Host if you want to assign the Runbook to a device that is not discovered in Motadata AIOps as a Monitor. This option is available when you select IP/Host in the previous field.
Credential Profile	This field is optional. You can select a credential profile if needed; otherwise, the profile used during discovery will be applied automatically.
Create Credential Profile	Select this option if you need to create a new credential profile.
Port	Specify the port number in this field. In case you select a credential profile, the port number specified in the credential profile will be used. You can override the port number from the credential profile by specifying a port number in this field.
Timeout	Specify the timeout in this field. In case you select a credential profile, the timeout specified in the credential profile will be used. You can override the timeout from the credential profile by specifying a timeout in this field.
Database Script	Write the script detailing the task that you wish to execute using the Runbook.
Script Language	Specify the language(Go or Python) you want use to write the parsing script.
Parsing Script	Write the script to parse the output derived post database script execution.
Add Variable	Add a variable if required in the parsing script.

Storage Profile

Field	Description
Runbook Name	Assign a logical and unique name that identifies the task performed by the runbook.
Description	Provide a description of the Runbook.
Type	Select the type of database for which you are creating the runbook.
Monitor/Group/IP-Host	Select Monitor, Group, or IP/Host based on the device(s) to which you want to assign the runbook.
Monitors	Select desired monitor from the 'Monitors' dropdown if you want to assign the Runbook to an individual monitor. This option is available when you select Monitor in the previous field.
Groups	Select desired group from the 'Groups' dropdown if you want to assign the Runbook to a group of monitors. This option is available when you select Group in the previous field.
IP/Host	Specify the IP/Host if you want to assign the Runbook to a device that is not discovered in Motadata AIOps as a Monitor. This option is available when you select IP/Host in the previous field.
Credential Profile	This field is optional. You can select a credential profile if needed; otherwise, the profile used during discovery will be applied automatically.
Create Credential Profile	Select this option if you need to create a new credential profile.
Port	Specify the port number in this field. In case you select a credential profile, the port number specified in the credential profile will be used. You can override the port number from the credential profile by specifying a port number in this field.
Timeout	Specify the timeout in this field. In case you select a credential profile, the timeout specified in the credential profile will be used. You can override the timeout from the credential profile by specifying a timeout in this field.
Database Script	Write the script detailing the task that you wish to execute using the Runbook.
Script Language	Specify the language(Go or Python) you want use to write the parsing script.
Parsing Script	Write the script to parse the output derived post database script execution.
Add Variable	Add a variable if required in the parsing script.

Other

Field	Description
Runbook Name	Assign a logical and unique name that identifies the task performed by the runbook.
Description	Provide a description of the Runbook.
Type	Select the type of database for which you are creating the runbook.
Monitor/Group/IP-Host	Select Monitor, Group, or IP/Host based on the device(s) to which you want to assign the runbook.
Monitors	Select desired monitor from the 'Monitors' dropdown if you want to assign the Runbook to an individual monitor. This option is available when you select Monitor in the previous field.
Groups	Select desired group from the 'Groups' dropdown if you want to assign the Runbook to a group of monitors. This option is available when you select Group in the previous field.
IP/Host	Specify the IP/Host if you want to assign the Runbook to a device that is not discovered in Motadata AIOps as a Monitor. This option is available when you select IP/Host in the previous field.
Credential Profile	This field is optional. You can select a credential profile if needed; otherwise, the profile used during discovery will be applied automatically.
Create Credential Profile	Select this option if you need to create a new credential profile.
Port	Specify the port number in this field. In case you select a credential profile, the port number specified in the credential profile will be used. You can override the port number from the credential profile by specifying a port number in this field.
Timeout	Specify the timeout in this field. In case you select a credential profile, the timeout specified in the credential profile will be used. You can override the timeout from the credential profile by specifying a timeout in this field.
Database Script	Write the script detailing the task that you wish to execute using the Runbook.
Script Language	Specify the language(Go or Python) you want use to write the parsing script.
Parsing Script	Write the script to parse the output derived post database script execution.
Add Variable	Add a variable if required in the parsing script.

Click on Test to verify the script and reachability of the selected monitor(s).

Click on the Create Runbook Plugin to create the Runbook ensuring all parameters are defined as per your requirements. Note that this option becomes available only after successful testing.

Click on the Reset option to clear all input fields.