AnsweredAssumed Answered

CI Relationships directly from SQL DB

Question asked by izznoland on Oct 25, 2016
Latest reply on Oct 26, 2016 by pier-olivier.tremblay

I need to find CIs with a relationship to the output of the following:

select resource_name from ca_owned_resource where resource name like '%someCI_name%'

I'm pulling this information from a custom field in the chg table, with the desired end result to have the ability to automatically attach CIs to a CO based on this custom field, which has the application name as the desired CI name, and any dependent CIs.

 

I appreciate the help in advance.

 

Cheers!

-Izz

Outcomes