Finding CIs that are present in Infrastructure Management but not in BMC Atrium CMDB

If you are using third-party software with BMC Atrium CMDB for discovery and data collection capabilities, the newly-discovered and modified devices are displayed in Infrastructure Management as CIs.
For example, if you are using BMC PATROL discovery and data collection capabilities with Atrium CMDB, BMC PATROL KMs discover new and modified devices and display them in Infrastructure Management as CIs. These CIs might or might not exist in Atrium CMDB. If the CIs do not exist in Atrium CMDB, BMC, it is recommended that you add them to Atrium CMDB. For information about adding CIs to Atrium CMDB, see the BMC Atrium CMDB User's Guide.

To find CIs that exist in Infrastructure Management, but not in Atrium CMDB, use the Find CI drawer or the mquery CLI command.

Finding CIs using the Find CI drawer

1. In the operator console, click the Find CI drawer and select the Advanced tab.

2. Select Name and Class from the Query list. The CI Query Editor dialog box is displayed.

3. Enter values in the CI Query Editor dialog box as shown in the figure below.
   

   You can narrow your search to a particular class of CI by selecting the class type from the Class list. For example, if you select Base Element > System > Computer System from the Class list, only CIs of the Computer System type are displayed.

4. You can save the query by clicking Save As and entering a name for the query in the Enter Query Name dialog box. Saving a query allows you to access the query at any time by using the Advanced tab.

5. Click Find. 

   
   The Find CI drawer displays a list of CIs that are not present in BMC Atrium CMDB.
   

Finding CIs using the mquery CLI command

Enter the following command from a command line:

mquery CellName -d -a ClassName -w SearchCriteria -s AttributesToPrint -f FileFormat

For example:

mquery -n pncell_vw-pun-ngp-dv0087 -d -a BMC_ComputerSystem -w "DatasetId: != BMC.ASSET" -s "Name" -f CSV

The values of the FileFormat parameter can be CSV, or BAROC, or XML.

The following is the output of the mquery command. It displays CIs that are not present in BMC Atrium CMDB. For example, if you selected to find CIs that belong to the Computer System type, only CIs of the Computer System type that are not present in BMC Atrium CMDB are displayed.

C:\Program Files\BMC Software\ProactiveNet\pw\server\bin>mquery -n pncell_punemachine -d -a BMC_ComputerSystem -w "DatasetId: != BMC.ASSET" -s "Name" -f CSV

BMC Impact Query v.r.mm (Build 231108765 - day-month-year)[ag10:w4]

Copyright 1998-year BMC Software, Inc. as an unpublished work. All rights reserved.

pune-machine.bmc.com

pune-ldom-rds112

MNAGIRI-LT-02

pune-ldom-rds115

Finding CIs using the mquery CLI command

Enter the following command from a command line:

mquery -n <Cell Name> -d -a <Class Name> -w <Search_Criteria> -s <Attributes to print> -f <File Format>

For example, mquery -n pncell_vw-pun-ngp-dv0087 -d -a BMC_ComputerSystem -w "DatasetId: != BMC.ASSET" -s "Name" -f CSV
The values of the <File Format> parameter can be CSV, or BAROC, or XML. 

The following is the output of the mquery command. It displays CIs that are not present in BMC Atrium CMDB. For example, if you selected to find CIs that belong to the Computer System type, only CIs of the Computer System type that are not present in BMC Atrium CMDB are displayed.

C:\Program Files\BMC Software\ProactiveNet\pw\server\bin>mquery -n pncell_punemachine -d -a BMC_ComputerSystem -w "DatasetId: != BMC.ASSET" -s "Name" -f CSV
BMC Impact Query v.r.mm (Build 231108765 - day-month-year) [ag10:w4]
Copyright 1998-year BMC Software, Inc. as an unpublished work. All rights reserved.
pune-machine.bmc.com
pune-ldom-rds112
MNAGIRI-LT-02
pune-ldom-rds115