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.

Database view where condition

SakshiSharma
Tera Contributor

Hi,

 

I am trying to connect cmdb_rel_ci table with two tables cmdb_ci_database and cmdb_ci_service_discovered.

The child field of cmdb_rel_ci has both records; that I am getting from cmdb_ci_database.sys_id = cmdb_rel_ci_child and

records from  cmdb_ci_service_discovered_name. Could someone help me how to get these records separately.

SakshiSharma_0-1716300505375.png

 

0 REPLIES 0