Query modification for CMDB relationships report in Asset Explorer
I'm hoping someone could help me modify the below query to add the following columns to the results:
CI-Type1 (for ci-name 1)
CI-Type2(for ci- name 2)
Business Impact
Existing query is below
select c1.ciname as "CI Name",rel.relationship as "Relationship", c2.ciname as "CI Name 2" from ci c1 inner join cirelationships cirel on c1.ciid=cirel.ciid inner join relationshiptype rel on cirel.relationshiptypeid=rel.relationshiptypeid inner join ci c2 on cirel.ciid2=c2.ciid where rel.relationship like '%used by%'
Thank you so much for your assistance!