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.