How to Map CI's form attached excel sheet to Affected Ci tab on change record?

Aryan
Tera Contributor

‎05-17-2024 07:02 AM

Hello All,

 

I just want to know how i can add particular class ci to change request in affected ci tab from the attached excel sheet?
 Suppose i have two column in attached excel sheet CI and Class , How i can fetch attached data to related list tab.

anyone help me on this!!!

0 Helpfuls
  • 325 Views
3 REPLIES 3

Rahul Priyadars
Giga Sage
Giga Sage

‎05-19-2024 09:28 PM

You Can use filter on basis of Name of CI from ur XLS ..then u can add.

 

name  IS ONE OF  <YOUR NAME LIST FROM XLS> Hope Below SS Can be of ur help and i understood ur requirement.

 

RahulPriyadars_0-1716179276935.png

 

 

Regards

RP

0 Helpfuls

Aryan
Tera Contributor
In response to Rahul Priyadars

‎05-20-2024 01:36 AM

is there any automated solution for this?

0 Helpfuls

Rahul Priyadars
Giga Sage
Giga Sage
In response to Aryan

‎05-20-2024 03:19 AM - edited ‎05-20-2024 03:43 AM

what kind of steps you want to be automated let me know accordingly i will respond.

 

Also in above SS once u have CI list ADD ALL Button can add all in one go. 

You can also upload data in task_ci table which satisfies below conditions to come up in  a given CI.

 

RahulPriyadars_0-1716201743104.png

 

Refer ur instance for same for above relationship record which brings the affected CIs in CR or INC etc.

https://YOURINSTANCE/now/nav/ui/classic/params/target/sys_relationship.do%3Fsys_id%3D7f93b48253f3230...

 

Regards

RP

 

Regards

RP

0 Helpfuls