cancel
Showing results for 
Search instead for 
Did you mean: 

EV Reports mailed to Admins

ashks2014
Level 5

Does anyone know if the EV archiving reports can be configured to be sent out via email? EV version 10.0.4

2 REPLIES 2

JGrilli
Level 3
Partner Accredited

This is an excerpt from pg 63 of the EV 10.0.4 Reporting doc.

All of the 10.0.4 documentation is here:  https://www.veritas.com/support/en_US/article.DOC6282

From Report Manager you can schedule reports to be emailed to a configured email address, or saved to a shared folder. To perform these actions, use the Microsoft SQL Server Reporting Services Subscription mechanism. For moreinformation see the Microsoft help on Subscriptions.

In short, the answer is yes, but you need to email them through the SQL Reporting features.

GertjanA
Moderator
Moderator
Partner    VIP    Accredited Certified

Above is via reporting.

If you want to send the html reports, you can use the below. That is what we have configured in our systems. The mentioned cmd and ps1 are in d:\support\scripts\ev folder, change to your situation.

1 CMD file having line:

%SystemRoot%\syswow64\WindowsPowerShell\v1.0\powershell.exe D:\Support\Scripts\EV\Send_archiving_report.ps1

1 Send_archiving_report.ps1 - edit at least your SMTPServer value, and the Mailfrom/Mailto lines.

$RootFolder="D:\Program Files (x86)\Enterprise Vault\Reports\Exchange Mailbox Archiving"
$SuffixFolder="Scheduled"
$ItemPrefix="Full"
$ItemSuffix=".htm"

$SMTPServer="smtprelay.domain.com"
$MailFrom="Vault_Service_Account@domain.com"
$MailTo="mailbox1@domain.com","mailbox2@domain.com"
$MailSubject="Archiving Report EVServer X"
$MailBody=@"
Overview of scheduled archiving run.
"@

$SubFolders=Get-ChildItem $RootFolder | ? { $_.PSIsContainer }
$Attachments=@()
foreach($SubFolder in $SubFolders){
       $Folder=Join-Path $SubFolder.FullName $SuffixFolder
       $Item=Get-ChildItem ((Get-ChildItem $Folder) | Sort -Descending LastWriteTime | Select -First 1).FullName | ? { $_.Name -like "$ItemPrefix*$ItemSuffix" }
       $Attachments+=$Item.FullName
}

Send-MailMessage -Attachments $Attachments -Body $MailBody  -Subject $MailSubject -From $MailFrom -To $MailTo -SmtpServer $SMTPServer

 

--

Have a scheduled task call the cmd-file, using the VSA, or an account that has local access to the folders on the server.

What this does is to look in the folder d:\Program Files (x86)\Enterprise Vault\Reports\Exchange Mailbox Archiving\ last written xfull.htm, and sends that as attachment to the configured mailaddresses.

Regards. Gertjan