show associated servers information for the solution selected

Bindhu1
Tera Contributor

Hi Team, kindly assist here.
I am trying to fetch associated server's name in information box for the solution selected , kindly help me with the code.
I have 2 questions on cat item:

Bindhu1_0-1713936821894.png

Bindhu1_1-1713936821897.png

Q1. referring to Solution table[cmdb_ci_service]

Q2. referring to Server table [cmdb_ci_server]
Based on the solution select in Q1 , New variable xyz(single line text) should give associated server's name
-----------------------------------------------------------------------------------------------------
Tried with below approach but not required anymore:
Since there is no direct relationship btw servers and solution ,I had given reference table of Q2 to cmdb_ci_rel , with  advance ref qualifier as below:

Bindhu1_2-1713936821898.png

 

output:

Bindhu1_3-1713936821901.png

Bindhu1_4-1713936821900.png

 

 

Thanks in advance

0 REPLIES 0