Specifications

Chapter 7: Search
Using range searches
By using range queries, you can match documents whose field values are
between the lower and upper bound specified by the range query. Range queries
can be inclusive or exclusive of the upper and lower bounds. Sorting is done
lexicographically. For example, the following query finds documents whose mod
date fields have values between 20020101 and 20030101, inclusive:
mod_date:[20020101 TO 20030101]
You can also use range queries with non-date fields. The following query finds all
VMs whose names are in the range between DB01 and DB10, but not including
DB01 and DB10:
VM:{DB01 TO DB10}
Note: Inclusive range queries are denoted by straight brackets. Exclusive range
queries are denoted by curly braces.
Using date searches
SolarWinds Virtualization Manager supports searching for both specific dates and
relative dates.
Specific date searches can be in the following formats:
vm.internal.datecreated:YYYY-MM-DD
vm.internal.datecreated:MM-DD-YYYY
The part separator can be either a dash (-), a slash (/) or a period (.).
Searches using either format or any part separator return the same VMs.
Use the following terms to include dates relative to now:
l YEAR or YEARS
l MONTH or MONTHS
l DAY, DAYS, or DATE
l HOUR or HOURS
l MINUTE or MINUTES
l SECOND or SECONDS
l MILLI, MILLIS, MILLISECOND, or MILLISECONDS
143