Virtually Sober

If there is free booze and Virtualization; I'm there!

Category Archives: Uncategorized

Creating a vSphere Change Management DB for free – Step 3 of 4

In my previous 2 blog posts I took you through creating a vSphere Change Management Database, how to insert data using PowerCLI, and in this post, I’ll show you some example queries you can run once you have the data. If you missed the first 2 posts check them out here:

Step 1 – Creating the SQL Database
Step 2 – Inserting data into the SQL Database

There are probably hundreds of different things you can derive from the data captured. So here is just a sample of what I’m going to show you:

  • Show all configurations of a VM across all data logged
  • Taking oldest date available and showing all VM configs on that datetime
  • Taking the most recent data available and showing total VM size provisioned and used (useful for Rubrik sizing)
  • Using the oldest and most recent VM used size to calculate the total VM used storage growth % (also useful for Rubrik sizing!)
  • Show all VMDisk and VMNIC configurations for a VM
  • Show all configurations for a VMDK or VMNIC
  • Show all configurations for a Port Group on a host
  • Show all configurations of a Cluster and Host
  • Taking the oldest date available and showing all original Cluster and Host configs
  • Show all current and historical stats for a Datacenter (including cluster, host and VM counts etc)

Read more of this post

Working with SQL databases using PowerShell

One of the things I love about PowerShell is the sheer number of use cases you can address. A perfect example is working with SQL databases. If you think you need to wait for a DBA to give you data from a SQL database then you’d be wrong. You can use SELECT queries to pull data directly into PowerShell from any SQL database and not only that, you can also INSERT, UPDATE, DELETE or whatever else you desire, all from the comfort your scripts using invoke-sqlcmd in the Sqlserver PowerShell module. This also means you can now store data from your PowerShell scripts in SQL for long-term reporting, configuration management, you name it.

SQLServerBrowser

Read more of this post

Automated bulk IP address reconfiguration with Zerto Virtual Replication

If you tried to use this example before 04/25/17 there was a typo in the export script which left 2 key fields blank subsequently causing an error on import. I’ve now fixed the issue so now is as good a time as any to give this cool script a run in your Zerto environment for bulk IP configuration.

Protecting & Recovering Multi-TB VMs to Microsoft Azure

When replicating to Microsoft Azure using Zerto Virtual Replication 5.0 (or even Azure Site Recovery) the protected vDisks cannot be larger than 1TB due to the maximum page disk size being limited to 1TB by Microsoft. It’s rumored they are planning on increasing this to 8TB later this year, but in the meantime how do you work around this problem?
The good news is that there is a solution! On the protected VM you need to configure multiple sub-1TB disks. Don’t use 1TB exactly as the disk size, as this equates to 1024GB in a vSphere environment which is above the Azure page disk limit. Instead use a value of say 990GB to stay under the limit, but with a decent amount of space. Here you can see I’ve created 2 x 990GB VMDKs for my VM:

multi-tbvmstoazuress1

Read more of this post

Automate VM Protection with vRO & Zerto Virtual Replication – ZVM only

In this blog post I will show you how to fully automate the protection of new VMs with Zerto Virtual Replication 4.5 (ZVR) and vRealize Orchestrator (vRO).

This example is for a Zerto Virtual Manager (ZVM) that is not managed by a Zerto Cloud Manager (ZCM) and therefore won’t use the concept of ZCM managed service profiles. We will be using a combination of vSphere folders, vRO, PowerShell, a settings CSV and ZVR REST APIs to achieve automated protection.

Read more of this post

Automate VM Protection with vRO & Zerto Virtual Replication – ZVM & ZCM

In this blog post I will show you how to fully automate the protection of new VMs with Zerto Virtual Replication 4.5 (ZVR) and vRealize Orchestrator (vRO).

This example is for a Zerto Virtual Manager (ZVM) that is managed by a Zerto Cloud Manager (ZCM) and therefore uses service profiles pushed from the ZCM to the ZVM. A new service profile has to be created from the ZCM and used in this workflow as this is a requirement of automating VM protection through the Zerto API. We will be using a combination of vSphere folders, vRO, PowerShell, a settings CSV and ZVR REST APIs to achieve automated protection.

Read more of this post

Automating Bulk VM Protection – ZVM & ZCM

In this blog post I will show you how to automate the protection of VMs during initial configuration or re-installation of Zerto to a new datacenter. This example is only for a Zerto Virtual Manager (ZVM) managed by a Zerto Cloud Manager (ZCM).

I’m going to be using a combination of PowerShell, REST APIs and CSVs to complete the task. As a best practice I wouldn’t recommend creating too many VPGs simultaneously as you don’t want to overload the vCenter, storage, WAN and Zerto resources available to you. I’ll leave you to decide your own number but I personally would stick to batches of 5-25 depending on what you have at your disposal.

Read more of this post

Automating Bulk VM Protection with Zerto Virtual Replication – ZVM only

In this blog post I will show you how to automate the protection of VMs during initial configuration or re-installation of Zerto to a new datacenter. This example is only for a Zerto Virtual Manager (ZVM) that is not managed by a Zerto Cloud Manager (ZCM).

I’m going to be using a combination of PowerShell, REST APIs and CSVs to complete the task. As a best practice I wouldn’t recommend creating too many VPGs simultaneously as you don’t want to overload the vCenter, storage, WAN and Zerto resources available to you. I’ll leave you to decide your own number but I personally would stick to batches of 5-25 depending on what you have at your disposal.

Read more of this post

Introduction to Automating VM Protection with Zerto Virtual Replication

One of the most common requests I hear in my role at Zerto is to automate the protection of VMs. The 2 main use cases for this request are typically:

  1. Bulk VM protection during initial installation or re-installation. I.E you have 800 VMs to re-protect to a new datacenter and it would make more sense to automate the process (which came from a recent customer request).
  2. Automate the protection of new VMs. I.E you have new VMs being created on an hourly/daily/weekly basis be it from templates, vRealize Orchestrator or a self-service catalog and you want to automate the protection of VMs without having to manually configure DR.

The good news is that both of these use cases are easily achievable using Zerto Virtual Replication 4.5, PowerShell and the new APIs, with the examples I’m going to give you.

Read more of this post

Getting a List of VMs by VPG

Hi all!

In response to a recent MyZerto forum request I thought I’d write a short post on how to obtain a simple piece of information from Zerto; what VMs are protected and their VPG name. Read more of this post