CMDB Query question

drslry2 · ‎12-21-2023

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

Dr Atul G- LNG · ‎12-21-2023

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 · ‎12-21-2023

Hi @drslry2 ,

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

example

-Thanks,

AshishKMishra

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