Type
  • Best Practice
Description
  • This article explains how to use the database query analysis effectively.
Additional Keywords
  • Database Query

Related Topics

Knowledge Base

Using Database Query Analysis

KB1239 - Aug 02, 2018

Introduction

Monitoring Studio provides a flexible feature to query data from any database. In this article, you will learn how to query a database using its name or its service name. The example is based on an Oracle database.

Procedure

Configuring Using the Database Name

To query an Oracle database using its name:

  1. Right-click the monitored host and click KM Commands > New > Monitor
  2. Select the Database Query: Oracle Data Server Monitor

    Selecting the "Database Query: Oracle Database Server" Monitor

  3. Provide the Database name and Port number and click Next

    Entering the Database Server Connection Information

  4. Provide the Credentials to connect to the database, the SQL query to be executed and click Next

    Entering the Database Server Connection Information

  5. Configure the Monitor Settings and click Next

    Entering the Database Server Connection Information

Configuring Using the Service Name

To query an Oracle database using the service name:

  1. Right-click the monitored host and click KM Commands > New > Monitor
  2. Select the Database Query: Other (JDBC) Monitor

    Selecting the "Database Query: Other (JDBC)" Monitor

  3. Enter the URL to use for connecting to the JDBC database. The format to use is: jdbc:oracle:thin@<hostname>:<port>/<ServiceName>

    Providing the JDBC Connection Information

    You can use application constants to replace for the <hostname> if you are planning to save your configuration as a template.

    You can refer to this article to know how to find the Oracle service name.
  4. Provide the Credentials to connect to the database, the SQL query to be executed and click Next

    Providing the JDBC Query Information

  5. Configure the Monitor Settings and click Next

    Entering the Database Server Connection Information