Create a Get Records query

Create a Get Records query from the CMDB 360 dashboard in CMDB Workspace or in Service Graph Workspace to help you explore CMDB 360 data.

시작하기 전에

To access CMDB 360 in Service Graph Workspace, you must first switch from CMDB Workspace to Service Graph Workspace. For more information, see Service Graph Workspace store app.

Role required: sn_cmdb_user and either cmdb_ms_admin or cmdb_ms_editor

프로시저

1. Open either workspace:

• Navigate to Workspaces > Service Graph Workspace. Then, in the navigation panel, select the Insights icon and in the Insights page navigation panel, select CMDB 360.
• Navigate to Workspaces > CMDB Workspace, and then in the CMDB Workspace menu bar, select CMDB 360.

2. On the Saved Queries tile, select Create Query.
3. Select I want to get CMDB 360 data.
4. Select the CI classes to include in the query.
   You can select a 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.

   Select All Classes if you want to include all CI classes without conditions.

5. Select Continue.
6. Select discovery sources to query on.
   The query retrieves CMDB 360 data that originates from the discovery sources you specify.

   You can leave the Select discovery sources prompt empty to retrieve data for all discovery sources.

7. Select Continue.
8. On the form, select the options:

   표 1. Results Layout form

   Field	Description
   Show unique CMDB 360 records	Select if you want to see only unique CMDB 360 records. Records for the same CIs from different discovery sources are consolidated.
   Show CI records by discovery source	Select if you want to see records for each CI and discovery source pair.
   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.

9. Select Continue.
10. Enter a name and description for your query.
11. Select Save.

다음에 수행할 작업

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

On the CMDB 360 Query Results page:

• If the number of results exceeds the number of results appearing on the page:
  • Select 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).
  • Select 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).
  • Select a CMDB 360 Source link to easily access preview data of a source and see more details.
• You can select 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 select 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. For example, select a link in the Primary Record column, and then in the CI Details page, select View CMDB 360 Data.