Build Query with Non-CMDB Table-

[Anand D N1]

Did you create a new Configuration Item query using the CMDB Query Builder?
Did you add Incidents from the Non-CMDB Tables tab? Did you connect them to each other? Did you set up filters on each that match the instructions?
Did you save and run the query you created? Did you write the number of records returned into the query's description field?

[Angelo B]

Apologies for being late to the conversation. But where you able to figure out how to link the nodes?

[Madhubala]

1. Navigate to configuration--> CMDB query builder   2. Click on create new

3. Name the query here, type as CMDB Query and click on create.

4. Drag and drop the "Configuration Item" from CMDB Classes to CMDB Query Builder.

5.Click on the filter and apply filter conditions as below

6. Search for Incident Table in Non-CMDB Tables, drag and drop it to the Query Builder. And apply the filter to Incident table as "Priority is Critical"

7. Click on the Configuration Item Query Builder(a node will appear) , click on the node and click on Incident table query builder and click on the node as shown below. A connection will be established between two nodes.

8. Save and Run the Query. Remember to allow pop-ups to get the query results. A new tab will open with the query results. I got results as 6. Enter 6 in the description field in Previous tab and save the query. Validate the task.

 

Thanks.

[Aishwarya Patil]

Hello,

I also had difficulty in finding solution for the

Task 12: Build Query with Non-CMDB Table.

But after a lot of changes I made I got the solution for the same.

Here is the Solution for this query:

Step 1. Navigate to CMDB Query Builder.

Step 2. Create New and Select Query Type as "CMDB Query" and enter the name mentioned in your Task on Now Learning.

Step 3. Select Configuration Item from CMDB Classes as below:

Drag Drop this on the screen next to it.

Step 4. Now Select Incident from the Non - CMDB Classes as below:

Step 5. Now add filter to Configuration Item as below:

Step 6. And apply filter to Incident as below:

Step 7. Make connection in Configuration Item and Incident Class as shown in below Diagram

Step 8. Now Save and Run the Query and Instance will direct you to another Screen where you can view the number of records and you have to check that Number and paste the number in the Description of the Saved Query on the right side of the screen as below:

Your Task will be validated successfully.

Mark Helpful if this helps.

Thank you!!!