...
...
...
The feature Browse objects allows searching for CMDB resources that meet the specific criteria. Enable Visual Mode to search for objects using the list view builder UI.
| Table of Contents |
|---|
Start
Select the resource type in CMDB Navigator to open a list view (e.g. AWS AccountsEC2 Instances) in CMDB Navigator:
...
Click Browse Objects on the left. Select Visual Mode.
...
| Note |
|---|
Some fields have a list of related fields to drill down into (use > to select a related field): |
 |
|
Click 'home' sign to go back to the general list of fields.
...
Example: 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'. We can narrow the search scope by setting up a specific value or criteria, e.g., AWS accounts containing 'test' in their names will be excluded. Having added the field' State Name' along with the operator 'equals' and the value 'running,' we only search for all running instances.
Field Type
Select By default, the type 'Standard' to see the list of all fields, except JSON fields.
...
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 JSON Path' to focus fine-tune your search.:
...
...
| Anchor |
|---|
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.
...
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.
...
Example 2: This example refers to the JSON field 'Policy Document JSON.' We evaluate all related fields available and then pull fields 'Statement' and 'Effect' to the list to see their values.
|
| 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.
|
Logical Operators
equals | Use for an exact match |
not equal | Use for an exact 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 of the value entered, e.g. |
| |
not like | Use to locate records that exclude the exact value you enter or type % to exclude a certain part of the value entered, e.g. |
| |
starts with | Use for results that start with a certain value |
Grouping Filters
Click +ADD FILTERS GROUP to create a group of filters.
...
| Note |
|---|
Pay attention to the check box Invert group: if checked, it inputs a negation to the meaning of all filters in the group. |
Example: This example demonstrates a search for all instances present in AWS and running, but we also want to exclude the instances containing ‘test’ and ‘dev’ in their names. Instead of looking for appropriate operators with a negative value for each filter criterion, we group the required filters and apply negation to the whole filter group.
...
Click Add label to change a column name in the list of results :
 |  |
Click Add order to set up the the sorting order for assets in a column: ASC for ascending or DESC for descending.
...
Hover over two strips to drag a column up or down to manage the order of columns in the list of results:
...
Search
To initiate search, click SEARCH. The list of results :
...
will be available in the lower part of the canvas screen:
...
The following options are available under OPTIONS:
Save as New List View
Copy Link to This Query
Show Equivalent SOQL
Show Equivalent CURL