How can I move Compliance Certification Templates with Conditions, between instances?

Emmat
Tera Contributor

Hello

I have several Compliance Certification Templates all with Certification Attribute Conditions. When i try to move everything via update set, the Certification Template is moved but the conditions aren't included. I have tried export / Import from the [cert_template] table, but the conditions still aren't moved over? Am I missing something really obvious?

Thanks 

 

EDIT: Finally found my solution so thought I would update incase anyone else finds it useful. While the Certification Templates are stored in the [cert_template] the Certification Attribute Conditions are stored in a separate table [cert_attr_cond]. I had to find all of the conditions relevant for my templates and add them to the update set too.

7 REPLIES 7

Tony Chatfield1
Kilo Patron

Hi, these tables, cert_filter, cert_attr_cond, cert_related_list_cond, 

do not appear to have attribute 'update_synch' (at least not in the instance I checked) and so would not be included in update-set.

Customizations tracked by update sets (servicenow.com)

Meaning it looks like you would need to include the related records\data manually and

I would export the records from these tables to xml and import them after you have deployed your template.

Hi Tony,

 

Thanks for your reply. I have tried exporting the records from the cert_template table and importing into the higher instance but I still only get an empty template with no Certification Attribute Conditions.

Hi, I have just tested this by creating a cert in a non-prod instance and then exporting the cert and related records to xml before importing to a PDI and did not have any issues.
How exactly did you export\import your data?

Hi Tony,
I'd already tried moving everything over in an update set, so the blank templates where already in the higher instance. I went to the cert_template table in DEV, found one of my templates and exported to xml. I then imported it in to the same table in the higher instance, but the Certification Attribute Conditions still weren't showing.