Qualification Builder overview

You can create your own qualifications to build queries using the Qualification Builder.

These queries use a relational-algebra format based on Structured Query Language (SQL). For example, to search for all computer systems that either belong to HR or Finance departments in the NY site, the query would look like the following:

('Department' = "Finance" OR 'Department' = "HR") AND 'Site' = "NY"

Search operators, keywords, and wildcards

You need various operators, keywords, and wildcards to build a search query. The following information helps you understand the usage of operators, keywords, and wildcards.

Operators

The operators match specified attributes to specific values.

Keywords

Keywords return or represent defined values.

Keyword	Action
USER	The current user login. A "user" can refer to either a human user or an internal (system) user. An internal user can be an escalation "user" (AR_ESCALATOR user), a DSO action (Distributed Server user), or an application binary (such as Remedy Application Service user).
DATE	For date or time fields, this keyword evaluates to the current date, and the time is set to midnight by default. Anything stored in a date or time field is stored as the number of seconds since UNIX time, which includes the date and time. UNIX time (also known as POSIX time or UNIX Epoch time) is a system for describing a point in time, defined as the number of seconds that have elapsed since 00:00:00 Coordinated Universal Time (UTC), Thursday, 1 January 1970. Note: When using $DATE$ in a search on a Date or Time field, you can add or subtract date/time by using a value that is based on seconds. For example: dateTimeField> $DATE$ - 86400 (86400 is the number of seconds in 24 hours.) For Date fields, this keyword evaluates to the current date. For Time fields, this keyword evaluates to 12:00:00 AM. Note: The $DATE$ keyword is not expanded when default values are set. This allows the value to be set to the date the form is submitted rather than the date the form is opened.
TODAY	Today's date in UNIX time.
NULL	A null value (no value). BMC CMDB treats a NULL value as follows: • Character, Diary, Timestamp, Selection — An empty string • Integer, Real, Decimal — A value of 0

Operator precedence

When you use multiple operators to create qualification criteria, they are evaluated in the following order:

( )
NOT (!) - (unary minus; an operator that takes only one operand; for example, -2.5)
/ % *
+ -
< <= > >= !- LIKE
AND
OR

Operators of the same precedence are performed left to right.

You can use parentheses in an expression to override operator precedence. BMC Helix CMDB evaluates expressions inside the parentheses first before evaluating those outside the parantheses.

Resources

More about Unix Epoch TimeConvert to Epoch time