Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The feature 'Browse objects' allows searching for CMDB resources that meet the specific criteria. Select the resource in CMDB Navigator. Use Enable Visual Mode to search for objects using the list view builder UI.

Starting a new search you have two sections to work with: 1) Filter Criteria and 2) Columns to Display.

Image Removed

Table of Contents

1. Setting Up Filters

Click ''+Add filter''

Table of Contents

Start

Select the resource type (e.g. AWS EC2 Instances) in CMDB Navigator:

...

Click Browse Objects on the left. Select Visual Mode.

...

Set Up Filter Criteria


Click +ADD FILTER to add a new filter criteria. A filter

...

A filter criteria consists of a field name, a logical operator and a value. You  You can select a field name from the drop-down list or type the name in the search bar:Image Removed

...

Note

Some Some fields have a list of related fields to drill down into (use > to select a related field):

Image Removed  => Image Removed

...

Image Added

Image Added

Click 'home' sign to go back to the general list of fields.

Based on the objects relationship, you can filter your search results by fields of a parent object:Image Removed

...

Example: Here we refer to AWS Account which is This example refers to the object type AWS EC2 Instances. We select AWS Account, a master object for AWS EC2 Instance, and retrieve its related field 'Account Name'. Setting We can narrow the search scope by setting up a certain specific value or criteria, we can narrow the search scope, i.e. AWS accounts containing e.g., AWS accounts containing 'test' in their names will be excluded.   Having added the field' State Name' along with the operator ‘equals’ 'equals' and the value set up as value 'running', we managed the search to display ,' we only search for all running instances only.


Field Type

Select By default, the type 'Standard' to see the list of all fields, except JSON fields.

Image Removed

Select is selected to display standard Cloudaware objects and their fields. To view the JSON data fields, select 'JSON field' type to filter the fields containing JSON data, pick the one under question and click “Apply’’. You can also use

...

Use JSONPath expressions in the box ‘Field 'Field JSON Path’ to focus Path' to fine-tune your search.

Image Removed  => Image Removed

Select one field (ex.1) or several ones (ex.2) for the search to refer to. JSON data will be parsed and shown in several columns below.

Image Removed

Example 1: Here we refer to the JSON field 'Tags JSON' and its related field 'Name', so that their values are displayed in separate columns in the list.

Image Removed

...

:

...

Anchor
JSONPath
JSONPath

Note

JSONPath expressions start with $ and can contain the dot- (a) or the bracket-notation (b) for input paths:

a) $.Fieldname[0].Fieldname

b) $["fieldname"]["fieldname"][0]["fieldname"] - where [0] is the number of an element in the array.


The element number can be replaced by the wildcard symbol * to refer to all elements: $[“Fieldname with whitespaces”][*]


Logical Operators

for

equals

Use for

Use for an exact match

not equal 

Use 

Use for an exact

match with

match with a certain value excluded

greater than

Use when you want results that exceed the value you enter

greater or equal

Use for results that match or exceed the value you enter

less than

Use for results that are less than the value you enter

less or equal

Use for results that match or are less than the value you entered

contains

Use for fields that include your search string

not contains

Use to eliminate records that don’t contain the value you enter

like

Use to locate records that include the exact value you enter or type % to include a

certain part

certain part of the value entered,

e.g. `Account`.`Account Name`

like test 

like test will search for all account names containing test

not like

Use to locate records that exclude the exact value you enter or type

% to

% to exclude a

certain part

certain part of the value entered,  

e.g. `Instance Name or ID`

not like %environ% 

not like %environ% will search for all instance names and IDs, except the ones containing -environ-

starts with

Use for results that start with a certain value

Grouping Filters

You can combine several conditions within one Click +ADD FILTERS GROUP to create a group of filters. Click AND to select

Select the condition operator (AND AND (all of conditions are true) or OR (any of conditions are true):Image Removed

...

Click the ''Move to group'' button Create group with this condition to create a new group of filters and move based on a selected filter into it. Such a grouping allows you to add a new condition as well.

Image Removed

Image Removed

Click the '':

...

Click Extract from group'' button to exclude a filter from the group of filters under question, reverting ''Move to group'' action:Image Removed

...


Using groups of filters and condition operators AND/OR, you can set up complex conditions in "the section 'Filter Criteria" section':Image Removed

...

Note

Pay attention to the check box

...

Invert group: if checked, it inputs a negation to the meaning of all filters in the group.

Image RemovedImage Added

Example: In this This example we initiate demonstrates a search for all instances that are present in AWS and running, but we also want to exclude the instances containing ‘test’ and ‘dev’ test’ and ‘devin their names. Instead of looking for appropriate operators with a negative value for each filter criteriacriterion, we simply group the required filters and apply negation to the whole filter group.

...

Set Up Available Columns


You can manage the columns which will be displayed in the list. Click "+Add column" to add columns. Click the 'label' icon Add more columns to be displayed in the list of results. Type the field name in a search bar, drill down into master object folder and select a field from the list on the left.

...

Click Add label to change a column name if necessaryin the list of results :Image Removed

Image Added

Image Removed

...

Image Added


Click Add order to set up the the sorting order for assets in a column: ASC for ascending or DESC for descending.Image Removed

...

Sorting Order Of Columns


Hover over triple dots on the left and two strips to drag a column up or down to manage the order of columns in the list of results:

...

To initiate search, click SEARCH. The list of results will be available in the lower part of the canvas screen:Image Removed

...

The following options are available under OPTIONS:

  • Save as New List View

  • Copy Link to This Query

  • Show Equivalent SOQL

  • Show Equivalent CURL