Comprehensive data protection for all workloads
Post Reply
FlagSStaff
Novice
Posts: 3
Liked: never
Joined: Jul 02, 2019 4:58 pm
Full Name: Brian Corbett
Contact:

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

Post by 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
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

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

Post by veremin »

We've replaced CSV format with JSON one. Currently, there are no immediate plans to bring it back. Thanks!
FlagSStaff
Novice
Posts: 3
Liked: never
Joined: Jul 02, 2019 4:58 pm
Full Name: Brian Corbett
Contact:

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

Post by 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
Expert
Posts: 159
Liked: 28 times
Joined: Sep 29, 2017 8:07 pm
Contact:

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

Post by 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
Novice
Posts: 3
Liked: never
Joined: Jul 02, 2019 4:58 pm
Full Name: Brian Corbett
Contact:

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

Post by 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
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

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

Post by veremin » 1 person likes this post

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
Influencer
Posts: 18
Liked: never
Joined: May 24, 2018 4:12 am
Full Name: Jim Bell
Contact:

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

Post by 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
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

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

Post by veremin »

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

Thanks!
jbcap
Influencer
Posts: 18
Liked: never
Joined: May 24, 2018 4:12 am
Full Name: Jim Bell
Contact:

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

Post by 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
Post Reply

Who is online

Users browsing this forum: Google [Bot], legil.miguel and 183 guests