Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > Log & Event Manager (LEM) > Log & Event Manager (LEM) Documentation > LEM Administrator 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.


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


    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.


    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.


  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.


  2. Click Delete to remove the query options.

  3. Click OK.

    The original report appears in the Preview frame.

Last modified