# VMware

# Overview

VMware vCenter provides a centralized platform for managing VMware vSphere environments.

VMware vCenter collects and stores statistics from ESX servers in a Microsoft SQL Server database (VIM_VCDB) which Axibase Collector queries every 20 minutes to offload incremental statistics from the VPX_HIST_STAT1 table into Axibase Time Series Database for long-term retention and operations analytics.

# Requirements

• VMware vCenter 5.x+

# Installation Steps

# Import VMware JDBC job

• On the Jobs page, select Import from the split-button below the table and upload the collector-jobs-vmware-jobs.xml file.

# Configure VMware Database Connection

• Open the Data Sources > Databases page and select the sql-vmware database.
• Provide connection parameters to the target VIM_VCDB database as displayed below:

• Execute test query to check the connection:

SELECT 1

Query result must be Query OK.

# Verify Job Configuration

• Open the VMware job.
• Set Data Source to sql-vmware.

• Choose a target ATSD server if your Collector instance is connected to multiple ATSD servers.
• Save the Job.
• Open each configuration, click Test, and review the output. See Data Queries below.

# Schedule the Job

• Open the JDBC Job page and click Run for the VMware job.
• Ensure that the job status is COMPLETED and Items Read and Sent commands are greater than 0.

• If there are no errors, set the job status to Enabled and save the job.

# Verify Metrics in ATSD

• Log in to ATSD.
• Click the Metrics tab and filter metrics by the prefix vmware.*.

# Viewing Data in ATSD

# Metrics

• List of collected VMware metrics

# Properties

• List of collected VMware properties

# Entity Groups

• VMware VMs
• VMware Hosts
• VMware Clusters

# Live Portals

• VMware Cluster Portal

• VMware Host Portal

• VMware Host VMs

• VMware VM Portal

# Data Queries

Data queries that offload recent metrics and properties.