how do i update the company field for multiple CI's all in one hit
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-20-2016 02:02 AM
I am having to click and go into each CI and update the company field individually - for over 100 CI's this is tedious and a pain - there must be a way to select all CI's and update the company field all in one go.
any ideas of how to do this?
- Labels:
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-20-2016 03:28 AM
option 1: list edit (like excel), the "control" key (or "shift" key as you prefer) is your best friend : Edit multiple records in a list using the list editor
option 2: do a fix script?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-25-2016 03:31 PM
option 1 is good if all the records you want to edit are in the list. If you want to edit multiple records even ones that aren't currently shown, use option 3: Edit multiple records in a list using an editing form
Update all records in the list |
|
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-20-2016 03:29 AM
Sanjay,
you can writ a fix script and GlideRecord the CI and update the company name ;
Here is a sample of the script, change it as your requirements : I have made a script for a mass update of the country name in location table:
var country = new GlideRecord("cmn_location");
country.addQuery("country","CONTAINS","SHA: Out of the Box");
country.query();
while(country.next()){
country.country = country.u_country.getDisplayValue();
country.update()
}
Not : change the table name and also the addQuery to extract the correct value
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-20-2016 03:30 AM
Hi,
You can use the list edit feature.
Go the left navigation panel and click on the configuration item. It would list all the items.
Apply filter criteria so that you have narrowed down the result.
Next, click on the gear icon and bring the company field in the list.
Next, go to the company part in the first record while holding shift and arrow downm you can select all such records and then click on the first record, while doing so, it will make the field editable and a messgae that the update will impact X number of records. Update with the desired value and click on tick mark.
This feature is called list edit.
Regards,
Avinash