SQL query on tape jobs

[rbradley]

Hi All,

We are trying to write a sql query for our monitoring system to get information from veeam re tape backup jobs (as the powershell command is so limited. We have been able to find everything from the email that you get from a view but we cannot find where the tape library and used tapes. Can anyone please help advise where we can find thins information?

Also if any of you Veeam Devs or SQL admin's are reading this i also wouldn't mind some help calculating the job duration in sql.

Thanks,
Richard

[Vitaliy S.]

Hi Richard,

We have a bunch of predefined backup reports in Veeam ONE, that should give you the information you need > Veeam Backup & Replication reports

Let me know if that helps!