Replication report

PowerShell script exchange

Replication report

Veeam Logoby oasis » Tue Feb 18, 2014 8:22 am

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
oasis
Lurker
 
Posts: 2
Liked: never
Joined: Tue Feb 18, 2014 8:18 am
Full Name: NFF OASIS

Re: Replication report

Veeam Logoby Vitaliy S. » Tue Feb 18, 2014 8:30 am

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!
Vitaliy S.
Veeam Software
 
Posts: 19575
Liked: 1106 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Replication report

Veeam Logoby v.Eremin » Tue Feb 18, 2014 8:43 am

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.
v.Eremin
Veeam Software
 
Posts: 13296
Liked: 974 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Replication report

Veeam Logoby oasis » Tue Feb 18, 2014 9:08 am

@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
oasis
Lurker
 
Posts: 2
Liked: never
Joined: Tue Feb 18, 2014 8:18 am
Full Name: NFF OASIS


Return to PowerShell



Who is online

Users browsing this forum: No registered users and 4 guests