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

[tombialkowski]

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 · Accepted solution]

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).

[tombialkowski]

Thanks! I was able to locate the images with your answer, however I ended up setting the images manually about a week ago.

Why these wouldn't be transferred between instances, or exportable in some way, is beyond me as well. But at least now I have a starting point:)

Thanks again Bonnie!

[rev3]

Hi Bonnie,

I was able to locate the images in the sys_attachment table. But they are not visible when i imported them to another instance. It looks like a broken image.

Thank You

Rey

[ajitchandragiri]

try clearing your instance cache and browser cache. it worked for me.

[Edxavier Robert]

Just go to the sc_cat_item table and export the catalog item as xml, then re-imported in your next instance.