Bulk Creation of Azure Object Storage with the Commvault REST API

If you find yourself in a situation where you need to create Azure object storage backups in Commvault for hundreds or thousands of storage accounts this script will automate the process.

bulkCreateCvAzureObject

Use Commvault Rest API to create Azure Object backups for multiple Azure Storage Accounts

• This script will create a credential and instance for Azure File and Azure Blob in Commvault using the REST API
• The script will read from a csv file called sa_keys.csv and create Object (File and Blob) for each Storage Account
• The csv file should be in the same directory as the script
• The csv file should have the following columns: StorageAccountName, StorageAccountKey, servicePrincipal. StorageAccountName is the storage account name, StorageAccountKey is the storage account key, and servicePrincipal is the name of the service principal credential in Commvault
• The script will loop through each line in the csv file and create a credential for file and instance for Azure File and Azure Blob
• The script will use a pre-existing service principal cred for blob. It should exist already in Commvault
• The script will output a log file in the same directory as the script
• Need to set the $planName, $commserve, and $accessNodes variables.
• Domain user credentials should be in format username@domain

Usage

1. Create a csv file named sa_keys.csv in the same directory as the script
2. Populate the sa_keys.csv file with the storage account names, associated storage account key, and the service principal to be used for backups of blob. The first line should have the column headers which are StorageAccountName, StorageAccountKey, servicePrincipal.
3. Run the script ./bulkCreateCvAzureObject.ps1

In addition, this script will get the associated access keys for the storage accounts provided.

getAzureSaKeys

This script will get the storage account keys for each storage account in the sa_accounts.txt file and export them to a CSV file.

Description

This script will get the storage account keys for each storage account in the sa_accounts.txt file and export them to a CSV file sa_keys.csv.

Requirements

• PowerShell 5.1 or higher
• Azure PowerShell module

Usage

1. Create a text file named sa_accounts.txt in the same directory as the script
2. Populate the sa_accounts.txt file with the storage account names with one per line
3. Run the script ./getAzureSaKeys.ps1

So instead of clicking forever and not being so happy about it, rather you can click much less and enjoy some hot cocoa.