Forum Discussion

2 Replies

  • 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.

  • 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.