VMware vSphere + Turbot Steampipe

vSphere VMware vSphere is VMware's virtualization platform, which transforms data centers into aggregated computing infrastructures that include CPU, storage, and networking resources by VMware

Steampipe is an open source CLI for querying cloud APIs using SQL from Turbot

Getting Started

Installation

Download and install the latest vSphere plugin:

steampipe plugin install theapsgroup/vsphere

Prerequisites

• vSphere cluster
• (Readonly) credentials

Configuration

Configuration can be done using both a configuration file and environment variables.

Note: Configuration file variables will take precedence over environment variables.

Configuration File:

connection "vsphere" {
  plugin = "theapsgroup/vsphere"

  vsphere_server  = "192.168.122.233"
  user  = "root"
  password  = "s0Mep@ss"
  allow_unverified_ssl = true
}

Environment variables:

export VSPHERE_SERVER=192.168.122.233
export VSPHERE_USER=root
export VSPHERE_PASSWORD='s0Mep@ss'
export VSPHERE_ALLOW_UNVERIFIED_SSL=true

Example queries

• Virtual Machine related queries
• Host related queries
• Datastore related queries
• Network related queries