Comprehensive data protection for all workloads
Post Reply
BerndV
Novice
Posts: 5
Liked: 1 time
Joined: Feb 09, 2011 10:32 am
Full Name: Bernd Vojanec
Contact:

Custom Reports with Microsoft Reporting Services

Post by BerndV » Mar 01, 2011 9:38 am

Hello,

is someone using the Microsoft Reporting Services to create custom reports in Veeam?
My idea is a report of all backup jobs created automatically every week and stored as a PDF file.

The database "VeeamBackupReporting" contains all data that are of interest for such a report.
Below is a SQL query I created:

Code: Select all

SELECT     dbo.[Backup.Model.JobSessions].job_name, dbo.BObjects.object_name, dbo.[Backup.Model.JobSessions].creation_time, 
                dbo.[Backup.Model.JobSessions].end_time, [Backup.Model.BackupJobSessions].avg_speed, dbo.[Backup.Model.JobSessions].result
FROM         dbo.[Backup.Model.JobSessions] INNER JOIN
                      dbo.ObjectsInJobs ON dbo.[Backup.Model.JobSessions].job_id = dbo.ObjectsInJobs.job_id INNER JOIN
                      dbo.BObjects ON dbo.ObjectsInJobs.object_id = dbo.BObjects.id INNER JOIN
                      dbo.[Backup.Model.BackupJobSessions] ON dbo.[Backup.Model.JobSessions].id = [Backup.Model.BackupJobSessions].id
With the Microsoft Report Builder you can make it a nice report and publish and schedule it with Reporting Services.
____________________________________________________________________
|JobName | ObjectName | Creation time | Duration | Processing Rate | Result |


Like your opinion about that, you have suggestions or tips?

Thanks
BerndV

Alexey D.

Re: Custom Reports with Microsoft Reporting Services

Post by Alexey D. » Mar 01, 2011 10:04 am

Hello Bernd,

Interesting idea :) You wrote a good script and SSRS is a powerful reporting tool - so why not to use it? Thanks for sharing.

Gostev
SVP, Product Management
Posts: 24788
Liked: 3521 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Custom Reports with Microsoft Reporting Services

Post by Gostev » Mar 01, 2011 12:54 pm

I would not recommend using our configuration database directly, simply because it changes significantly from version to version due to new functionality being added and existing functionality being enhanced. That is unless of course you are prepared to update your solution continously as the new releases come out.

BerndV
Novice
Posts: 5
Liked: 1 time
Joined: Feb 09, 2011 10:32 am
Full Name: Bernd Vojanec
Contact:

Re: Custom Reports with Microsoft Reporting Services

Post by BerndV » Mar 01, 2011 1:06 pm

Thats an argument,
but what other options do I have to create custom reports?
Are there any tools that can be used instead?

Gostev
SVP, Product Management
Posts: 24788
Liked: 3521 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Custom Reports with Microsoft Reporting Services

Post by Gostev » Mar 01, 2011 1:26 pm

PowerShell SDK would be the recommended way.

Post Reply

Who is online

Users browsing this forum: Asahi, Baidu [Spider], Bing [Bot] and 52 guests