Special details about cloning TEST environment in ServiceNow

Owned by David Backeberg (Unlicensed)
Last updated: Jan 15, 2014
4 min read

TEST lives on the edge, ahead of PRODUCTION, where we test new code that is not yet approved to be advanced.

In a perfect world, TEST would only contain code up to the date of the current release, and would then be refreshed from PROD.

Instead, we have several packages pending for release, so TEST has a large number of deltas away from PROD, and cloning TEST requires substantial work to put things back after being cloned.

How to calculate delta between TEST and PROD

We have a python script written by Bill West that does that. Get the script at:

https://github.com/wwest4/ServiceNow/blob/master/ServiceNow/diff-instance.py

Run the delta script

This returns both the actual update sets, and the order in which they should be applied. Judging by this report, TEST was last refreshed in July 2013, and 188 deltas exist. 

zuse:sn_script db692$ ./diff-instance.py yaletest yale Password: db692-admin https://yaletest.service-now.com Password: db692-admin https://yale.service-now.com https://yaletest.service-now.com//sys_remote_update_set_list.do?sysparm_query=state%3Dcommitted&JSON https://yale.service-now.com//sys_remote_update_set_list.do?sysparm_query=state%3Dcommitted&JSON 2013/06/12 - 2 | 2013-07-02 13:56:02 2013/06/10 - 2 | 2013-07-02 13:56:26 2013/06/18 - 4 | 2013-07-02 13:56:48 2013/06/11 - 1 | 2013-07-02 13:57:01 2013/04/09 - 4 | 2013-07-02 18:51:23 2013/04/01 - 1 | 2013-07-02 18:52:06 2013/04/02 - 1 | 2013-07-02 18:52:34 2013/05/01 - 1 | 2013-07-02 18:53:06 2013/04/24 - 2 | 2013-07-02 18:53:45 2013/05/03 - 2 | 2013-07-02 18:54:23 2013/05/08 - 3 | 2013-07-02 18:55:20 2013/05/28 - 2 | 2013-07-02 18:58:20 2013/05/28 - 3 | 2013-07-02 19:02:30 2013/06/12 - 1 | 2013-07-02 19:02:44 2013/04/18 - 2 | 2013-07-02 19:02:59 2013/04/18 - 3 | 2013-07-02 19:03:14 2013/04/25 - 4 | 2013-07-02 19:04:00 2013/05/16 - 1 | 2013-07-02 19:04:57 2013/06/26 - 9 | 2013-07-02 19:14:34 2013/06/10 - 1 | 2013-07-02 19:15:11 2013/06/28 - 1 | 2013-07-02 19:15:30 2013/06/28 - 3 | 2013-07-02 19:15:49 2013/06/28 - 4 | 2013-07-02 19:16:02 2013/06/28 - 5 | 2013-07-02 19:17:12 2013/07/01 - 4 | 2013-07-02 19:17:35 2013/07/09 - 1 | 2013-07-09 20:34:43 2013/07/09 - 3 | 2013-07-09 20:37:06 2013/07/09 - 4 | 2013-07-09 20:37:39 2013/07/08 - 1 | 2013-07-10 18:00:18 2013/05/13 - 1 | 2013-07-11 04:05:00 2013/04/23 - 2 | 2013-07-11 04:41:18 2013/07/10 - 9 | 2013-07-11 15:16:35 2013/07/01 - 1 | 2013-07-12 13:52:51 2013/07/15 - 1 | 2013-07-15 23:51:54 2013/04/26 - 1 | 2013-07-16 00:07:09 2013/07/10 - 10 | 2013-07-16 00:09:17 2013/07/16 - 3 | 2013-07-16 18:49:57 2013/07/17 - 2 | 2013-07-17 14:28:37 2013/07/10 - 3 | 2013-07-17 17:30:24 2013/07/10 - 4 | 2013-07-17 17:44:08 2013/07/17 - 5 | 2013-07-17 17:52:14 2013/07/10 - 5 | 2013-07-17 18:00:26 2013/07/10 - 6 | 2013-07-18 16:17:42 2013/07/18 - 4 | 2013-07-18 18:54:42 2013/07/01 - 2 | 2013-07-18 19:08:03 2013/07/09 - 2 | 2013-07-18 19:09:48 2013/07/01 - 6 | 2013-07-18 20:54:11 2013/07/02 - 1 | 2013-07-18 21:02:14 2013/07/05 - 1 | 2013-07-18 21:06:39 2013/06/28 - 6 | 2013-07-19 16:28:21 2013/07/19 - 4 | 2013-07-19 19:36:28 2013/07/19 - 5 | 2013-07-19 19:50:16 2013/07/01 - 3 | 2013-07-19 20:11:31 2013/07/24 - 6 | 2013-07-24 19:49:05 2013/07/24 - 7 | 2013-07-25 00:56:14 2013/07/25 - 6 | 2013-07-25 17:19:19 2013/07/31 - 1 | 2013-07-31 15:48:28 2013/07/31 - 3 | 2013-07-31 17:16:19 2013/08/02 - 1 | 2013-08-02 15:42:02 2013/08/02 - 2 | 2013-08-02 15:53:02 2013/08/02 - 3 | 2013-08-05 16:56:38 2013/08/06 - 1 | 2013-08-06 14:41:17 2013/08/06 - 2 | 2013-08-07 15:23:13 2013/08/07 - 1 | 2013-08-07 15:23:43 2013/08/07 - 3 | 2013-08-08 20:54:55 2013/08/09 - 1 | 2013-08-12 20:33:20 2013/08/12 - 2 | 2013-08-12 20:35:13 2013/07/19 - 3 | 2013-08-22 18:50:55 2013/08/26 - 1 | 2013-08-26 15:24:12 2013/08/26 - 2 | 2013-08-27 14:23:31 2013/08/27 - 1 | 2013-08-27 16:42:55 2013/08/29 - 1 | 2013-08-29 18:56:22 2013/09/09 - 1 | 2013-09-09 17:53:39 2013/09/09 - 2 | 2013-09-11 15:42:51 2013/04/30 - 1 | 2013-09-13 18:27:55 2013/07/18 - 1 | 2013-09-13 18:39:10 2013/09/13 - 1 | 2013-09-13 21:38:17 2013/09/17 - 5 | 2013-09-18 03:11:04 2013/09/19 - 4 | 2013-09-19 18:43:54 2013/09/20 - 1 | 2013-09-20 22:13:34 2013/09/20 - 3 | 2013-09-20 22:13:57 2013/09/25 - 2 | 2013-09-25 20:26:17 2013/09/25 - 3 | 2013-09-25 23:34:16 2013/09/25 - 4 | 2013-09-26 03:14:25 2013/09/26 - 4 | 2013-09-26 22:32:22 2013/09/26 - 5 | 2013-09-26 23:17:01 2013/10/01 - 8 | 2013-10-01 22:22:58 2013/08/23 - 1 | 2013-10-08 16:38:02 2013/10/09 - 2 | 2013-10-09 17:37:05 2013/09/26 - 1 | 2013-10-09 20:35:28 2013/10/01 - 2 | 2013-10-10 15:41:10 2013/10/10 - 3 | 2013-10-10 16:05:14 2013/10/10 - 7 | 2013-10-10 22:02:30 2013/10/15 - 1 | 2013-10-15 16:20:36 2013/10/03 - 3 | 2013-10-16 19:13:37 2013/10/07 - 1 | 2013-10-16 20:14:50 2013/10/07 - 2 | 2013-10-16 21:02:44 2013/10/10 - 2 | 2013-10-16 21:06:25 2013/07/28 - 2 | 2013-10-17 16:38:58 2013/09/09 - 4 | 2013-10-17 16:55:14 2013/10/22 - 1 | 2013-10-22 15:02:37 2013/10/23 - 2 | 2013-10-23 19:22:49 2013/10/29 - 8 | 2013-10-30 03:24:41 2013/10/30 - 3 | 2013-10-30 15:26:57 2013/10/30 - 4 | 2013-10-30 15:36:10 2013/11/05 - 1 | 2013-11-05 14:28:06 2013/11/05 - 2 | 2013-11-05 15:17:23 2013/11/05 - 3 | 2013-11-05 15:28:08 2013/11/05 - 4 | 2013-11-05 16:23:49 2013/11/06 - 1 | 2013-11-06 15:18:28 2013/11/06 - 4 | 2013-11-06 15:54:58 2013/11/06 - 9 | 2013-11-07 00:44:56 2013/11/07 - 1 | 2013-11-08 01:14:40 2013/11/08 - 4 | 2013-11-08 21:03:08 2013/11/12 - 4 | 2013-11-12 18:04:35 2013/11/15 - 6 | 2013-11-15 22:35:18 2013/11/15 - 7 | 2013-11-15 22:52:03 2013/11/19 - 1 | 2013-11-20 21:44:20 2013/11/20 - 3 | 2013-11-20 22:54:21 2013/11/15 - 8 | 2013-11-20 23:41:19 2013/08/22 - 4 | 2013-11-22 17:46:13 2013/09/05 - 1 | 2013-11-22 17:59:38 2013/09/11 - 1 | 2013-11-22 18:02:32 2013/09/19 - 1 | 2013-11-22 18:03:54 2013/11/01 - 5 | 2013-11-22 18:08:09 2013/11/08 - 2 | 2013-11-22 18:10:45 2013/11/08 - 3 | 2013-11-22 18:11:56 2013/11/12 - 3 | 2013-11-22 18:14:51 2013/11/12 - 5 | 2013-11-22 18:16:20 2013/11/14 - 2 | 2013-11-22 18:17:08 2013/11/19 - 2 | 2013-11-22 18:17:57 2013/11/26 - 2 | 2013-11-26 17:41:15 2013/12/02 - 1 | 2013-12-02 17:44:18 2013/11/26 - 1 | 2013-12-03 17:55:16 2013/12/03 - 3 | 2013-12-03 17:57:07 2013/12/03 - 4 | 2013-12-03 19:23:47 2013/12/02 - 2 | 2013-12-03 21:44:12 2013/12/03 - 2 | 2013-12-03 21:45:00 2013/12/03 - 5 | 2013-12-03 21:46:04 2013/12/03 - 6 | 2013-12-03 21:50:25 2013/12/04 - 1 | 2013-12-06 17:04:10 2013/12/04 - 2 | 2013-12-06 17:06:05 2013/12/04 - 3 | 2013-12-06 17:07:01 2013/12/06 - 3 | 2013-12-06 20:27:17 2013/12/06 - 4 | 2013-12-06 20:51:31 2013/12/06 - 5 | 2013-12-06 20:52:06 2013/12/06 - 6 | 2013-12-06 21:38:33 2013/12/06 - 7 | 2013-12-06 22:00:12 2013/12/09 - 1 | 2013-12-09 21:44:47 2013/12/09 - 2 | 2013-12-09 22:32:35 2013/12/09 - 3 | 2013-12-09 22:49:09 2013/07/31 - 7 | 2013-12-10 00:08:13 2013/12/09 - 4 | 2013-12-10 00:21:17 2013/12/09 - 5 | 2013-12-10 00:35:00 2013/12/09 - 6 | 2013-12-10 00:52:22 2013/12/10 - 1 | 2013-12-10 15:38:33 2013/12/10 - 2 | 2013-12-10 15:50:04 2013/12/10 - 4 | 2013-12-10 16:19:27 2013/12/10 - 8 | 2013-12-10 21:50:35 2013/12/11 - 1 | 2013-12-11 05:38:43 2013/12/11 - 2 | 2013-12-11 06:44:46 2013/12/11 - 5 | 2013-12-12 18:40:42 2013/10/04 - 1 | 2013-12-12 22:06:49 2013/12/12 - 1 | 2013-12-16 18:36:50 2013/12/16 - 1 | 2013-12-16 18:37:45 2013/12/17 - 1 | 2013-12-17 15:38:38 2013/12/17 - 3 | 2013-12-17 18:44:58 2013/12/18 - 1 | 2013-12-18 19:21:43 2013/12/18 - 3 | 2013-12-18 19:39:23 2013/12/19 - 1 | 2013-12-19 20:30:47 2013/12/19 - 2 | 2013-12-19 22:30:55 2013/12/13 - 3 | 2013-12-19 22:46:17 2013/12/19 - 3 | 2013-12-20 03:02:13 2013/12/20 - 2 | 2013-12-20 19:52:31 2013/12/17 - 2 | 2013-12-20 21:52:30 2013/12/20 - 3 | 2013-12-20 22:20:12 2014/01/02 - 1 | 2014-01-02 22:29:35 2014/01/03 - 1 | 2014-01-03 22:05:50 2013/12/31 - 1 | 2014-01-06 18:18:51 2014/01/06 - 1 | 2014-01-06 21:36:36 2013/12/30 - 1 | 2014-01-08 19:04:21 2014/01/07 - 1 | 2014-01-08 19:14:04

 

