Management reporting and documentation
Post Reply
wilkins44
Enthusiast
Posts: 32
Liked: 5 times
Joined: Sep 24, 2013 11:17 am
Full Name: Jay Wilkins
Contact:

Customizable Billing Report

Post by wilkins44 » Apr 20, 2017 8:56 pm

I like the billing report as-is, but I'd like to see if there is a way to run it as a custom report without some of the additional formatting, and export it as a CSV.

Shestakov
Veeam Software
Posts: 6832
Liked: 696 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Customizable Billing Report

Post by Shestakov » Apr 21, 2017 9:07 am

Hello Jay,
There is a custom backup report with such a data, but it doesn`t contain historical information.
As for backup billing, what kind of data you want to filter?
Thanks!

wilkins44
Enthusiast
Posts: 32
Liked: 5 times
Joined: Sep 24, 2013 11:17 am
Full Name: Jay Wilkins
Contact:

Re: Customizable Billing Report

Post by wilkins44 » Apr 21, 2017 4:30 pm

I've been asked if I could get a report that would contain the amount of data being backed up for each VM for billing. Nothing fancy is needed, just the VM name and the amount of backup data on disk from both the backup job and the backup copy. They've also asked for it to be in CSV format.

Shestakov
Veeam Software
Posts: 6832
Liked: 696 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Customizable Billing Report

Post by Shestakov » Apr 21, 2017 4:52 pm

That can be fulfilled with the current report. You just need to have the backups storing on repository with per-VM option enabled, otherwise if several VM are backed up into a single file, it is impossible to value size of each VM due to deduplication.

wilkins44
Enthusiast
Posts: 32
Liked: 5 times
Joined: Sep 24, 2013 11:17 am
Full Name: Jay Wilkins
Contact:

Re: Customizable Billing Report

Post by wilkins44 » Apr 24, 2017 1:53 pm

We've got the per-VM files enabled, but the formatting is throwing off what our billing person is wanting/needing to do. If I run the report asking for one day, I'll get the one line with the VM name on it, and then a second with the amount of data stored for that night and then total. They are asking for it all on one line.

Shestakov
Veeam Software
Posts: 6832
Liked: 696 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Customizable Billing Report

Post by Shestakov » Apr 24, 2017 4:23 pm

If you make a report for 1 day, the amount of data in that day will equal the total amount of data.
In a case you don`t need historical data, but just current amount(the last day), you may use mentioned Custom Backup report. The request of adding historical data into custom report is taken into account.
Thanks!

wilkins44
Enthusiast
Posts: 32
Liked: 5 times
Joined: Sep 24, 2013 11:17 am
Full Name: Jay Wilkins
Contact:

Re: Customizable Billing Report

Post by wilkins44 » Apr 24, 2017 4:44 pm

I agree with you on the data, and I'm getting the data that they need out of the report. The formatting of the report and getting it in a CSV file format is what I'm needing.

Shestakov
Veeam Software
Posts: 6832
Liked: 696 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Customizable Billing Report

Post by Shestakov » Apr 26, 2017 11:08 am

You may save the file in xlsx or csv format and extract the data in a way you need it.
Thanks!

wilkins44
Enthusiast
Posts: 32
Liked: 5 times
Joined: Sep 24, 2013 11:17 am
Full Name: Jay Wilkins
Contact:

Re: Customizable Billing Report

Post by wilkins44 » May 05, 2017 4:00 pm

So you can save it as CSV? I'm only seeing Excel (.xlsx), PDF, or Word.

Shestakov
Veeam Software
Posts: 6832
Liked: 696 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Customizable Billing Report

Post by Shestakov » May 05, 2017 4:17 pm

The default export format depends on the reporting services you use. If you want to have more options in this list, you should be using Standard Plus version of SSRS(SQL Server Reporting Services).

wilkins44
Enthusiast
Posts: 32
Liked: 5 times
Joined: Sep 24, 2013 11:17 am
Full Name: Jay Wilkins
Contact:

Re: Customizable Billing Report

Post by wilkins44 » May 05, 2017 4:52 pm

Got it. I'll check with our SQL guys to see what we've got.

Shestakov
Veeam Software
Posts: 6832
Liked: 696 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Customizable Billing Report

Post by Shestakov » May 05, 2017 5:48 pm

Let us know if that works.
Thanks!

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests