How might I transfer Service Catalog Item Icons/Images from Dev -> Test?

tombialkowski · ‎11-06-2015

Morning all,

I'm looking for some advice on what the best method would be for transferring Service Catalog Item Icons/Images from Dev -> Test. We are running the Fuji release and have built ~55 items that each have an icon associated with them. The problem we've run into is that the images failed to transfer to Test along with the update sets.

I looked into maybe doing an export/import of the Item records, but the XML file leaves the <icon/> field blank.

To date I've attended the Service Now Administration class and have done quite a bit of additional self-study on the side, but I am still getting my feet wet with a lot of the more advanced learning's and would like to avoid scripting for now if possible. I'd also like to avoid having to manually re-assign all 55 icons once we make the push to Prod later on.

Can anyone point me in the right direction on how best to transfer the icons/images from instance to instance?

Thanks

Tom Bialkowski

Bonnie Cresswe2 · ‎11-16-2015

not sure I can recommend the best way to transfer them, but I can tell you where/how to find them!

They are stored in the sys_attachment table, but there is a Read ACL on that table that prevents you from getting to the record.

There are two Read ACLs on sys_attachment, you will see that one of them (the one with the getSCAttachmentReadAnswer function in the script) does not have "Admin overrides" turned on - if you set that to true you will find the service catalog images (the table name is coming up as ZZ_YYpc_software_cat_item or ZZ_YYsc_category in my instance, depending on whether I am linking it to an item or a category).

View solution in original post

Uncle Rob · ‎11-06-2015

I can't remember clearly, but I think those images are stored in the DB_Image table.

Take a peek in there. If you see them, you can always export that table and import it to the other instances.

tombialkowski · ‎11-06-2015

Thanks. I looked and found a lot of default images in the list on the DB_Image table, but the Icon image I attached to the Service Catalog items is not present

Pradeep Sharma · ‎11-07-2015

Hi Tom,

The below thread should answer your question.

Where are icons for Service Catalog Items stored in SN?

change service catalog icons

Please let me know if you have any questions.

tombialkowski · ‎11-07-2015

Thank you for your reply, but unfortunately those didn't help either. To clarify the problem let me provide an example of my issue. In the Sys Admin course we were given the cloudd.jpg image. If I perform the following steps I am unable to locate the image:

Service Catalog > Maintain Items
Open any Service Catalog Item.
Select [Update] in the Icon section, browse to cloudd.jpg and select OK.
Select Update to save the record and return to the list of catalog items.
Search Content Management > Images or System UI > Images and the icon is not to be found (Visually inspected each as well as sorting by Created/Updated).
Search the db_images table and the icon is not to be found (Visually inspected each as well as sorting by Created/Updated).
Search the sys_attachment table and the icon is not to be found (Searched both by sys_id and by sorting by Created/Updated).
Search the Image Picker and the icon is not to be found.
Tried exporting the Service Catalog record but the xml file contains an empty <icon/>

The icon appears as expected in the Service Catalog, but how to go about locating and transferring the icon(s) from instance to instance continues to elude me...