Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

CMDB Query question

drslry2
Tera Contributor

‎12-21-2023 07:49 AM

Hi CMDB Query Gurus,

I have a query against the cmdb ci table that correctly returns 41 records for a specific location.  Is it possible to add the  Business Application class to the query and retain the 41 records in the result set while also retrieving a Business Application should one exist?  If a Business Application doesn't exist simply return a null value.  Similar to an outer join in a relational database.  Please let me know if you think this is possible.

Thanks,

Rob

query.PNG

 

0 Helpfuls
  • 441 Views
2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

‎12-21-2023 09:54 AM

Hi @drslry2 

 

Please add your question here:

 

https://www.servicenow.com/community/cmdb-forum/bd-p/configuration-management-db-forum

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

AshishKM
Kilo Patron
Kilo Patron

‎12-21-2023 10:16 AM - edited ‎12-21-2023 10:17 AM

Hi @drslry2 , 

You can add the OR condition with location, it will get result based on both condition.

example

AshishKMishra_0-1703182537777.png

 

-Thanks,

AshishKMishra


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution