com.atlassian.confluence.content.render.xhtml.migration.exceptions.UnknownMacroMigrationException: The macro 'html' is unknown.
minif
- Haim Koschitzky
Owned by Haim Koschitzky
Jun 07, 2016
1 min read
Loading data...
Synopsis
Calculates the maximum of the values in a specified column in the search query results based on a query to be executed on the record.
Syntax
minif [column_name] “[search_query]”
Required Arguments
column_name
Syntax: <character string>
Description: The name of a column header that has numeric values
search_query
Syntax: <character string>
Description: The search query to be executed on the record
Optional Arguments
None
Description
From all the search query results, returns the minimum value in the specified column_name.
Examples
Example 1:
* in log.access | minif Bytes Sent "status=200"
Returns the minimum value of the column Bytes Sent in the events from access log only if the value of column status is 200.
Example 2:
* in log.iis log | minif time-taken "cs-host contains http" | group by c-ip
From the events from log.iss log that have the text http in their cs-host column, finds and returns the minimum value in the time-taken column per each c-ip column value.