Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Service Manager9.52

Use > Service Manager Reports > My reports > Create a report > Report duration chart properties

Report duration chart properties

HPE Service Manager provides duration functionality to count and display the duration information.

The content in a shared standard report varies depending on the report viewer’s privilege. However, the content in a shared calculation or duration report only displays the data information based on the report owner's privilege. The reports which are calculated from the back end apply the same language as which the report owner defines in the My Preference settings.
To process the report data, make sure that all the background schedule processes for reporting are started. For details about how to start the background schedule, see Report background schedule process.

Here are the duration setting preferences for your reference.

Note Select Duration from the drop-down box next to the Type of chart field, and then you can see the duration properties.

Fields

Description

Type of chart

Shows the current chart type. You can change the chart type by selecting the chart type from the drop-down list.

Note Report duration capability does not support the List or Pivot table types of report.

Run in Frontend

If this option is selected, the current duration report can be run immediately. When clicking the Refresh button on the Preview tab of a saved report, the system generates a preview of the current report at once. The related report running task will be removed from the background queue if it was run in backend before. HPE does not recommend to run a duration report frequently because this report type consumes considerable database resources.

Note After you select Run in Frontend, both the Refresh Interval drop-down list and the Run Now button become unavailable.

Refresh Interval

Specifies the interval at which a new report is generated according to your report configurations.

Run Now

Click this button to send the current calculation report to the processing queue. This also enables the report to get the latest source data from the system.

Note This button is only available for a saved report.

Aggregator

Shows the data aggregation method. For different chart types, the report calculation supports different aggregation types, including: sum, average, max, and min.

Group By Field

Shows the field that the records are grouped by in the report. For example, one report might show the number of Incidents by customer; another report might show the number of Incidents by priority.

You can select multiple level fields by clicking the Multi Level Field icon. If you choose a field of date or time, you need to choose a calculator. Service Manager provides year, quarter, month, week, and date for datetime type field.

Note You can specify up to five standard reports. To show the standard report data in the final report, select the check box before the standard data.

Duration Start Field

Shows the duration start field used for calculation in the report.

Duration End Field

Shows the duration end field used for calculation in the report.

Duration Field

Shows the duration field displayed in the report. This option is only available when the Time Duration option is selected. In this situation, you just need to select the duration field directly and save the system from the duration calculation.

Duration Unit

Shows the duration unit displayed in the report. Service Manager provides second, minute, hour, day, week, month, and year for Duration Unit field.

Note For different time duration units, Service Manager sets diffferent unit calculation precision, as shown in the following table.

Duration unit	Calculation precision
year/month/week/day/hour/minute	minute
second	second

Duration Label

Shows the duration label for the report. The label is displayed as the legend in the report.

Query

Shows the query content for the current report. You can click the Query Builder to define the query to display desired information. You can also write a new query directly. For more information about how to edit a query, see Build the query strings and other related topics.

Test Query

Validates the query. A new message pops up to display the diagnostic information for this query string.

Send Help Center feedback