No CSV D/L Option for EM License Report #03644661

[FlagSStaff]

Has anyone else noticed that when trying to download the license usage info for monthly reporting you can no longer save as .csv? It seems the only options you have no are a .json file or html. really missing the .csv format, as it much easier to compile all the data in Excel! I've spoken with Veeam about this and they have no idea what happened. Thanks!

[veremin]

We've replaced CSV format with JSON one. Currently, there are no immediate plans to bring it back. Thanks!

[FlagSStaff]

Thanks for the reply. WHY??? .json files are a royal pain to work with. The .csv files allow for easy totaling of the license usage. Now we have to manually count and add them all up, which takes a considerable amount of time. This is a HUGE error on the part of Veeam, making your customers' lives much harder. Please bring it back!!!!

[Mgamerz]

You could write a program to parse that in c# or python to excel fileformat really easy. There are libraries for both like newtonsoft for json and closedxml for excel.

[FlagSStaff]

I know how to do the powershell conversion, but it quite time consuming for every server, as well. Just trying to understand why Veeam made this choice, as it makes no sense.

[veremin]

CSV format wasn't popular and wasn't received well. JSON was requested as alternative. So, we've followed customers' demand and replaced CSV with JSON.

By the way, it's a first time we're receiving a complain regarding this decision.

Thanks!

[jbcap]

Hi,

So similarly in B&R... no CSV? WTF?

The JSON report (B&R or EM) doesn't include VM details, just the usage summary.
The PDF is useful as a standalone report but useless for further data manipulation.

As a workaround I can copy/paste from the EM page (where you download the report in PDF/JSON from) into Excel.

Please bring back csv, or a powershell command like Get-VBRInstalledLicenseInstances or something.

plz & thx.

[veremin]

1) What exact details are missing in JSON report?
2) License management cmdlets will be available in version 10

Thanks!

[jbcap]

Hi,

Maybe I misunderstand what it's for but I'd expect it to have which VMs are actually licensed rather than what looks to be a summary for each license type? It certainly is different information from what the pdf provides.

Code: Select all

{
    "reportDate": "01-15-2020",
    "products": {
        "supportId": "xxxxxxx",
        "edition": "Enterprise Plus Edition",
        "installationId": "xxxxxxxxxxxxxxxx",
        "data": [
            {
                "counterType": "BaaS_vSphere",
                "multiplier": 1,
                "numberOfObjects": 78,
                "numberOfNewObjects": 0,
                "numberOfRentalObjects": 0,
                "numberOfRemovedObjects": 0,
                "consumedInstances": 78,
                "newInstances": 0,
                "rentalInstances": 0,
                "removedInstances": 0,
                "reasonForRemoval": ""
            },

....snip