-
- Novice
- Posts: 3
- Liked: 1 time
- Joined: Jul 02, 2019 4:58 pm
- Full Name: Brian Corbett
- Contact:
No CSV D/L Option for EM License Report #03644661
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!
-
- Product Manager
- Posts: 20415
- Liked: 2302 times
- Joined: Oct 26, 2012 3:28 pm
- Full Name: Vladimir Eremin
- Contact:
Re: No CSV D/L Option for EM License Report #03644661
We've replaced CSV format with JSON one. Currently, there are no immediate plans to bring it back. Thanks!
-
- Novice
- Posts: 3
- Liked: 1 time
- Joined: Jul 02, 2019 4:58 pm
- Full Name: Brian Corbett
- Contact:
Re: No CSV D/L Option for EM License Report #03644661
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!!!!
-
- Expert
- Posts: 160
- Liked: 28 times
- Joined: Sep 29, 2017 8:07 pm
- Contact:
Re: No CSV D/L Option for EM License Report #03644661
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.
-
- Novice
- Posts: 3
- Liked: 1 time
- Joined: Jul 02, 2019 4:58 pm
- Full Name: Brian Corbett
- Contact:
Re: No CSV D/L Option for EM License Report #03644661
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.
-
- Product Manager
- Posts: 20415
- Liked: 2302 times
- Joined: Oct 26, 2012 3:28 pm
- Full Name: Vladimir Eremin
- Contact:
Re: No CSV D/L Option for EM License Report #03644661
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!
By the way, it's a first time we're receiving a complain regarding this decision.
Thanks!
-
- 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
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.
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.
-
- Product Manager
- Posts: 20415
- Liked: 2302 times
- Joined: Oct 26, 2012 3:28 pm
- Full Name: Vladimir Eremin
- Contact:
Re: No CSV D/L Option for EM License Report #03644661
1) What exact details are missing in JSON report?
2) License management cmdlets will be available in version 10
Thanks!
2) License management cmdlets will be available in version 10
Thanks!
-
- 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
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.
....snip
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": ""
},
Who is online
Users browsing this forum: Kazz and 55 guests