Adding multiple resources with a CSV file

You can add multiple resources to the Monitor by creating a comma separated values (CSV) file, and then importing the file.

Prérequis

You must be a Monitor administrator.

Contexte et remarques

You cannot use a CSV file to add a primary database in a database mirroring system as a resource; use the Administration window instead.

Task

Create a CSV file.

Each line in the CSV file contains information about a single resource. Each comma-separated term within a line describes an attribute of the resource. The order of the terms is important.

For terms that are optional, any preceding terms (including other optional terms) must be specified. For example, to specify the database name, you must also specify the server name and port number. To specify the encryption type, you must also specify the connection type. To specify the Monitoring URL suffix, you must also specify the port number.

CSV file format for database resources For terms that are optional, any preceding terms (including other optional terms) must be specified. For example, to specify the database name, you must also specify the server name and port number.

Position in the line	Term	Description
1	Resource type	Type sa to indicate that the resource is a database. This term is required.
2	Resource name	Specify the resource name that the database will have in the Monitor. This term is required.
3	Username	Specify the user name used to connect to the database. To add a version 16 database, you must specify user name for a user in the database that has the SYS_SAMONITOR_ADMIN_ROLE role. To add an earlier database, you must specify the user name for a user in the database that has DBA authority.
4	Password	Specify the user password used to connect to the database. This term is required.
5	Host	Specify the hostname or IP address of the computer on which the database server is running. You can use the name localhost to represent the current computer. This term is required.
6	Port	Specify the port number on which the database server is running. The default port number is 2638. This term is optional. The default value is 0.
7	Server	Specify the name of the database server that the database is connected to. This term is optional.
8	Database	Specify the name of the database. This term is optional.
9	Connection Parameters	Specify additional connection parameters to use when connecting to the database. List the connection parameters as a semicolon-delimited list of option=value pairs. The default value is "".This term is optional.

The following is an example of a CSV file that contains two database resources.

sa,demo,DBA,sql,localhost,2638,demo16
sa,demo3,DBA,sql,localhost,49152,demo16,demo

CSV file format for MobiLink resources For terms that are optional, any preceding terms (including other optional terms) must be specified. For example, to specify the encryption type, you must also specify the connection type.

Position in the line	Term name	Description
1	Resource type	Type ml to indicate that the resource is a MobiLink server. This term is required.
2	Resource name	Specify the resource name as it will appear in the Monitor. This term is required.
3	Username	Specify the username used to connect to the resource. This term is required.
4	Password	Specify the password used to connect to the resource. This term is required.
5	Host (MobiLink server)	Specify the hostname or IP address of the computer on which the server is running. You can use the name localhost to represent the current computer. This term is required.
6	Port (MobiLink server)	Specify the port number on which the MobiLink server is running. The default port number for MobiLink is 2439. This term is optional. The default value is 0.
7	Connection type (MobiLink server)	Specify the method to use to connect to the resource. Type one of the following: tcpip This is the default. http https tls This term is optional.
8	Encryption type (MobiLink server)	Specify the method used to encrypt the connection. Type one of the following: N No encryption. This is the default. R RSA encryption. F FIPS-certified RSA encryption. This term is optional.
9	Connection parameters (MobiLink server)	Specify additional connection parameters to use when connecting to the database. List the connection parameters as a semicolon-delimited list of option=value pairs. This term is optional.

The following is an example of an import file that contains two MobiLink server resources.

ml,demo2,DBA,sql,localhost
ml,demo4,DBA,sql,localhost,0,tcpip,N

CSV file format for MobiLink server farm resources

Position in the line	Term name	Description
1	Resource type	Type mf to indicate that the resource is a MobiLink server farm. This term is required.
2	Resource name	Specify the resource name as it will appear in the Monitor. This term is required.
3	MobiLink server name	Specify the MobiLink server resources that are to be included in the MobiLink server farm. List the MobiLink server resources as a comma delimited list. This term is required.

Position in the line

Term name

Description

Resource type

Type mf to indicate that the resource is a MobiLink server farm.

This term is required.

Resource name

Specify the resource name as it will appear in the Monitor. This term is required.

MobiLink server name

Specify the MobiLink server resources that are to be included in the MobiLink server farm. List the MobiLink server resources as a comma delimited list. This term is required.

The following is an example of an import file that contains two MobiLink server resources and a MobiLink server farm resource.

ml,demo2,DBA,sql,localhost
ml,demo4,DBA,sql,localhost,0,tcpip,N
mf,collection_demo,demo2,demo4

CSV file format for Relay Server farm resources For terms that are optional, any preceding terms (including other optional terms) must be specified. For example, to specify the Monitoring URL suffix, you must also specify the port number.

Position in the line	Term name	Description
1	Resource type	Type rf to indicate that the resource is Relay Server farm. This term is required.
2	Resource name	Specify the resource name as it will appear in the Monitor. This term is required.
3	Host (Relay Server farm)	Specify the hostname or IP address of the computer on which the server is running. You can use the name localhost to represent the current computer. This term is required.
4	Port (Relay Server farm)	Specify the port number on which the Relay Server farm is running. This term is optional. The default value is 0.
5	Monitoring URL suffix	Specify the URL suffix to locate the monitoring agent on the Relay Server farm. This term is optional.
6	Is HTTPS?	Specify True for the Monitor to use HTTPS to connect to the Relay Server farm. This term is optional. The default is False.This term is optional.
7	Username for HTTP authentication	If required, specify the HTTPS authentication user name. This term is optional.
8	Password for HTTP authentication	If required, specify the HTTPS authentication password. This term is optional.

The following is an example of an import file that contains two MobiLink server resources, a MobiLink server farm resource, and a Relay Server farm resource.

rf,rf_demo,rstest02.website.com

Log in to the Monitor.
Click Administration.
Click Resources.
Click Import.
Locate the CSV file and click Open.

The resources from the CSV file are added to the Monitor and monitoring starts.
Click Close.
Click Close.

Résultat

The imported resource is added to the Resource List in the Overview dashboard.

Adding multiple resources with a CSV file

Task

See also