ELM Editor

Previous Next

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.

The best method for creating Editor Reports from performance data is to base them on Performance Data results. To generate a Editor Report based on Performance Data results:

•	Expand Results --> Performance Data container and choose a performance object on which to base a Editor Report. Right-click the performance object and choose Create Editor Report.

•	These Editor Reports may be edited or modified like any other Editor Report.

Report Sections

Additional report sections may be added by right-clicking on the report and selecting Edit --> Add Section from the context menu. Existing report sections may be modified by right-clicking on the section and selecting Edit-->Properties from the context menu.

edit-rpt1

The default time span for each report is ThisWeek. To change the time span, it is necessary to open the sql editor for each report and replace each occurrence of ThisWeek with the desired times pan:

EditorDefaultTime

Modify the existing report section SQL-->SQL Text query to display desired results for the Top clause or time frame.

edit-rpt2

QueryNote

Report section Style displays the results in a RowGrid, SummaryGrid, Html, Chart, or Glossary format.

edit-rpt3

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, File, and Database. 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 delimited.

•	If File is selected, enter the path to the file storage location.

•	If Database is selected, no additional options are available. The report will be stored in the ELM Primary database.

9.	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 size, click on View Results for any completed reports.