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 » Jul 02, 2019 5:06 pm

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: 17454
Liked: 1553 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 » Jul 02, 2019 5:58 pm

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 » Jul 02, 2019 7:26 pm

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: 149
Liked: 25 times
Joined: Sep 29, 2017 8:07 pm
Contact:

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

Post by Mgamerz » Jul 02, 2019 7:33 pm

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 » Jul 02, 2019 7:58 pm

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: 17454
Liked: 1553 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 » Jul 03, 2019 10:58 am 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
Novice
Posts: 5
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 » Jan 15, 2020 3:53 am

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: 17454
Liked: 1553 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 » Jan 15, 2020 1:10 pm

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

Thanks!

jbcap
Novice
Posts: 5
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 » Jan 15, 2020 10:37 pm

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: No registered users and 43 guests