Submit a ticketCall us

Bridging the ITSM Divide
Integrated help desk and remote support software for faster resolution

Join us on Wednesday, November 29, 2017 at 11 a.m. CT, as we discuss the benefits of effectively integrating your help desk software with remote support solutions to help increase the efficiency of IT administration, improve communication, and decrease mean time to resolution (MTTR) for IT issues of all sizes. This directly impacts end-user satisfaction and your business’ bottom line. Register Now.

Home > Success Center > Log & Event Manager (LEM) > LEM Administrator's Guide > Use the Select Expert tool to create a more focused LEM report

Use the Select Expert tool to create a more focused LEM report

Updated: September 15, 2017

The Select Expert tool lets you execute queries to create a smaller, more focused report from a larger text-based report.

You can use this tool when you are viewing the text-based view of a report in the Preview frame. You cannot use this tool with the default graphical view displayed when you first run the report.

To View the text-based details of a report, check that the View tab is open and click the tree button to open the subtopics in the reports list. Click the content-based subtopic to jump to that section of the report.

If using the Select Expert to filter report data by date or time fields (such as InsertionTime or DetectionTime) results in an error, clear the error prompt, return to the Select Expert, and delete the time-based filter. To filter by time and date, you must run the report with the specified range.

View the text-based details of a report

In the View tab, click the tree button to open the subtopics in the reports list. Click the content-based subtopic to jump to that section of the report.

Run a report query using the Select Expert tool

  1. Run a report. See Run an on-demand report in the LEM reports application for help.

    The report opens on the View tab.

  2. In the View tab, locate the View group and click Select Expert.

  3. Click either the New button or the <New> tab.

    File:Success_Center/Reusable_content_-_InfoDev/LEM/Log_and_Event_Manager_Administrator's_Guide/LEM_Administrator's_Guide/1080-Use_the_Select_Expert_tool_to_create_a_more_focused_LEM_report/selectexpertempty.png

    The Fields form displays with the various report fields you can query on this report.

    File:Success_Center/Reusable_content_-_InfoDev/LEM/Log_and_Event_Manager_Administrator's_Guide/LEM_Administrator's_Guide/1080-Use_the_Select_Expert_tool_to_create_a_more_focused_LEM_report/selectexpertfields.png

    Click Browse to display list of available fields you can select with the tool.

  4. Select the field you want to query, and then click OK.

    The Select Expert form displays.

    File:Success_Center/Reusable_content_-_InfoDev/LEM/Log_and_Event_Manager_Administrator's_Guide/LEM_Administrator's_Guide/1080-Use_the_Select_Expert_tool_to_create_a_more_focused_LEM_report/selectexpertseveraloptions.png

    The first tab displays your selected field name. It lists the query options for that field and includes an adjacent list where you can select a specific value.

  5. In the left drop-down menu, select a query option for the field.

  6. In the adjacent right-hand list box, select a specific value for the field.

    You can click Browse Data to view a complete list of values in the report for that field. From the Browse Data box, you can select a value, and then click Close to apply that value to the query.

    File:Success_Center/Reusable_content_-_InfoDev/LEM/Log_and_Event_Manager_Administrator's_Guide/LEM_Administrator's_Guide/1080-Use_the_Select_Expert_tool_to_create_a_more_focused_LEM_report/selectexpertbrowsedata.png

  7. Repeat Steps 3 – 6 for each field you want to add to the query.

  8. Click OK to close the form and apply the query.

    The new report displays in Preview frame.

    You can use the Preview frame’s toolbar to save or export the report.

Restore the original report after using the Select Expert tool

When you are through querying a report with the Select Expert tool, you can restore the report to its original state.

To turn off the Select Expert settings:

  1. In the View tab in the View group, click Select Expert.

    The Select Expert form displays.

    File:Success_Center/Reusable_content_-_InfoDev/LEM/Log_and_Event_Manager_Administrator's_Guide/LEM_Administrator's_Guide/1080-Use_the_Select_Expert_tool_to_create_a_more_focused_LEM_report/selectexpertempty.png

  2. Click Delete to remove the query options.

  3. Click OK.

    The original report appears in the Preview frame.

Last modified

Tags

Classifications

Public