Create a CMDB 360 Compare Attribute Values query

Create a Compare Attribute Values query from the CMDB 360 dashboard of your Configuration Management Database (CMDB) Workspace to help you find CIs with mismatched attribute values between discovery sources.

Before you begin

Role required: sn_cmdb_user and either cmdb_ms_admin or cmdb_ms_editor.

About this task

The query enables you to determine if there’s an issue with how a discovery source reports a CI.

The Compare Attribute Values query compares CIs from different discovery sources for mismatched values. Mismatches occur when a discovery source reports attribute values for a CI that are different from values reported by other discovery sources or the CMDB. You can use the query to identify these CIs and reconcile the attribute values, or fix any issues with the discovery sources.

Procedure

1. Navigate to Workspaces > CMDB Workspace.
2. In the CMDB Workspace menu bar, select CMDB 360.
3. Click Create Query.
4. Click I want to compare attribute values between discovery sources or against the CMDB.
5. Select a CI class that you want to compare attribute values for.
   You can click a selected class to open the condition builder. Use the condition builder to specify conditions that must be met for each class. Use And or Or to specify multiple conditions.
6. Click Continue.
7. On the form, select the options:

   Table 1. Attributes to compare form

   Field	Description
   Any attribute doesn't match	Select if you want to retrieve CIs where there's a mismatch with any specified attribute values between the discovery sources.
   Every attribute doesn't match	Select if you want to retrieve CIs where there's a mismatch with every specified attribute value between the discovery sources.
   Select attributes to compare	Specify the attributes that you want to compare for mismatched values.

8. Click Continue.
9. Select your discovery sources that you want to compare attribute values for.

   Table 2. Discovery sources form

   Field	Description
   Compare to CMDB	Select if you want to compare the specified attribute values against your CI attributes recorded in the CMDB. When you compare against the CMDB, you only need one discovery source.
   Select discovery sources	The discovery sources that you want to compare. Select at least two.
   Limit results to	Limits the query results to CIs that belong to a service or CMDB group. When you select Application Services, Technical Services, or CMDB Groups, a prompt appears. You can use the prompt to specify the service or group that you want the query to filter for.

10. Click Continue.
11. Enter a name and description for your query.
12. Click Save .

What to do next

Run the query at least once if you want to create a schedule.

On the CMDB 360 Query Results page:

• If the number of results exceeds the number of results appearing on the page:
  • Click Load More Results​: To show the next page of results. The number of results that appear on each result page is specified by the glide.identification_engine.multisource.query.batch.limit system property (100 items by default).
  • Click Load All Results: To show all results, up to the limit specified by the glide.identification_engine.multisource.query.max.limit system property (10000 by default).
  • Click a CMDB 360 Source link to easily access preview data of a source and see more details.
• You can click Create Schedule to set up a schedule that runs your query on a regular basis. Scheduling your query enables you to use the query results in reports you create.
• After creating a schedule, you can click Create Report to configure a report that you can manage using Reporting capabilities.
• On the Query Results page, access a record to view further details.