Custom Solution: Configure Clone notifications from Source Instance clone Log - Support and Troubleshooting

Custom Solution: Configure Clone notifications from Source Instance clone Log Currently, while a clone is running, you will get specific notifications via NowSupport. Initially, this was only to notify you that the clone started or finished. Later enhancements were made to send more updates providing information about the progress of the clone.

We received feedback that these were too many notifications and not entirely helpful and that you preferred to get only basic notifications. We did, however, hear that you liked the progress updates.

As we had different requests for different levels of logging we decided to make this work for all customers. We have now designed the clone to push all the updates directly to your instance and into the clone_log table. We will still send the basic notifications (start, finish) through NowSupport, but with all the logs on your instance, you can now configure email notifications to send you exactly what you want. This article will provide a few example notifications that you can create in your instance and configure which level of notifications you want.

Here is an example of the logs posted on the source instance these are posted in the clone_log table.

Please note:

The clone field has a sys_id in it but it doesn't show a display value, if you want to fix that you can adjust the dictionary entry:

Table : clone_log Name : clone

The reference table is clone , change to system clone to fix the reference field.

Notifications To create a new email notification:

Navigate to: System Notification > Email > Notifications Select New In the Conditions that trigger a notification, we can filter on two Source s: InstanceCloneScheduler - Request is scheduled CloneEngine - This will provide updates at each step, it will also contain the exclude/preserver list for this clone. Notification 1: Clone has been scheduled Name : Clone scheduled Table : Clone Log [clone_log] Category : Clone (Create if doesn't exist)

When to send :

Send when : Record inserted or updated Inserted : True (checked) Conditions : [Source] [is] InstanceCloneScheduler Who will receive : Here you can define the recipients of the notification. You can add individual users, as well as groups.

What it will contain: (HTML source code)

Subject: ${message} Clone is scheduled for ${clone.scheduled}

Message HTML :

(This is an example that you can copy into the HTML field by using the Source code button ( <> )

Clone Profile: ${clone.profile}

Clone Target instance: ${clone.target_instance}

Clone Requested by: ${clone.sys_created_by}

Options Selected:

Clone Exclude audit and log data: ${clone.exclude_large_data} Clone Exclude large attachment data: ${clone.filter_attachment_data} Clone Exclude tables specified in Exclusion List: ${clone.exclude_all_from_exclusion_list} Clone Preserve In Progress Update Sets: ${clone.preserve_in_progress_update_sets} Clone Preserve theme: ${clone.preserve_theme} Clone Preserve users and related tables: ${clone.preserve_users_and_related_tables} Clone Amount of data copied from large tables: ${clone.amount_of_data_copied_from_large_tables}

Example of the output :

Notification 2: Clone Started Name : Clone started Table : Clone Log [clone_log] Category : Clone (Create if doesn't exist)

When to send:

Send when : Record inserted or updated Inserted : True Conditions : [Message] [is] Starting Clone Preparation Who will receive: This is up to you who you want to receive this notification.

What it will contain: (HTML source code)

Subject : ${clone} Clone over ${clone.target_instance} has started.

Message HTML :

(This is an example that you can copy into the HTML field by using the Source code button ( <> )

Clone Target instance: ${clone.target_instance}

Options Selected:

Clone Exclude audit and log data: ${clone.exclude_large_data} Clone Exclude large attachment data: ${clone.filter_attachment_data} Clone Exclude tables specified in Exclusion List: ${clone.exclude_all_from_exclusion_list} Clone Preserve In Progress Update Sets: ${clone.preserve_in_progress_update_sets} Clone Preserve theme: ${clone.preserve_theme} Clone Preserve users and related tables: ${clone.preserve_users_and_related_tables} Clone Amount of data copied from large tables: ${clone.amount_of_data_copied_from_large_tables}

Example of the output :

Notification 3: Clone Progress Name : Clone progress Table : Clone Log [clone_log] Category : Clone (Create if doesn't exist)

When to send:

Send when: Record inserted or updated Inserted: True Conditions: [Message] [is NOT] Starting Clone Preparation [Source] [is] CloneEngine [Message] [does not contain] Clone completed successfully. [Message] [does not contain] Table List Who will receive: This is up to you who you want to receive this notification.

What it will contain: (HTML source code)

Subject : Clone Progress Update: ${clone} - ${message}

Message HTML :

(This is an example that you can copy into the HTML field by using the Source code button ( <> )

Clone Request: ${clone} Clone Target instance: ${clone.target_instance} Message: ${message}

Example of the output :

Notification 4: Clone Completed Name : Clone Completed Table : Clone Log [clone_log] Category : Clone (Create if doesn't exist)

When to send:

Send when : Record inserted or updated Inserted : True Conditions : [Message] [is NOT] Starting Clone Preparation [Source] [is] [CloneEngine] [Message] [does not contain] Clone completed successfully. Who will receive: This is up to you who you want to receive this notification.

What it will contain: (HTML source code)

Subject : ${clone} - ${message}

Message HTML :

(This is an example that you can copy into the HTML field by using the Source code button ( <> )

Clone Request: ${clone} Clone Target instance: ${clone.target_instance} Message: ${message}

Example of the output :