Advanced Search Feature

Many Device42 list pages contain an Advanced Search option to help you quickly and easily find the items you want; the example below shows the Managed Resources list page.

Click Advanced Search to display its Query bar. (Click Basic Filtering to return to the default list page.)

Advanced search lets you enter search criteria based on the columns on the Resource list page. The basic search syntax is:

• <column name> <operator> <search value>

The following operators are supported:

• =
• != (not equal)
• in
• not in
• contains (string only – partial match)
• <   (date only)
• <= (date only)
• >   (date only)
• >= (date only)
• interval (date only – uses an offset value rather than explicit date or time with >= or <=)
• EMPTY (can be used with any column only with = or != to filter on empty or non-empty columns)
  • hardware = EMPTY or hardware_id = EMPTY or vm_creation_date != EMPTY

The value formats for date searches are:

• “yyyy/mm/dd hh:mm” – (for hh:mm values use 24 hour clock)
• “yyyy-mm-dd hh:mm”
• “yyyy/mm/dd”
• “yyyy-mm-dd”

When you first click in the Advanced Search Query bar, Device42 displays a list of the column names you can use to create your search. Click or enter a column name to begin building your search.

An example query for resources that contain the name Brenda is shown below. Enclose the search value you enter in double quotes. Note that for the contains, in, and not in operators, the search values must also be enclosed by parentheses.

• resource_name contains (“Brenda”)

When using the in and not in operators, you can enter multiple search values within parentheses separated by commas:

• resource_name in (“BrendaDevice42”, “WH-NETAPP-01”)

An example date search  is shown below.

• last-edited = “2021-03-16”

Interval is a special operator you can use to filter date columns using a specified offset rather than an explicit date (this works only with the <= or >= operators). The search values for an interval operation are “<number> <time unit>”.

• first_added >= interval “-5 days”

This example creates a filter that returns records whose first_added date is greater than or equal to a time offset of 5 days in the past.

• The <number> can be positive or negative, where positive numbers are forward in time and negative numbers are backward in time.
• The <time unit> can be years, months, weeks, days, minutes, or seconds. If you do not supply a <time unit>, the default is seconds.

You can use and / or connectors to combine searches:

• resource_name contains (“Brenda”) and resource_name contains (“D42”) or resource_name contains (“vol-069”)

As you enter your search, Device42 prompts you if the search syntax is incorrect.

To copy an executed advanced search, copy the URL in your browser address bar and paste the URL into a new browser tab or window. You can also bookmark the page containing the executed search.