Custom Reports with Microsoft Reporting Services

[BerndV]

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.]

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]

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]

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

[Gostev]

PowerShell SDK would be the recommended way.