ELM Editor

ELM Editor is a customizable reporting engine that has the ability to email reports or save them to a directory.  There are Sample Custom Reports available to use as is or customize to your needs for common tasks.

New reports can easily be created from Event Views and Performance Data.

It is important to note that in order for a report to return data, the data must be collected by a Monitor Item first.

Editor Reports can be viewed from the ELM Console by expanding the Reports > ELM Editor container.

Note
Most reports are resource intensive and should be scheduled off peak hours.

Creating Reports

The best method for creating Editor Reports from events is to base them on Event Views. To generate an Editor Report based on an existing Event View:

•Expand Results > Event Views container and choose an Event View on which to base a Editor Report. Right-click the Event View and choose Create Editor Report.

•These Editor Reports will retain the properties of the Event View to include the Maximum number of Events, View Style, Date Range, and Summary/Detail View.

•These Editor Reports may be edited or modified like any other Editor Report. See: Modify ELM Editor Report

Changing the report date range

The default time span for each report is ThisWeek. The date range for any report can be quickly changed by right-clicking on the report name > Date Range…, and select the range you wish to view.

User Pre-defined range refers to the date range found in the SQL query of the report.  Selecting any of the pre-defined date ranges in the list above temporarily overwrites this value.  When you select User-predefined range, the report date range returns to that specified in the SQL query.

Note
If an ELM Editor report has multiple sections and the date range differs between sections, or the report has query has been customized, the shortcut to change date ranges will not display in the submenu when you right-click on a report.

Note
Customized report may not have option to change date ranges or use categories when scheduling.

Assign Report to Monitoring Categories

To assign a report to specific Monitoring categories, right-click on the report name à Monitoring Categories, and select the category you wish to view data for.  Only categories that contain systems will be displayed on the sub menu.

Managing Scheduled Reports

Scheduling reports allows you to run the report at regular intervals.

To Open the Editor Report scheduler:

1.Right-click on the Editor Report you wish to schedule.

2.Choose Schedule Report, and the Editor Report Schedule Wizard dialog will appear.

3.Select the frequency you desire the report to run (Schedule Type).

4.Select the time of day you wish the report to run (Run at).

5.Select the starting day for the schedule (On).

6.Select the days you want the report to run (Days).  Click Next.

7.Select the delivery Method for the report (Type). Options are e-mail and File. Further options depend on the Type selected.

•If e-mail is selected, enter the recipient's e-mail address and the Mail Server name or IP address. Multiple recipients must be comma/semicolon delimited.

•If File is selected, enter the path to the file storage location. This can be a local or unc path.

8. Select the Output Format.  Options are PDF and CSV.

•Selecting PDF outputs a report that in the .pdf format that reflects the report shown in the report preview pane.

•Selecting CSV outputs a report in a .csv format that lays out the raw data as comma separated values on a spreadsheet. Most spreadsheet programs are able to open .csv files.

9. Select the preferred Page Orientation or leave Auto Orient.

10. Click Finish.

Note
Variables can be used in the Directory and Name fields. Using variables, you may replace or create new files as needed. To replace files, ensure the name will be identical each time the report is run. To create new files, ensure it is different by using the appropriate variables.  Possible variables: %ELMInstallPath%,%ReportName%,%Time%,%Month%,%Year%,%Day%. A network directory can be used as well.

To Change a Report Schedule

1.Under Report Schedules, right-click on the Editor Report and select Properties.

2.Enter values for the Scheduler Wizard dialogs as in the above steps 4-9.

To Delete a Report Schedule

1.Select the Report Schedules node.

2.Right-click on the undesired schedule.

3.Select Delete from the context menu.

Viewing Completed Reports

Schedule status and completed reports can be viewed in the Report Schedules node.

To view a report through the Report Schedules node:

1.Expand Reporting-->ELM Editor and select Report Schedules in the navigation tree.

2.On the right-hand side, click on View Results for any completed reports.