• EN

PowerShell Script to Collect Backup/Replication Usage from VSPC

JonahMay
Userlevel 6
Badge +10

The script can be accessed here.

 

This script queries all cloud connect tenant resources and returns metrics on them to help find consumed resources. Simply edit the API token on line 27 and the VSPC base URL on line 33.

 

Resource Information Returned:

Company

Tenant Name

Cloud Connect Server

Backup Enabled (Y/N)

Replication Enabled (Y/N)

Repository Name

Repository Type

Repository Server Host Name

Backup Storage Used (TB)

Replication Storage Used (TB)

Replication Memory Used (GB)

Replication vCPUs Consumed

Jonah May - VMCA | Veeam Vanguard | Join the Veeam Community Hackathon @ https://veeamhackathon.com

7 comments

Chris.Childerhose
Userlevel 7
Badge +20

This is great!  Thanks for sharing this as we do a lot of VCC so I can check this out to help automate things. 😎

Chris Childerhose - VMCA2022 | VMCE2023 | Veeam Vanguard 7* | Veeam Legend 3* | vExpert 5* | VCAP-DCV/VCP-DCV | Object First Ace | Cisco Champion | Twitter: @cchilderhose | Blog Site – https://just-virtualization.tech
M

Can this same script be used with MFA enabled for the company?

Nico Losschaert
Userlevel 7
Badge +11

Thx for sharing this @JonahMay. I will try this on our VCC infrastructure, can be handy 😅

#Veeam Legend 5* | VMCA 2* | VMCE 3* | VMTSP+ 2* | VMSP 2* | DCIE 2* | Loves Best Practices | Twitter : @NLosschaert
JonahMay
Userlevel 6
Badge +10

Can this same script be used with MFA enabled for the company?

I am not 100% sure as I have only tested this in my lab with MFA not configured, but I believe VSPC’s API tokens don’t utilize MFA so it should work.

Jonah May - VMCA | Veeam Vanguard | Join the Veeam Community Hackathon @ https://veeamhackathon.com
vAdmin
Userlevel 7
Badge +2

Thank you @JonahMay for sharing the script, it really helps.

Microsoft Azure Solutions Architect Expert, VMware Certified Professional - DCV 7, Citrix Certified Professional Virtualization (CCP-V), ITIL Practitioner
K

Thanks alot @JonahMay,

Ive modified the script a bit so that it includes how many vm:s each customer is backing up too. (if you charge for that).

If someone needs it just contact me (so i can tidy up the code) :)

JonahMay
Userlevel 6
Badge +10

Thanks alot @JonahMay,

Ive modified the script a bit so that it includes how many vm:s each customer is backing up too. (if you charge for that).

If someone needs it just contact me (so i can tidy up the code) :)

Awesome to hear! That isn’t something my company does, hence why it isn’t implemented. I have worked on some enhancements that I will be uploading in the coming weeks.

 - Collecting Insider Protection usage metrics

 - For customers on SOBRs, separating hot vs. capacity usage

 - Collecting M365 consumption information

 - Collecting license consumption information (local VBR, VB365, and cloud connect)

 - Write to XLSX with pre-generated tables now instead of CSV

 - Split the data into multiple tabs (License, BaaS, DRaaS, M365, No Information)

 - Collect from multiple VSPC servers

 

I’m just putting some final polish on the code before I put it live.

Jonah May - VMCA | Veeam Vanguard | Join the Veeam Community Hackathon @ https://veeamhackathon.com

Comment


Terms & Conditions