That list in a nice format:

  1. 2013/06/12 - 2 | 2013-07-02 13:56:02
    2013/06/10 - 2 | 2013-07-02 13:56:26
    2013/06/18 - 4 | 2013-07-02 13:56:48
    2013/06/11 - 1 | 2013-07-02 13:57:01
    2013/04/09 - 4 | 2013-07-02 18:51:23
    2013/04/01 - 1 | 2013-07-02 18:52:06
    2013/04/02 - 1 | 2013-07-02 18:52:34
    2013/05/01 - 1 | 2013-07-02 18:53:06
    2013/04/24 - 2 | 2013-07-02 18:53:45
    2013/05/03 - 2 | 2013-07-02 18:54:23
    2013/05/08 - 3 | 2013-07-02 18:55:20
    2013/05/28 - 2 | 2013-07-02 18:58:20
    2013/05/28 - 3 | 2013-07-02 19:02:30
    2013/06/12 - 1 | 2013-07-02 19:02:44
    2013/04/18 - 2 | 2013-07-02 19:02:59
    2013/04/18 - 3 | 2013-07-02 19:03:14
    2013/04/25 - 4 | 2013-07-02 19:04:00
    2013/05/16 - 1 | 2013-07-02 19:04:57
    2013/06/26 - 9 | 2013-07-02 19:14:34
    2013/06/10 - 1 | 2013-07-02 19:15:11
    2013/06/28 - 1 | 2013-07-02 19:15:30
    2013/06/28 - 3 | 2013-07-02 19:15:49
    2013/06/28 - 4 | 2013-07-02 19:16:02
    2013/06/28 - 5 | 2013-07-02 19:17:12
    2013/07/01 - 4 | 2013-07-02 19:17:35
    2013/07/09 - 1 | 2013-07-09 20:34:43
    2013/07/09 - 3 | 2013-07-09 20:37:06
    2013/07/09 - 4 | 2013-07-09 20:37:39
    2013/07/08 - 1 | 2013-07-10 18:00:18
    2013/05/13 - 1 | 2013-07-11 04:05:00
    2013/04/23 - 2 | 2013-07-11 04:41:18
    2013/07/10 - 9 | 2013-07-11 15:16:35
    2013/07/01 - 1 | 2013-07-12 13:52:51
    2013/07/15 - 1 | 2013-07-15 23:51:54
    2013/04/26 - 1 | 2013-07-16 00:07:09
    2013/07/10 - 10 | 2013-07-16 00:09:17
    2013/07/16 - 3 | 2013-07-16 18:49:57
    2013/07/17 - 2 | 2013-07-17 14:28:37
    2013/07/10 - 3 | 2013-07-17 17:30:24
    2013/07/10 - 4 | 2013-07-17 17:44:08
    2013/07/17 - 5 | 2013-07-17 17:52:14
    2013/07/10 - 5 | 2013-07-17 18:00:26
    2013/07/10 - 6 | 2013-07-18 16:17:42
    2013/07/18 - 4 | 2013-07-18 18:54:42
    2013/07/01 - 2 | 2013-07-18 19:08:03
    2013/07/09 - 2 | 2013-07-18 19:09:48
    2013/07/01 - 6 | 2013-07-18 20:54:11
    2013/07/02 - 1 | 2013-07-18 21:02:14
    2013/07/05 - 1 | 2013-07-18 21:06:39
    2013/06/28 - 6 | 2013-07-19 16:28:21
    2013/07/19 - 4 | 2013-07-19 19:36:28
    2013/07/19 - 5 | 2013-07-19 19:50:16
    2013/07/01 - 3 | 2013-07-19 20:11:31
    2013/07/24 - 6 | 2013-07-24 19:49:05
    2013/07/24 - 7 | 2013-07-25 00:56:14
    2013/07/25 - 6 | 2013-07-25 17:19:19
    2013/07/31 - 1 | 2013-07-31 15:48:28
    2013/07/31 - 3 | 2013-07-31 17:16:19
    2013/08/02 - 1 | 2013-08-02 15:42:02
    2013/08/02 - 2 | 2013-08-02 15:53:02
    2013/08/02 - 3 | 2013-08-05 16:56:38
    2013/08/06 - 1 | 2013-08-06 14:41:17
    2013/08/06 - 2 | 2013-08-07 15:23:13
    2013/08/07 - 1 | 2013-08-07 15:23:43
    2013/08/07 - 3 | 2013-08-08 20:54:55
    2013/08/09 - 1 | 2013-08-12 20:33:20
    2013/08/12 - 2 | 2013-08-12 20:35:13
    2013/07/19 - 3 | 2013-08-22 18:50:55
    2013/08/26 - 1 | 2013-08-26 15:24:12
    2013/08/26 - 2 | 2013-08-27 14:23:31
    2013/08/27 - 1 | 2013-08-27 16:42:55
    2013/08/29 - 1 | 2013-08-29 18:56:22
    2013/09/09 - 1 | 2013-09-09 17:53:39
    2013/09/09 - 2 | 2013-09-11 15:42:51
    2013/04/30 - 1 | 2013-09-13 18:27:55
    2013/07/18 - 1 | 2013-09-13 18:39:10
    2013/09/13 - 1 | 2013-09-13 21:38:17
    2013/09/17 - 5 | 2013-09-18 03:11:04
    2013/09/19 - 4 | 2013-09-19 18:43:54
    2013/09/20 - 1 | 2013-09-20 22:13:34
    2013/09/20 - 3 | 2013-09-20 22:13:57
    2013/09/25 - 2 | 2013-09-25 20:26:17
    2013/09/25 - 3 | 2013-09-25 23:34:16
    2013/09/25 - 4 | 2013-09-26 03:14:25
    2013/09/26 - 4 | 2013-09-26 22:32:22
    2013/09/26 - 5 | 2013-09-26 23:17:01
    2013/10/01 - 8 | 2013-10-01 22:22:58
    2013/08/23 - 1 | 2013-10-08 16:38:02
    2013/10/09 - 2 | 2013-10-09 17:37:05
    2013/09/26 - 1 | 2013-10-09 20:35:28
    2013/10/01 - 2 | 2013-10-10 15:41:10
    2013/10/10 - 3 | 2013-10-10 16:05:14
    2013/10/10 - 7 | 2013-10-10 22:02:30
    2013/10/15 - 1 | 2013-10-15 16:20:36
    2013/10/03 - 3 | 2013-10-16 19:13:37
    2013/10/07 - 1 | 2013-10-16 20:14:50
    2013/10/07 - 2 | 2013-10-16 21:02:44
    2013/10/10 - 2 | 2013-10-16 21:06:25
    2013/07/28 - 2 | 2013-10-17 16:38:58
    2013/09/09 - 4 | 2013-10-17 16:55:14
    2013/10/22 - 1 | 2013-10-22 15:02:37
    2013/10/23 - 2 | 2013-10-23 19:22:49
    2013/10/29 - 8 | 2013-10-30 03:24:41
    2013/10/30 - 3 | 2013-10-30 15:26:57
    2013/10/30 - 4 | 2013-10-30 15:36:10
    2013/11/05 - 1 | 2013-11-05 14:28:06
    2013/11/05 - 2 | 2013-11-05 15:17:23
    2013/11/05 - 3 | 2013-11-05 15:28:08
    2013/11/05 - 4 | 2013-11-05 16:23:49
    2013/11/06 - 1 | 2013-11-06 15:18:28
    2013/11/06 - 4 | 2013-11-06 15:54:58
    2013/11/06 - 9 | 2013-11-07 00:44:56
    2013/11/07 - 1 | 2013-11-08 01:14:40
    2013/11/08 - 4 | 2013-11-08 21:03:08
    2013/11/12 - 4 | 2013-11-12 18:04:35
    2013/11/15 - 6 | 2013-11-15 22:35:18
    2013/11/15 - 7 | 2013-11-15 22:52:03
    2013/11/19 - 1 | 2013-11-20 21:44:20
    2013/11/20 - 3 | 2013-11-20 22:54:21
    2013/11/15 - 8 | 2013-11-20 23:41:19
    2013/08/22 - 4 | 2013-11-22 17:46:13
    2013/09/05 - 1 | 2013-11-22 17:59:38
    2013/09/11 - 1 | 2013-11-22 18:02:32
    2013/09/19 - 1 | 2013-11-22 18:03:54
    2013/11/01 - 5 | 2013-11-22 18:08:09
    2013/11/08 - 2 | 2013-11-22 18:10:45
    2013/11/08 - 3 | 2013-11-22 18:11:56
    2013/11/12 - 3 | 2013-11-22 18:14:51
    2013/11/12 - 5 | 2013-11-22 18:16:20
    2013/11/14 - 2 | 2013-11-22 18:17:08
    2013/11/19 - 2 | 2013-11-22 18:17:57
    2013/11/26 - 2 | 2013-11-26 17:41:15
    2013/12/02 - 1 | 2013-12-02 17:44:18
    2013/11/26 - 1 | 2013-12-03 17:55:16
    2013/12/03 - 3 | 2013-12-03 17:57:07
    2013/12/03 - 4 | 2013-12-03 19:23:47
    2013/12/02 - 2 | 2013-12-03 21:44:12
    2013/12/03 - 2 | 2013-12-03 21:45:00
    2013/12/03 - 5 | 2013-12-03 21:46:04
    2013/12/03 - 6 | 2013-12-03 21:50:25
    2013/12/04 - 1 | 2013-12-06 17:04:10
    2013/12/04 - 2 | 2013-12-06 17:06:05
    2013/12/04 - 3 | 2013-12-06 17:07:01
    2013/12/06 - 3 | 2013-12-06 20:27:17
    2013/12/06 - 4 | 2013-12-06 20:51:31
    2013/12/06 - 5 | 2013-12-06 20:52:06
    2013/12/06 - 6 | 2013-12-06 21:38:33
    2013/12/06 - 7 | 2013-12-06 22:00:12
    2013/12/09 - 1 | 2013-12-09 21:44:47
    2013/12/09 - 2 | 2013-12-09 22:32:35
    2013/12/09 - 3 | 2013-12-09 22:49:09
    2013/07/31 - 7 | 2013-12-10 00:08:13
    2013/12/09 - 4 | 2013-12-10 00:21:17
    2013/12/09 - 5 | 2013-12-10 00:35:00
    2013/12/09 - 6 | 2013-12-10 00:52:22
    2013/12/10 - 1 | 2013-12-10 15:38:33
    2013/12/10 - 2 | 2013-12-10 15:50:04
    2013/12/10 - 4 | 2013-12-10 16:19:27
    2013/12/10 - 8 | 2013-12-10 21:50:35
    2013/12/11 - 1 | 2013-12-11 05:38:43
    2013/12/11 - 2 | 2013-12-11 06:44:46
    2013/12/11 - 5 | 2013-12-12 18:40:42
    2013/10/04 - 1 | 2013-12-12 22:06:49
    2013/12/12 - 1 | 2013-12-16 18:36:50
    2013/12/16 - 1 | 2013-12-16 18:37:45
    2013/12/17 - 1 | 2013-12-17 15:38:38
    2013/12/17 - 3 | 2013-12-17 18:44:58
    2013/12/18 - 1 | 2013-12-18 19:21:43
    2013/12/18 - 3 | 2013-12-18 19:39:23
    2013/12/19 - 1 | 2013-12-19 20:30:47
    2013/12/19 - 2 | 2013-12-19 22:30:55
    2013/12/13 - 3 | 2013-12-19 22:46:17
    2013/12/19 - 3 | 2013-12-20 03:02:13
    2013/12/20 - 2 | 2013-12-20 19:52:31
    2013/12/17 - 2 | 2013-12-20 21:52:30
    2013/12/20 - 3 | 2013-12-20 22:20:12
    2014/01/02 - 1 | 2014-01-02 22:29:35
    2014/01/03 - 1 | 2014-01-03 22:05:50
    2013/12/31 - 1 | 2014-01-06 18:18:51
    2014/01/06 - 1 | 2014-01-06 21:36:36
    2013/12/30 - 1 | 2014-01-08 19:04:21
    2014/01/07 - 1 | 2014-01-08 19:14:04
    2014/01/09 - 1 | 2014-01-13 16:08:48