All DMI functions

These are functions available for DMI expressions used in conditional expressions involving:

  • Calculated columns (various)
  • Breadcrumbs (visible?)
  • Tabs (visible? selected? disabled?)
  • Result display (show?)

Conditional statements

<f_IF> is a conditional expression: <f_IF(bool expression, true expression, false expression)>.

<f_SWITCH> is a switch expression of the form <f_SWITCH(bool expression1, value expression1, .... bool expressionN, value expressionN, default value)>

Strings

<f_LEN> returns the length of a string expression: <f_LEN(StringExpression)>

<f_SUBSTRING> returns a substring of a string expression: <f_SUBSTRING(stringExpression, beginIndex, length)>

<f_CHARINDEX(substring, string [, start_pos = 0 ])> returns the location of substring in string, or returns -1 if substring is not in string.

Mathematical expressions

<f_MAX> returns the maximum value in a set of numbers: <f_MIN(ArrayExpression)>

<f_MIN> returns the maximum value in a set of numbers: <f_MAX(ArrayExpression)>

Security and encryption

<f_decryptUser> return a decrypted user name. This function can be executed only by users with permission to encrypt and decrypt user names.

<f_encryptUser> returns an encrypted user name. This function can be executed only by users with permission to encrypt and decrypt user names.

<f_userHasRole('Administrator')> is a Boolean function: returns true if the current user has the specified role. Requires a role name.

<f_isUserEncryptionOn> is a Boolean function: returns true if encryption of user names is configured.

Other

<f_ApplicationContainsAnalyzer> is a Boolean function: the application contains the analyzer, true or false?

<f_DAPDimension> returns the current data access dimension or empty string if data access is not enabled.

<f_DAPEnabledForCurrentUser is a Boolean function: the current user is controlled by data access, true or false?

<f_ISNULL> is a Boolean function: the parameter is null, true or false?

<f_REGEXP <f_REGEXP(source, findRegexpExpression, printFormat)> evaluates a regular expression. Example: <f_REGEXP(<Operation>, 'BULK INSERT ([^ ]*) FROM .*', 'Table name: {1}')>

<f_REPLACENULL> returns the first non-null value: <f_REPLACENULL(a,b)> is equivalent to <f_IF(<f_ISNULL(a)>, b, a)> or the Java statement (a != null) ? a : b

<f_applicationPrimarySource> returns the primary source for the application.

<f_checkIPv4FormatOperation> is a Boolean function: returns true if link is IPv4 format.

<f_getMonitoringInterval> returns the monitoring interval (in seconds) for data views used on a report.

<f_getReportTimeRange> returns the report time range length (in seconds).

<f_getReportTimeResolution> returns the report resolution (in seconds).

<f_isAMDHighSpeed> is a Boolean function: returns true if at least one probe is a High Speed probe.

<f_isFarmDefined()> is a Boolean function: returns true if a farm is defined.

<f_isFrontNode()> is a Boolean function: returns true if the local node is a front server in the cluster or stand-alone server.

<f_isHostAvailableOnDynatraceDashboard(IPAddress)> is a Boolean function: returns true if the host identified by IPAddress can be found on the dashboard.

<f_isOnDemandEnabled> is a Boolean function: returns true if on demand mode is enabled.

<f_isSoftwareServiceExportedToPlatform> is a Boolean function: returns true if the given software service can be found on the dashboard. Expects software service name, analyzer and analyzer group as parameters.

<f_isValidIPSqlFilter(<Client IP address>)> is a Boolean function: returns true if the parameter is a valid SQL filter for the IPAddress column. Expects an IP address as a parameter.

<f_userAggrMode> returns the aggregation mode.