Use the Minimum in group function
in a query or situation to compare the attributes returned and select
the one with the lowest value.
- Minimum in group
- For attributes that return multiple rows, the MIN function finds
the lowest returned value (or values).
- Query example
- This function finds the process with the lowest priority base.
GROUP BY is Server Name, so the view will show the process with the
lowest priority base on each system.
MIN(Priority Base)
- Situation example
- The relational operator is set to == and the value to TRUE. The
MIN function is meaningful when combined with another expression.
This formula finds the process with the lowest priority base. If it
also has more than 20% privileged time, the comparison is true.
MIN(Priority Base)== *TRUE AND % Privileged Time >= 20