1 Reply Latest reply on Jun 11, 2018 10:12 AM by pflanz

    Schedule and email a report issues?

    pflanz

      After a recent upgrade  scheduled reports that use to email a copy of the report no longer works.   The receiver gets an email with the  url but says "reportUnable to retrieve url: http://xxx-xxxxxx/Orion/Report.aspx?ReportID=798 using PDF type"

      Says the same when trying to email a Excel copy of the report

       

      Any thoughts.

       

      Joe

        • Re: Schedule and email a report issues?
          pflanz

          I found this, but when did this change?..it use to work just fine.

           

           

          Set automatic email notifications for scheduled reports

           

           

          Overview

          SolarWinds does not support automatically emailing scheduled reports due to the size of the common and recommended scheduled reports. This article discusses an alternative by scheduling the reports to export to a network share and configure a LEM rule to send an email notification when the reports are finished.

           

          For more information about scheduling reports, see one of the following articles based on your preferred operating system:

          Configuring Default Batch Reports on Vista/7/2008 Computers

          Configure default batch reports on Windows XP/2003 computers

          Environment

          All LEM versions

          Steps

          Schedule the reports

          1. If you want to schedule all of the recommended reports, see one of the articles linked above.
          2. If you want to schedule a specific report, open LEM Reports.
          3. Select the report you want to schedule.
          4. Click Schedule.
          5. Click Add.
          6. Enter a name for your new task in the Task Description field, and then click OK.
          7. Click the Schedule tab.
          8. Click New, and then set the frequency and start time for your task.
          9. If you are finished configuring your task, click OK.
          10. Enter and confirm the password for the user you want Windows Task Scheduler to use to execute the task.
          11. Back on the Report Scheduler Tasks window, select the task you just created and then click Load to View or Edit.
          12. Select the data source, date range, and export preferences in the lower pane, and then click Save.
          13. If you are finished configuring your Report Scheduler tasks, click Close.

          Create an Email Template

          Create an Email Template in the Build > Groups area of your LEM Console. SolarWinds recommends the following parameters in your template:
          • EventInfo
          • DetectionTime
          • ExtraneousInfo
          Notes:
          • The ExtraneousInfo field contains the file path of the report template and export location, if applicable. Use the latter to locate your exported scheduled reports.
          • For additional information about creating Email Templates, see Creating a Custom Email Template.

          Configure a LEM rule

          1. Create a new rule in the Build > Rules area of your LEM Console with one or more of the following correlations.
            • Use InternalInfo.EventInfo = *Report Completed* to fire the rule for any report, regardless of whether or not they are scheduled or run manually.
            • Use InternalInfo.EventInfo = *"Report Title" Report Completed* to specify a single report, where Report Title is the exact name of the report as it appears in LEM Reports.
            • Use InternalInfo.DetectionIP = IP Address of Scheduled Reports Computerto limit the rule to fire only for reports that are run on a specific computer.
            • Use InternalInfo.DetectionTime ContainsScheduled Reports Time of Day Set with a custom Time of Day Set to encompass the times during which you expect your scheduled reports to run. Click for more information about creating Time of Day Sets.
          2. Add the Send Email Message action to your rule and configure the action using the Email Template you created above and specify the users you want to notify of this type of event. For more information on creating rules, see Creating Rules from Your LEM Console to Take Automated Action.
          3. Enable, save, and activate your new rule.