I know i am late responding to this post but just in case anyone else is still looking for moving images associated with Hardware Catalog items(or any catalog item) with an update set then it can be done using the script below.
Essentially the steps are:
- Query the sysId of the catalog items for which you want images captured in an update set
- Search sys_attachment table with the sysId of catalog item. Note that images associated with catalog items are stored in sys_attachments and sys_attachment_doc table
- Save the attachment record in update set.
//Query for the CMDB Model record
var grModel = new GlideRecord('pc_hardware_cat_item');
grModel.addEncodedQuery('active=true^sys_class_name=pc_hardware_cat_item');
grModel.query();
while (grModel.next()) {
//gs.log(grModel.sys_id);
queryAttachments(grModel);
}
function queryAttachments(modelGR) {
//Query for the record
var rec = new GlideRecord('sys_attachment');
rec.addQuery('table_sys_id', modelGR.sys_id);
rec.query();
while (rec.next()) {
gs.log(rec.sys_id);
addAttachmentToUpdateSet(rec);
}
}
function addAttachmentToUpdateSet(attachmentGR) {
var um = new GlideUpdateManager2();
um.saveRecord(attachmentGR);
var attdoc = new GlideRecord('sys_attachment_doc');
attdoc.addQuery('sys_attachment', attachmentGR.sys_id);
attdoc.orderBy('position');
attdoc.query();
while(attdoc.next()){
um.saveRecord(attdoc);
}
}
Once you move the update set from source instance to destination instance, dont forget to clear server cache and your browser cache before retesting.
Please mark this helpful/correct if you find the information useful.
