Customizable Billing Report

Management reporting and documentation

Customizable Billing Report

Veeam Logoby wilkins44 » Thu 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.
wilkins44
Enthusiast
 
Posts: 28
Liked: 5 times
Joined: Tue Sep 24, 2013 11:17 am
Full Name: Jay Wilkins

Re: Customizable Billing Report

Veeam Logoby Shestakov » Fri 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!
Shestakov
Veeam Software
 
Posts: 4865
Liked: 396 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Customizable Billing Report

Veeam Logoby wilkins44 » Fri 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.
wilkins44
Enthusiast
 
Posts: 28
Liked: 5 times
Joined: Tue Sep 24, 2013 11:17 am
Full Name: Jay Wilkins

Re: Customizable Billing Report

Veeam Logoby Shestakov » Fri 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.
Shestakov
Veeam Software
 
Posts: 4865
Liked: 396 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Customizable Billing Report

Veeam Logoby wilkins44 » Mon 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.
wilkins44
Enthusiast
 
Posts: 28
Liked: 5 times
Joined: Tue Sep 24, 2013 11:17 am
Full Name: Jay Wilkins

Re: Customizable Billing Report

Veeam Logoby Shestakov » Mon 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!
Shestakov
Veeam Software
 
Posts: 4865
Liked: 396 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Customizable Billing Report

Veeam Logoby wilkins44 » Mon 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.
wilkins44
Enthusiast
 
Posts: 28
Liked: 5 times
Joined: Tue Sep 24, 2013 11:17 am
Full Name: Jay Wilkins

Re: Customizable Billing Report

Veeam Logoby Shestakov » Wed 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!
Shestakov
Veeam Software
 
Posts: 4865
Liked: 396 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Customizable Billing Report

Veeam Logoby wilkins44 » Fri May 05, 2017 4:00 pm

So you can save it as CSV? I'm only seeing Excel (.xlsx), PDF, or Word.
wilkins44
Enthusiast
 
Posts: 28
Liked: 5 times
Joined: Tue Sep 24, 2013 11:17 am
Full Name: Jay Wilkins

Re: Customizable Billing Report

Veeam Logoby Shestakov » Fri 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).
Shestakov
Veeam Software
 
Posts: 4865
Liked: 396 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Customizable Billing Report

Veeam Logoby wilkins44 » Fri May 05, 2017 4:52 pm

Got it. I'll check with our SQL guys to see what we've got.
wilkins44
Enthusiast
 
Posts: 28
Liked: 5 times
Joined: Tue Sep 24, 2013 11:17 am
Full Name: Jay Wilkins

Re: Customizable Billing Report

Veeam Logoby Shestakov » Fri May 05, 2017 5:48 pm

Let us know if that works.
Thanks!
Shestakov
Veeam Software
 
Posts: 4865
Liked: 396 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov


Return to Reporting



Who is online

Users browsing this forum: Bing [Bot] and 3 guests