21 Apr 2011

SCOM 2007 R2 - Email Scheduled Reports


Don't forget to configure email settings on a Report Server.





You must configure the e-mail settings in the Report Server using the Reporting Server Configuration Manager before you can send your scheduled reports by email automatically.

  • launch Reporting Services
  • In Reporting Services Configuration Manager, in the Report Server Installation Instance Selection dialog box, click Connect (for remote connection)
  • In the navigation pane, click E-mail Settings, enter the following:
    • An e-mail address for use as the sender address in the Sender Address text box.
    • The address of the SMTP server that will be used to send the e-mail messages in the SMTP Server text box
       
     
    To e-mail scheduled reports 
  •  Log on to the computer with an account that is a member of the Operations Manager Report Operators role for the Operations Manager 2007 management group. 
  • In the Operations console, click the Reporting button. 
  • In the Reporting pane, click Favorite Reports. 
  • In the Favorite Reports pane, right-click the Availability report you saved as a favorite, and then click Schedule.
  • In the Subscribe to a Report Wizard, on the Delivery Settings page, do the following:
    • Type a description in the Description text box.
    • Click the down arrow in the Delivery method list, and then click Report Server E-Mail.
    • Type an e-mail address of the destination inbox to receive reports in the To text box. You can also type e-mail addresses in the Cc, Bcc, and the Reply To text boxes.
    • Click the down arrow in the Render Format list, and then click the file format you want for the report.
    • Click the down arrow in the Priority list, and then select the appropriate priority.
    • Type a subject for the e-mail in the Subject text box.
    • Click Next.

  • On the Subscription Schedule page, do the following:
    • Select one of the Generate the report options.
    • Type a start date and start time for the reports to be generated in The Subscription is effective beginning list. You can also enter the date when this subscription will end in The subscription expires on list, and then click Next.
     
  • On the Parameters page, specify a span of time for the report in the From and To lists, make any other changes you need for this report, and then click Finish.


1 comment:

  1. Hello,
    Anyway to use different Sender email address for the same SSRS?
    Thanks,
    Dom

    ReplyDelete