Interested in a ServiceNow event built for developers? Registration for now[dev]26 is officially open!

Task 12: Build Query with Non-CMDB Table.

Aishwarya Patil
Tera Contributor

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:

AishwaryaPatil_0-1702290339104.png

 

 

Drag Drop this on the screen next to it.

 

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

AishwaryaPatil_1-1702290339109.png

 

 

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

AishwaryaPatil_2-1702290339401.png

 

 

Step 6. And apply filter to Incident as below:

AishwaryaPatil_3-1702290339135.png

 

 

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

AishwaryaPatil_4-1702290339128.png

 

 

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:

AishwaryaPatil_5-1702290339136.png

 

 

Your Task will be validated successfully.

Mark Helpful if this helps.

 

Thank you!!!

Aishwarya Patil
Sr.Consultant - ServiceNow
5 REPLIES 5

ShreyaS76670014
Giga Contributor

Hi, so i did the same as explained ->

ShreyaS76670014_0-1790176062171.png

I also added atleast 1 properties as explained by Ky23. But im having an issue while running it.

it saves properly->

ShreyaS76670014_1-1790176089947.png

but loads in a pop up screen like this and then disappears. i dont see any new tab showing results. 😞

ShreyaS76670014_2-1790176100585.png

ShreyaS76670014_3-1790176126599.png

How can i fix this??