Skip to main content

VSPC Usage Report - v2!


JonahMay
Forum|alt.badge.img+11

I’ve performed a bit of an overhaul on the script I wrote last year. Originally, the script mainly existed in order to give some basic inventory and consumption information. Now, I daresay it is nearly a full-blown consumption report!

 

Changes/enhancements include:

 - Collecting Insider Protection usage metrics

 - For customers on SOBRs, separating performance 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

 

For companies without any billing integrations with VSPC, this makes it relatively easy to compile consumption reports for your billing department each month. Alternatively, you can take the APIs used by this script and write your own automated report or billing integration!

 

The script also now has a new home! All of my content has been moved into a new repository, located here! You can access this script specifically at this link.

15 comments

MarcoLuvisi
Forum|alt.badge.img+5
  • Influencer
  • 270 comments
  • December 21, 2023

Thanks @JonahMay I go to test after Christmas days.
Merry Christmas !


JonahMay
Forum|alt.badge.img+11
  • Author
  • Veeam Vanguard
  • 46 comments
  • December 21, 2023
MarcoLuvisi wrote:

Thanks @JonahMay I go to test after Christmas days.
Merry Christmas !

Same to you!


Chris.Childerhose
Forum|alt.badge.img+21
  • Veeam Legend, Veeam Vanguard
  • 8489 comments
  • December 21, 2023

Thanks for sharing this one Jonah.  I will add this to my list for testing in the new year.  😎


JMeixner
Forum|alt.badge.img+17
  • On the path to Greatness
  • 2650 comments
  • December 21, 2023

😂 my testing list gets longer and longer.

Thank you Jonah, this looks very interesting and useful. 👍🏼


dloseke
Forum|alt.badge.img+8
  • Veeam Vanguard
  • 1447 comments
  • December 22, 2023

Thanks for sharing Jonah!  I’ll check this out!


Jonah thanks for sharing this script. 

In VSPC v8 is able to add backup job to companies from hosted VBR. 

It is possible to add this funcionality to your script to see this data on report?  

 


Jean.peres.bkp
Forum|alt.badge.img+8

nice!


  • New Here
  • 3 comments
  • February 8, 2024

hi @JonahMay,

Fantastic script, it functions seamlessly—almost. We have a few customers who manage two or more repositories within our VSCP.

However, if a customer possesses more than one repository, it fails to appear in BaaS. Could you offer any suggestions on how to resolve this issue?

Kind regards,


JonahMay
Forum|alt.badge.img+11
  • Author
  • Veeam Vanguard
  • 46 comments
  • February 13, 2024
Kristjan wrote:

hi @JonahMay,

Fantastic script, it functions seamlessly—almost. We have a few customers who manage two or more repositories within our VSCP.

However, if a customer possesses more than one repository, it fails to appear in BaaS. Could you offer any suggestions on how to resolve this issue?

Kind regards,

I don’t think our company does this, so it is probably an oversight I made during coding. Likely the loop from line 426 to line 471 needs to be placed inside another foreach loop. I’d also change the variable on line 424 for $resource to $resources and converting it to an array to ensure everything parses correctly. It would end up looking something like this:

$resources = @()
$resources = (Invoke-RestMethod -Uri $resourceURL -Method GET -Headers $headers[$i]).data

foreach($resource in $resources) {
    #lines 426-471 here
}

 

If you’re able to test this change, confirm it works, and submit and PR, I will merge it into the main branch for everyone to be able to use.


JonahMay
Forum|alt.badge.img+11
  • Author
  • Veeam Vanguard
  • 46 comments
  • February 13, 2024
Daniel.Rajczewski wrote:

Jonah thanks for sharing this script. 

In VSPC v8 is able to add backup job to companies from hosted VBR. 

It is possible to add this funcionality to your script to see this data on report?  

 

I haven’t played around with v8 too much yet. What data are you hoping to extract about the jobs?


  • New Here
  • 3 comments
  • October 2, 2024

Hi everyone,
With the latest update to VSCP, some path changes need to be made if you're using this script:
Operation Changes - REST API Reference (veeam.com).

I've also modified @JonahMay 's script to better suit our needs:

 

Just tag me if you want the script ;)


Chris.Childerhose
Forum|alt.badge.img+21
  • Veeam Legend, Veeam Vanguard
  • 8489 comments
  • October 2, 2024

@Kristjan can you DM me the updated script would like to run that one.


dloseke
Forum|alt.badge.img+8
  • Veeam Vanguard
  • 1447 comments
  • October 2, 2024

Oooh @Kristjan can you send to me as well?


  • New Here
  • 1 comment
  • February 20, 2025

@Kristjan Can you post or DM your new script to me as well?  


Stabz
Forum|alt.badge.img+8
  • On the path to Greatness
  • 354 comments
  • February 20, 2025

@Kristjan  I'm interested too !


Comment