This documentation supports the 20.02 version of Remedy Asset Management.To view an earlier version, select the version from the Product version menu.

Using the BMC Atrium CMDB query dialog box to search for  CIs

Use the BMC Atrium CMDB query dialog box to build complex searches. You can specify multiple classes and attributes, and group search conditions. For example, you can search for all computer systems in Houston or London that are running Microsoft Windows XP.

(Version 20.02 or earlier of BMC CMDB)

Important

You must have Adobe Flash Player installed to view the BMC Atrium CMDB search console.

For more information about the supported Flash Player versions, see Adobe Flash Player requirement.

 

When you use the BMC Atrium CMDB query dialog box, you interact directly with BMC Atrium CMDB. Note the following elements:

  • CI class — CI types in BMC Asset Management correspond to CI classes.
  • Attribute — Fields on the BMC Asset Management CI forms correspond to attributes. Most attributes are the same or similar to the field names on BMC Asset Management CI forms. Some attributes do not appear as fields on BMC Asset Management CI forms, because they are not relevant to asset management.

To use the BMC Atrium CMDB query dialog box to search for CIs with BMC CMDB version 20.02.01 or later

To use the BMC Atrium CMDB query dialog box to search for CIs with BMC CMDB version 20.02.01 or later, you must first go to Asset Management console and select Functions > Advanced CI Search and then perform the following steps in the CMDB Dashboard:

  1. In the CMDB Dashboard UI, select New Query from the list of search queries. 
    CreateQuery1.png
    The New Query window is displayed.
  2. Drag and drop classes into the right pane.
    NewQuery1.png
  3. Add relationships between those classes in accordance with the query qualifications. 
    To add a relationship, click the triangular icon below the source class. 
    Move your mouse and extend the arrow from the source class to the destination class, and click the destination class.
    ConnectTwoClasses.png
    The Select relationship between classes dialog box is displayed.
    Cardinality1_1.png
  4. Select the relation type between the source and destination classes. 
    Only valid relationship types are available for selection in the list.
  5. Specify the cardinality information:
    By default, the Required check box is selected. 
    In this example, the query returns results only if a computer system has an application running on it.
    1. (Optional) Select the Minimum value. 
      By default, the minimum value is 1. 
      You can change it to any other value.
    2. (Optional) Select the Maximum value.
      The default value is '*' (unrestricted). 
      Select the Specify Value check box and specify a maximum value. 
      For example, if you specify the minimum value as 2 and maximum value as 4, the query returns computer systems that have at least two applications and up to four applications running on them.
      For more information on Cardinality, see Cardinality.
    3. (Optional) To set the impact direction for the relationship, turn on the Set Impact toggle key and select an impact direction.
    4. Save the details.
  6. (Optional) You can include additional qualifications for a class by clicking Edit Class Qualification QualificationIcon.png. 
    In this example, for a computer system class, you must include a qualification that assigns a Payroll value to the Department attribute. 
    EditQualificationUI.png

    The Qualification Builder opens.
    QualificationBuilder1.png

    Use the qualification builder to add a qualification. 
    For more information, see Qualification-Builder-overview. 
  7. Repeat steps 2 to 10 to add the remaining classes and create relationships. In this example, you must add the Patch class.
    The complete query is shown in the following figure.
    NewQuery2.png
  8. When you finish creating the query, test your query by clicking Validate and search.
    Validate and search is enabled only after you create a relationship between at least two classes. 
    If the search results do not provide any results, you can change the dataset on which you are searching.
    ChangeDataset.png
  9. Specify a category under which you want to save the query, a name and a description for the query.
  10. (Optional)To save the query as a personal query, turn on the Is Personal  toggle key.
    By default, the query is saved as a shared query.
    QueryResults.png
  11. To save the changes, click Save query.

To use the BMC Atrium CMDB query dialog box to search for CIs with BMC CMDB version 20.02 or earlier

  1. In the navigation pane of the Asset Management console, choose Functions> Advanced CI Search.
  2. In the BMC Atrium CMDB query dialog box, click the New icon.
  3. In the Query dialog box, click the Query Criteria tab.
  4. Double-click a CI class to search, such as BMC_ComputerSystem.
  5. In the list of search conditions, use the drop-down menus to create one or more search conditions for that class:
    1. Optionally, select the check box and type a label for the condition.
       If you save this search, whenever you run the search, you are prompted with this label. You might choose to use the attribute name, or you might choose a more descriptive label. For example, if you are building a query for a computer system in a location, you might create labels of Server Name and Location for the two name attributes.
    2. Select an attribute.
    3. Select an operator.
    4. Enter a value.
    5. If you want to add another search condition, select AND or OR.
    6. Use the search condition buttons to arrange and group conditions.
  6. To include a relationship between CI classes:
    1. In the list of chosen classes and relationships, click the drop-down arrow for a CI class and select a relationship class.
    2. From the list of unselected CI classes, select the related CI class.
    3. In the list of search conditions, use the drop-down menus to create one or more search conditions for the new class.
       For example, you might query for all computer systems with Microsoft XP by building a query that includes the BMC_ComputerSystem CI class, the BMC_HostedSystemComponents relationship class, and the BMC_OperatingSystem CI class.
  7. Repeat steps 5 and 6 until you have added all the classes and conditions necessary for the search.
  8. To run the search, and to make sure that the search returns expected values, click Preview.
  9. To view the results in the display pane, click Copy and Close.

Related topic

(Version 20.02.01 or later of BMC CMDB) Creating a graph query to search for a CI

(Version 20.02 or earlier of BMC CMDB) Configuring query options in BMC Atrium Explorer


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*