SQL Query: Total time for a Veeam Backup job



I’m using Veeam Backup for while now, and one thing I can’t find is the total time for a backup job. The only two values are start and end time. I wanted to see what the total time for a backup job is, so I created the following query:

image
The query will generate the following output:

image

You can download the SQL file here:

Advertisements

2 thoughts on “SQL Query: Total time for a Veeam Backup job

  1. B

    Thanks for the post, however your VC name that is blurred out in the table is still populated in the script…

    Just a heads up!

    -B

    Reply
  2. Pingback: Powershell: Script to Query the Veeam Backup database « ICT-Freak.nl

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s