Is there a way to bulk attach multiple CIs to the affected CI list on a Change Request?

haydnwisegpc
Kilo Contributor

Is there any easy way to attach a large number of CIs to the affected CI list of a change request?

We have a long list of CIs to attach to a change request and don't want to enter each CI manually from the affected CI list, would prefer an import function if possible but haven't been able to find a solution.

Thanks,

Haydn

1 ACCEPTED SOLUTION

Vimal Priya
Giga Guru

Hi Haydn,



If you re trying   for bulk load once, then you can do it by using import sets against task_ci table by havingChange Request Number and CI details in Excel format.


View solution in original post

7 REPLIES 7

Martin Grosskop
Tera Guru

Hi Haydn,



Not sure how "bulk" you need.



But in case you are not aware of it, as of Geneva release you have two mechanisms available to add quite a lot of CIs very quickly.



Option 1:



On the Change record, go to the Affected CIs tab, then select "Add"



Up will pop a means to select CIs to add to the Change. You have all the power of the filter builder to build whatever query you would like to home in on the CIs you would like to add. e.g. IF you wanted to add all your AIX Servers to the change, you could build a filter such as Class = AIX Server and Active = True.



Then using the buttons in the top right hand corner, you can "Add All" or "Add Selected".



Add CIs from Change.jpeg



Option 2:



Go to the CMDB first. Then build up a query there to home in on the CIs you want to add to a new change/existing change. Then select whether you want to add these to an existing change, or to a new change:



Screen Shot 2016-11-20 at 1.55.18 PM.png



Obviously the above steps can be carried out multiple times if needs be if the range of CIs to be added to the change is quite diverse and cannot be retrieved via one query/filter alone.



Regards


Martin


Thanks Martin


Neel7
Kilo Explorer

Select  "Edit" in "Affected CI " section
In "choose field" select "Name" 

in "Choose operator"select "is one of"

In input value paste the all CIs

click on "Run filter" button

In collection select all using shift + down arrow key and send right.

Hope this will be helpful for you.
Thanks