ManageEngine® Applications Manager

AddMonitor API - Database Servers

This section explains how to use the AddMonitor API to add monitors of the category type 'Database Servers''. The following databases are supported:

IBM DB2

Syntax:

http://[Host]:[Port]/AppManager/xml/AddMonitor?apikey=[APIKEY]&type=[TYPE]&displayname=[DISPLAYNAME]
&username=[USERNAME]&host=[HOST]&password=[PASSWORD]&port=[PORT]&instance=[INSTANCE]

Request Parameters:

The parameters involved in the API request are described below. Also, refer the list of common Request Parameters.

Field	Description
type	The type of the database you want to add. Value should be db2.
username	The user name of the user who has permission to access the DB2 database.
host	The name of the host in which DB2 is running.
password	The password of the user who has permission to access the DB2 database.
port	The port number where DB2 is running.
instance	The database/instance name.

Sample Request:

http://prod-server1:9090/AppManager/xml/AddMonitor?apikey=5bc6a8e9a30d5bf894586d4db90282f5
&type=db2&displayname=appmanagerdb2&username=db2admin&host=app-xp4&password=admin&port=50000&instance=SAMPLEDB

Top

Memcached

Syntax:

http://[Host]:[Port]/AppManager/xml/AddMonitor?apikey=[APIKEY]&type=[TYPE]
&displayname=[DISPLAYNAME]&host=[HOST]&port=[PORT]&Transaction=[TRANSACTION]

Request Parameters:

The parameters involved in the API request are described below. Also, refer the list of common Request Parameters.

Field	Description
type	The type of the database you want to add. Value should be Memcached.
host	The name of the host in which Memcached server is running.
port	The port number where Memcached server is running.
Transaction	Denotes if transaction test is enabled or not. Value should be either yes or no

Sample Request:

http://prod-server4:9090/AppManager/xml/AddMonitor?apikey=40648ef160f4786b20ed89ea51aa3f98
&type=Memcached&displayname=mem_test&host=app-linux2&port=11211&Transaction=yes

Top

MS SQL

Syntax:

http://[Host]:[Port]/AppManager/xml/AddMonitor?apikey=[APIKEY]&type=[TYPE]&displayname=[DISPLAYNAME]
&username=[USERNAME]&host=[HOST]&password=[PASSWORD]&port=[PORT]&instance=[INSTANCE]&authentication=[AUTHENTICATION]

Request Parameters:

The parameters involved in the API request are described below. Also, refer the list of common Request Parameters.

Field	Description
type	The type of the database you want to add. Value should be ms sql.
username	The name of the user who has permission to access the MS SQL server.
host	The name of the host in which MS SQL is running.
password	The password of the user who has permission to access the MS SQL server.
port	The port number where MS SQL is running.
instance	The database/instance name. This is optional field.
authentication	The authentication type. Value should be either SQL or Windows.

Sample Request:

http://prod-server7:9090/AppManager/xml/AddMonitor?apikey=5bc6a8e9a30d5bf894586d4db90282f5
&type=ms sql&displayname=appmanagermssql&username=sa&host=app-xp2&password=Advent1&port=1433&instance=&authentication=SQL

Top

MySQL

Syntax:

Request Parameters:

The parameters involved in the API request are described below. Also, refer the list of common Request Parameters.

Field	Description
type	The type of the database you want to add. Value should be mysql.
username	The name of the user who has permission to access the MySQL server.
host	The name of the host in which MySQL is running.
password	The password of the user who has permission to access the MySQL server.
port	The port number where MySQL is running.
instance	The database/instance name. This is optional field.
authentication	The authentication type. Value should be SQL

Sample Request:

http://prod-server3:9090/AppManager/xml/AddMonitor?apikey=5bc6a8e9a30d5bf894586d4db90282f5
&type=mysql&displayname=appmanagermysql&username=root&host=shakthiprian&password=appmanager&port=13329&instance=mysql&authentication=SQL

Top

Oracle

Syntax:

http://[Host]:[Port]/AppManager/xml/AddMonitor?apikey=[APIKEY]&type=[TYPE]&displayname=[DISPLAYNAME]
&username=[USERNAME]&host=[HOST]&password=[PASSWORD]&port=[PORT]&instance=[INSTANCE]

Request Parameters:

The parameters involved in the API request are described below. Also, refer the list of common Request Parameters.

Field	Description
type	The type of the database you want to add. Value should be oracle.
username	The name of the user who has permission to access the Oracle database.
host	The name of the host in which Oracle is running.
password	The password of the user who has permission to access the Oracle database.
port	The port number where Oracle is running.
instance	The database/instance name. This is optional field.

Sample Request:

http://prod-server7:9090/AppManager/xml/AddMonitor?apikey=5bc6a8e9a30d5bf894586d4db90282f5
&type=oracle&displayname=appmanageroracle&username=rajesh&host=swissql-xp1&password=rajesh&port=1521&instance=orcl

Top

PostgreSQL

Syntax:

http://[Host]:[Port]/AppManager/xml/AddMonitor?apikey=[APIKEY]&type=[TYPE]
&displayname=[DISPLAYNAME]&host=[HOST]&port=[PORT]&username=[USERNAME]&password=[PASSWORD]&instance=[INSTANCE]

Request Parameters:

The parameters involved in the API request are described below. Also, refer the list of common Request Parameters.

Field	Description
type	The type of the database you want to add. Value should be PostgreSQL.
host	The name of the host in which PostgreSQL is running.
port	The port number where PostgreSQL is running.
username	The name of the user who has permission to access the PostgreSQL database.
password	The password of the user who has permission to access the PostgreSQL database.
instance	The database/instance name. This is optional field.

Sample Request:

http://prod-server8:9090/AppManager/xml/AddMonitor?apikey=40648ef160f4786b20ed89ea51aa3f98
&type=PostgreSQL&displayname=postSQL&host=app-xp2&port=5432&username=postgres&password=postgres&instance=postgres

Top

Sybase

Syntax:

http://[Host]:[Port]/AppManager/xml/AddMonitor?apikey=[APIKEY]&type=[TYPE]&displayname=[DISPLAYNAME]
&username=[USERNAME]&host=[HOST]&password=[PASSWORD]&port=[PORT]&instance=[INSTANCE]

Request Parameters:

The parameters involved in the API request are described below. Also, refer the list of common Request Parameters.

Field	Description
type	The type of the database you want to add. Value should be sybase.
host	The name of the host in which Sybase is running.
port	The port number where Sybase is running.
username	The name of the user who has permission to access the Sybase database.
password	The password of the user who has permission to access the Sybase database.
instance	The database/instance name. This is optional field.

Sample Request:

http://prod-server3:9090/AppManager/xml/AddMonitor?apikey=5bc6a8e9a30d5bf894586d4db90282f5
&type=sybase&displayname=appmanagersybase&username=sa&host=app-xp3&password=&port=5000&instance=master

Top

<< Prev	Home	Next >>
AddMonitor API - Custom Monitors		AddMonitor API - ERP