How to auto-populate Configuration Items based on the Business service selected in the Incident Form

[Samrat7]

Hi all,

I would like to have my Configuration Items in my incident form show only those CI that are related to the Business service selected via CI Relationships or in other words show only those CI's as references that are the Child of the selected Business service in the CI Relationships table.

I know this has to be achieved using Reference Qualifier and a script include. But I don't know what should be the script and the advanced reference qualifier as I'm newbie.

Any help will be appreciated.

[AshishKM · Accepted solution]

Hi Samrat ,

It looks , primarily you completely  understand using the ref fields and relationship table ( Business Service & CI ).

We can create a custom table , having Business Service & CI's and write a onChange script on Business Service field and make a GlideAjax call to a script include for matched CI name for selected Business Service.

 Here , we can achieve this by using 'Reference Qual' field on cmdb_ci column in Incident table.

Created a new reference  field Business Service in cmdb_ci  table for relationship. Declare few CI with Business service name.

Add Refrence Qaul value in column "cmdb_ci" in incident table. 

current.business_service is the selected business service on incident form

u_business_service is the column in cmdb_ci table which is reference of cmdb_ci_service table.

 

Result :

Hope that it will help you to decide your case. Please click Helpful if it helps.

[karan15]

hi can I please get more steps on how to achieve this ?

[Samrat7]

Thanks it works.

[AshishKM]

!! Great !!