License report with job name involved

[Manu80]

Hello,
we need to generate license report from VBR, same as html, but on json or csv for manipulate and customize.

With generate-vbrlicenseusagereport (https://helpcenter.veeam.com/docs/backu ... ml?ver=120) with json type I obtain only summary and don't have list of all VM and related job.

I try some methods with powershell and API (also with VEM), but not find at the moment the solution.

Has anyone been able to do something similar ?

Thanks
manu

[david.domask]

Hi manu80,

Currently the cmdlet only outputs the usage counts. What fully needs to be in your report? Each license workload name and job name or what are you hoping to capture?

I would advise export as HTML and use an HTML parsing module like PowerHTML to extract the information. I don't have a ready script for this but I played briefly and it will let you import an HTML file as an object (similar to ConvertFrom-JSON cmdlet) and from there you can walk the HTML nodes to build your report.

[Dragonspeed]

Well, I've played a bit with PowerHTML to try to generate a functional output list of machines (their types and how many of what license type they are using).... I did NOT have much luck.

[david.domask]

Hi Dragonspeed, welcome to the forums.

Can you share a bit of your code and what you struggled with?

I can give it a shot, but if you have existing code would be great to see what you tried and what didn't work.

Similarly, can you share a bit more on the output you're hoping to get? We can consider improvements to the cmdlet based on feedback.

Also, please consider using the REST API GetLicensedInstances endpoint; you can invoke REST calls with Invoke-WebRequest in your script and parse the resulting data easily in Powershell. Try it out in the Swagger interface for our API from the Remote Console > Menu > Console > Swagger