PowerShell script exchange
Post Reply
oasis
Lurker
Posts: 2
Liked: never
Joined: Feb 18, 2014 8:18 am
Full Name: NFF OASIS
Contact:

Replication report

Post by oasis »

Hello

sorry for my english

what is the table for replications report, not just jobs

I made this request for backups, I want the equivalent for replications.

"SELECT [id],[object_name],[status],[reason],[creation_time] FROM
[VeeamBackup].[dbo].[ReportSessionInfoView] WHERE [creation_time] >= '"+
$DTJOUR +" 19:45:00' AND [status] not in (2,5,6) ORDER BY [object_name]
DESC, [creation_time]"

thank you for your help
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Replication report

Post by Vitaliy S. »

Hello,

It is not recommended to run direct SQL queries against our database, you should be using PowerShell instead. Anyway, if you haven't looked at it yet, then please be aware that we have a bunch of predefined report templates for Veeam backup. These reports are shipped with Veeam ONE.

Thank you!
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Replication report

Post by veremin »

I'm wondering what particular information you're trying to get. With this information, we can, probably, write a necessary script that outputs exactly what you're looking for.

Thanks.
oasis
Lurker
Posts: 2
Liked: never
Joined: Feb 18, 2014 8:18 am
Full Name: NFF OASIS
Contact:

Re: Replication report

Post by oasis »

@Vitaliy : I only read the database (select)

@Eremin, I get a csv file which I then use with Excel
everything is good for the backup report
but I can not find the table to do the same thing with replications
Post Reply

Who is online

Users browsing this forum: No registered users and 15 guests