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 mquery CLI command.
Enter the following command from a command line:
For example:
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.
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.
<host name>
<host name>
<host name>