EV Observe - Configure Veeam Monitoring Prerequisites
Veeam offers backup and restore solutions as well as cloud-based data management solutions for virtual machines (VM) and servers. Jobs are used to run processes.
To use service templates to monitor Veeam jobs, specific prerequisites must first be met.
- You configure these prerequisites once only.
- This is done in two steps:
- Configure monitoring for the MS SQL Server database
- Set up job monitoring in the Web app by creating a new service
Best Practice
- Use the Veeam-job-Status service template to deploy the new service dedicated to the monitoring of Veeam jobs in the Web app. This will enable you to predefine information for the service, such as arguments, periods, control intervals, warning thresholds and critical thresholds.
Purpose of the Veeam-job-Status service template
- It checks that Veeam Backup jobs are correctly run on the period of analysis.
- If the results contain warnings, the status will change to Warning.
- If the job contains errors, the status will change to Critical.
- If the type of job is unspecified, the search will run using the name alone.
Procedure: How to configure Veeam monitoring prerequisites
Step 1: Configure monitoring for the MS SQL Server database
1. Create a user account dedicated to the monitoring of the MS SQL Server instance and associated databases.
See the detailed procedure
2. Create a new Veeam connection in the freetds.conf configuration file.
See the detailed procedure
- Open the file called /etc/freetds.conf.
- Add the rows below to the end of the file to specify the server connection information for the new Veeam connection.
Replace:
- {ConnectionName} with the name of the new Veeam connection
- {VeeamServer_IP_address} with the IP address of the Veeam server
- {SQLInstance_port} with the TCP/IP port of the MS SQL Server instance (usually 1433)
- {SQLInstance_name} with the name of the MS SQL Server instance
- {TDS_version} with the TDS protocol version: 8.0 or 7.0 depending on your MS SQL Server version
[{ConnectionName}]
host = {VeeamServer_IP_address}
port = {SQLInstance_port}
instance = {SQLInstance_name}
tds version = {TDS_version}
example
[VEEAM]
host = 192.168.10.22
port = 1433
instance = MSSQLServer
tds version = 8.0
- Save your modifications.
The name of the new Veeam connection will correspond to the name of the server used when creating services (step 2.2).
Step 2: Set up Veeam job monitoring using the Veeam-Job-Status service template
1. Go to the Web app.
2. Create a new service template.
- Select Configuration > Services > List in the menu.
- Click + Add in the Mode: Box tab.
- Specify the information below.
General information tab
- Service template: Select the Veeam-Job-Status service template.
- Name: Enter the name of the new service you want to create.
Availability and checks tab
- Server name: Name of the new connection as specified in the freetds.conf configuration file.
example VEEAM
- Locked monitoring account: Select Yes.
- Username / User password: ID of the user account used for monitoring the MS SQL Server instance and associated databases (account created in step 1.1).
- Name of the database: Name of the MS SQL Server database.
- Caution: The name of the database is different from the name of the MS SQL Server instance.
- As a general rule, the name is VeeamBackup.
- Period of analysis: Period during which the job will run, in the following format: days-hours-minutes.
example To run the job daily, enter 01d00h00m.
- Jobs to include: Name of the job as specified in Veeam.
- Caution: You must not use accents.
- Job type: Enter one of the values proposed in the tooltip for the field.
- From EV Observe version 4.1 onwards, this field is no longer mandatory.
- Click Validate.