June ??, 2014 release, the crawl release

~~R926 - Request: New Service Request for IAM - Attribute Release Form 2013/07/28 - 2, 2013/09/09 - 4, 2013/10/30 - 3, 2014/04/02 - 3~~
~~D956, R926 - IAM Attribute Release form: Assignment group is blank. It should be IS Identity and Access Management: 2014/02/18 - 1~~
~~D958, R926 - IAM Attribute form: Student Details Text box retains values or does not cleared out although the Students check box is unchecked: 2014/02/20 - 1~~
~~D1020, R926 - IAM Attribute form: Connection group checkboxes missing from SCTASK: 2014/04/11 - 2~~
~~D1021, R926 - IAM Attribute form: End date can be before start date, also both dates can be in past: 2014/04/14 - 1~~

update sets (8)

~~2013/07/28 - 2~~
~~2013/09/09 - 4~~
~~2013/10/30 - 3~~
~~2014/04/02 - 3~~
~~2014/02/18 - 1~~
2014/02/20 - 1
2014/04/11 - 2
~~2014/04/14 - 1~~

June ??, 2014 (May 21, 2014 tentatively, this is the never-launched 2014-04-24 release with R780, R812, R1147 removed)

R785 - Firewall change request. New service catalog item: 2013/05/28 - 2, 2013/08/23 - 1, 2013/11/19 - 1
R788 - FRU0016924 - Request: New Catalog Item "Subversion Repository Request and S: 2013/04/23 - 2, 2013/07/10 - 9, 2013/09/26 - 4, 2013/12/10 - 4, 2013/12/10 - 8
R789: Load balancer form: 2013/04/26 - 1, 2013/07/10 - 10, 2013/07/24 - 7, 2013/09/26 - 5, 2014/04/07 - 1
R926 - Request: New Service Request for IAM - Attribute Release Form 2013/07/28 - 2, 2013/09/09 - 4, 2013/10/30 - 3, 2014/04/02 - 3
R966 - Request: RITM0052615 - New Service Request for Metrics and Quality Assurance: 2013/09/17 - 5, 2013/11/05 - 1, 2013/11/05 - 2, 2013/11/05 - 3
R1034 - New Service Request for Add/Change EliApps Email Addr: 2013/09/25 - 3, 2014/04/07 - 2
R1035 - Request: New Service Request for IAM ADFS Federation Request F: 2013/09/25 - 4, 2013/10/10 - 7
R1091 - Request: Modify existing Micro-Tier Form to offer Windows: 2013/11/06 - 9, 2014/02/05 - 2, 2014/02/10 - 1 ( redeploy)
R1179 - "Propose a new Service Request" workflow change: 2014/03/17 - 1
R1180 - "Publish a ServiceNow Report or Template" workflow change: 2014/03/17 - 2
R1181 - "ServiceNow Accounts and Groups" workflow change: 2014/03/18 - 1
R1193 - Knowledge: Two new gauges for displaying data: 2014/02/05 - 7
R1199 - Monitoring: New UI Page for polling recent user data imports: 2014/02/14 - 1, 2014/05/27 - 1
D571,R789 : 2013/07/31 - 7
D572,R789: see D571
D704: - Revise 'My Work' gauge to suppress closed tasks: 2014/01/27 - 2
D772, R789 - Request a Load Balancing Service form does not have Environments in the drop down populated: on update set with D779
D776, R789 - Comments / Help Text as per the requirement are missing: on update set with D779
D777, R789: 2013/12/09 - 5
D778, R789: 2013/12/09 - 4
D779. R789 - Load balancing field is designated as a mandatory field when its not required to be one: 2013/12/09 - 6
D781, R789 - Boolean options / check boxes captions not specified in the requirement: no update set found
D815, R966 Metrics Quality form - Date before 11/11 using Browsers IE & Firefox causes the page to hang or freeze: 2014/03/06 - 2
D847, R1091 - FRU0016922 - SCTASK Variables Order display not consistent with RITM / other SCTASK forms: 2013/12/10 - 5
D848, R785: Changing 'Requested for' can leave values in fields if Requested_for is changed to a different user without those values populated: 2014/03/11 - 1
D849, R785: Reduce delivery time for the request: 2014/03/11 - 2
D850, R785 - Firewall form: Links in questions should link to other sites: 2014/02/10 - 3
D851, R785 - Firewall form: Form morphing should be different: 2014/02/10 - 4
D852, R785 - Firewall form: Form morphing should be different, round two: 2014/02/10 - 5
D856, R782 - Yale Meetingplace form: Missing Assignment group, name and department field values: 2014/02/11 - 4
D891, R966 - QA Request: Drop down entry missing value: 2014/02/11 - 5
D892, R789 - Port number fields accept alphanumeric text and do not validate correctly: 2013/12/19 - 2
D896 - PMO FORM: Assignment going to wrong group: no update set found
D907, R792 - FAS HPC Account Creation Service Request: Quantity drop down is not required. Quantity Drop down is present: 2014/02/04 - 2
D919, R1035: 2014/01/17 - 4
D940,R788 - Assignment group is not populated for any of the Subversion requests: 2014/02/04 - 1
D943, R1091 - PTAEO validator is not working as expected and also user needs to click twice to add the item to cart: 2014/02/03 - 1, 2014/02/04 - 3
D944,R1091 - Shopping cart functionality broken: no update sets found
D948, R812 - Blank Contact PO Box field and readonly does not allow user to submit the request: 2014/03/04 - 1
D949, R788 - Subversion request: Requester email address does not match the corresponding requester selected from the people picker list: 2014/02/10 - 2
D956, R926 - IAM Attribute Release form: Assignment group is blank. It should be IS Identity and Access Management: 2014/02/18 - 1
D958, R926 - IAM Attribute form: Student Details Text box retains values or does not cleared out although the Students check box is unchecked: 2014/02/20 - 1
D959 - this was a PREPROD regression; nothing to advance, no actual update sets
D960 - this was a PREPROD regression; nothing to advance, no actual update sets
D961, D962, R664 - Template publishing form: Remove the approval process from the request: 2014/02/20 - 2
D962 - see D961
D963, R789 - Load Balancer form: Fields which are invisibile at the time of creating the request retain old values and are visible on RITM and SCTASK screens: 2014/03/05 - 1
D964, R789 - Load balance form: Testing date after projected use date is accepted by the system: 2014/03/05 - 2
D965, R966 Metrics form - Assignment group is not assigned: 2014/02/25 - 1
D968, R1034 Workflow for EliApps mail alias form broken when approval granted: 2014/02/28 - 1, 2014/04/02 - 1, 2014/04/02 - 5
D985 - Notifications: Remove approval process on ElipApps form: 2014/03/12 - 5
D988 - Load Balance request form: redux of date issues; need to revalidate opposing date field when fixing invalid date: 2014/03/14 - 1
D989, R789 - Load Balancer Form: Testing Date and Projected Use Date should be mandatory: 2014/03/20 - 1
D990, R789 - Load Balancer Form: issues that are complications of D989; probably a duplicate of D989.
D991, R789 - Load Balancer Form: issues that are complications of D989; probably a duplicate of D989.
D992: Prevent users from changing their date and time prefs, and reverse any that have been changed: 2014/03/25 - 1
D995, R785 - Firewall form: Title does not match spec: 2014/03/21 - 1, 2014/03/24 - 2
D996, R785 - Firewall form: Caption for firewall does not match spec: 2014/03/21 - 2
D998, D785 - Firewall form: Caption for 'purpose of change' does not match spec: 2014/03/24 - 3,
D999 - nothing to advance.
D1000 - Certain Incident views shouldn't be different: 2014/03/24 - 1
D1003, R785 - Firewall form: Morphing the form leave values behind: 2014/03/24 - 4
D1004, R785 - Firewall form: Requested for doesn't work properly: 2014/03/25 - 3
D1005 - fixed elsewhere; nothing to advance.
D1009, R812 - Audioconference form: Need phone validation onSubmit: 2014/04/08 - 1
D1015, R1034 - Eli apps: Need slight validation on aliases request: 2014/04/09 - 1
D1016, R1034 - Eli apps: Spec deviation regarding workflow. Need to change the SPEC to match the way it was delivered, because we changed the SPEC during UAT: This was not tagged, but was fixed on an R1034 update set.
D1020, R926 - IAM Attribute form: Connection group checkboxes missing from SCTASK: 2014/04/11 - 2
D1021, R926 - IAM Attribute form: End date can be before start date, also both dates can be in past: 2014/04/14 - 1
D1026, R1091: Microtier form: When Windows, the assignment group is wrong. 2014/04/21 - 1
D1027, R1035 - IAM ADFS Federation: When SCTASK is Closed Complete, RITM shows as Open 2014/04/21 - 2
D1031, R812: Audio Conference form, PO Box displays incorrect user value 2014/05/12 - 1
D1034, R785: Firewall change form workflow. RITM is not properly setting Item State to Closed. 2014/04/23 - 1
D1036, R788: Subversion Repository Creation request. Need to properly close RITM and REQ. 2014/05/23 - 2
D1037, R789: Load balancing request. Need to properly close REQ by setting Item State closed. 2014/05/23 - 3
D1038, R926: IAM Attribute release form. Need to properly close REQ by setting Item State closed. 2014/05/23 - 4
D1039, R966: Metrics and Quality Assurance form. Need to properly close REQ by setting Item State closed. 2014/05/23 - 5
D1041, R788: Subversion Repository Add/Remove User Request. Workflow needs to set RITM 'Item State' to Closed and "State" to Closed Complete. 2014/05/28 - 1
D1043, R788: Subversion Repository Creation Request. Workflow needs to set RITM 'Item State' to Closed and "State" to Closed Complete. 2014/05/28 - 2
D1044, R788: Subversion Support Request. Workflow needs to set RITM 'Item State' to Closed and "State" to Closed Complete. 2014/05/28 - 3
D1048, R1201: Notifications: Request Item Complete: Should send on any Approval code except Rejected. 2014/05/28 - 4
D1051, R907: HPC Request: Request not closing properly. 2014/06/12 - 1
D1052: Desktop Support Request: Request not closing properly. 2014/06/12 - 2
D1053: Webmaster Support Request: State is not in a Closed complete status although the SCTASK is closed. 2014/06/12 - 3
D1054: Wordpress Feature Request: State is not set to Close Complete on the Request Form. 2014/06/12 - 4

update sets:

2013/04/23 - 2
2013/04/26 - 1
2013/05/28 - 2
2013/07/10 - 9
2013/07/10 - 10
2013/07/24 - 7
2013/07/28 - 2
2013/07/31 - 7
2013/08/23 - 1
2013/09/09 - 4
2013/09/17 - 5
2013/09/25 - 3
2013/09/25 - 4
2013/09/26 - 4
2013/09/26 - 5
2013/10/10 - 7
2013/10/30 - 3
2013/11/05 - 1
2013/11/05 - 2
2013/11/05 - 3
2013/11/06 - 9
2013/11/19 - 1
2013/12/09 - 4
2013/12/09 - 5
2013/12/09 - 6
2013/12/10 - 4
2013/12/10 - 5
2013/12/10 - 8
2013/12/19 - 2
2014/01/17 - 4
2014/01/27 - 2
2014/02/03 - 1
2014/02/04 - 1
2014/02/04 - 2
2014/02/04 - 3
2014/02/05 - 2
2014/02/05 - 6
2014/02/05 - 7
2014/02/10 - 1 ( redeploy)
2014/02/10 - 2
2014/02/10 - 3
2014/02/10 - 4
2014/02/10 - 5
2014/02/11 - 4
2014/02/11 - 5
2014/02/14 - 1

2014/02/18 - 1
2014/02/20 - 1
2014/02/20 - 2
2014/02/25 - 1

2014/02/28 - 1
2014/03/04 - 1
2014/03/05 - 1
2014/03/05 - 2

2014/03/06 - 2
2014/03/11 - 1
2014/03/11 - 2
2014/03/12 - 5
2014/03/14 - 1
2014/03/17 - 1
2014/03/17 - 2
2014/03/18 - 1
2014/03/20 - 1
2014/03/21 - 1
2014/03/21 - 2
2014/03/24 - 1
2014/03/24 - 2
2014/03/24 - 3
2014/03/24 - 4
2014/03/25 - 1
2014/03/25 - 3
2014/04/02 - 1
2014/04/02 - 3
2014/04/02 - 5
2014/04/07 - 1
2014/04/07 - 2
2014/04/08 - 1
2014/04/09 - 1

2014/04/11 - 2
2014/04/14 - 1
2014/04/21 - 1

2014/04/21 - 2

2014/04/23 - 1

2014/05/12 - 1

2014/05/23 - 2

2014/05/23 - 3

2014/05/23 - 4

2014/05/23 - 5

2014/05/27 - 1

2014/05/28 - 1

2014/05/28 - 2

2014/05/28 - 3

2014/05/28 - 4

2014/06/12 - 1

2014/06/12 - 2

2014/06/12 - 3

2014/06/12 - 4

Manual deploy:

D992, there is a manual deploy; run the background script and enable (uncomment) the payload.

var user_count = 0; 
var user = new GlideRecord('sys_user'); 
user.addQuery('date_format', '!=', ''); 
user.query(); 

while (user.next()) { 
user_count ++; 
gs.print('User: ' + user.name + ', Format: ' + user.date_format); 
//user.date_format = ''; 
//user.update(); 
} 
gs.print('Total Users Modified: ' + user_count);

result:

0:00:00.272] Script completed: scriptTime: 0:00:00.258 id: yalepreproduction_1[glide.17] for: SELECT sys_user0.`sys_id` FROM sys_user sys_user0  WHERE sys_user0.`date_format` IS NOT NULL 
*** Script: User: Stuart Teal, Format: MM-dd-yyyy
*** Script: User: Daniel O'Connell, Format: MM-dd-yyyy
*** Script: User: Daniel Tinari, Format: dd/MM/yyyy
*** Script: User: William Welch, Format: MM-dd-yyyy
*** Script: User: Samuel Chevalier, Format: MM-dd-yyyy
*** Script: User: Timothy Lee, Format: MM-dd-yyyy
*** Script: User: Len Peters, Format: MM-dd-yyyy
*** Script: User: Jason Ignatius, Format: MM-dd-yyyy
*** Script: User: Robert Haig, Format: MM-dd-yyyy
*** Script: User: Daniel Yang, Format: MM-dd-yyyy
*** Script: User: Stephanie Scungio, Format: dd/MM/yyyy
*** Script: User: Charlie Queiroga, Format: MM-dd-yyyy
*** Script: User: Lynnette Averill, Format: MM-dd-yyyy
*** Script: User: Neal Greene, Format: dd/MM/yyyy
*** Script: User: Astrit Mulla, Format: MM-dd-yyyy
*** Script: User: Wen-tao Cheng, Format: yyyy-MM-dd
*** Script: User: Nathaniel Harrington, Format: dd.MM.yyyy
*** Script: User: Chris Kilbourne, Format: dd/MM/yyyy
*** Script: User: David Logie, Format: MM-dd-yyyy
*** Script: User: Jacklyn Trickett-Sargent, Format: MM-dd-yyyy
*** Script: User: Lucy Kapur, Format: MM-dd-yyyy
*** Script: User: Jill Short, Format: MM-dd-yyyy
*** Script: User: Michael Paquette, Format: MM-dd-yyyy
*** Script: User: Michael Macary, Format: MM-dd-yyyy
*** Script: User: Mahesh Velagapudi, Format: MM-dd-yyyy
*** Script: User: Jeffrey Goddu, Format: MM-dd-yyyy
*** Script: User: Glenn Hasiotis, Format: MM-dd-yyyy
*** Script: User: Steven Fielding, Format: MM-dd-yyyy
*** Script: User: Ali Makhzangi, Format: MM-dd-yyyy
*** Script: User: Michael Rath, Format: MM-dd-yyyy
*** Script: User: Theresa D'Arcangelo, Format: dd-MM-yyyy
*** Script: User: Eric Lieberman, Format: MM-dd-yyyy
*** Script: User: Paul Johnson, Format: MM-dd-yyyy
*** Script: User: Cynthia Welsh, Format: yyyy-MM-dd
*** Script: Total Users Modified: 34

Apr 24, 2014 (originally, then release cancelled. Release reduced, and scheduled for May 14, 2014, now cancelled again; building a new listing because so much has changed)

Making D1000 go; it's ready for UAT, and we are the UAT.

R780 - FRU0016963 - Request: SDR Request maintenance 2013/04/01 - 1, 2013/07/01 - 8, 2013/12/13 - 1, 2014/04/02 - 2, 2014/04/02 - 4 (pulled from May 14, 2014 release due to not receiving second round of UAT, week of May 9, 2014)
R785 - Firewall change request. New service catalog item: 2013/05/28 - 2, 2013/08/23 - 1, 2013/11/19 - 1
R788 - FRU0016924 - Request: New Catalog Item "Subversion Repository Request and S: 2013/04/23 - 2, 2013/07/10 - 9, 2013/09/26 - 4, 2013/12/10 - 4, 2013/12/10 - 8
R789: Load balancer form: 2013/04/26 - 1, 2013/07/10 - 10, 2013/07/24 - 7, 2013/09/26 - 5, 2014/04/07 - 1
R812 - New Service Request: Request for New Audio Conference Service Account: 2013/04/30 - 1, 2013/11/05 - 4, 2013/12/11 - 4, 2014/04/02 - 6 (pulled from May 14, 2014 release due to D1031)
R926 - Request: New Service Request for IAM - Attribute Release Form 2013/07/28 - 2, 2013/09/09 - 4, 2013/10/30 - 3, 2014/04/02 - 3
R966 - Request: RITM0052615 - New Service Request for Metrics and Quality Assurance: 2013/09/17 - 5, 2013/11/05 - 1, 2013/11/05 - 2, 2013/11/05 - 3
R1034 - New Service Request for Add/Change EliApps Email Addr: 2013/09/25 - 3, 2014/04/07 - 2
R1035 - Request: New Service Request for IAM ADFS Federation Request F: 2013/09/25 - 4, 2013/10/10 - 7
R1091 - Request: Modify existing Micro-Tier Form to offer Windows: 2013/11/06 - 9, 2014/02/05 - 2, 2014/02/10 - 1 ( redeploy)
R1147 - Rebroadcasting comments on RITM to SCTASK(s) (trivially, this should solve the email case as well, please test), 2013/10/29 - 1 (pulled from May 14, 2014 release as 'too high risk')
R1179 - "Propose a new Service Request" workflow change: 2014/03/17 - 1
R1180 - "Publish a ServiceNow Report or Template" workflow change: 2014/03/17 - 2
R1181 - "ServiceNow Accounts and Groups" workflow change: 2014/03/18 - 1
R1193 - Knowledge: Two new gauges for displaying data: 2014/02/05 - 7
R1199 - Monitoring: New UI Page for polling recent user data imports: 2014/02/14 - 1
D571,R789 : 2013/07/31 - 7
D572,R789: see D571
D704: - Revise 'My Work' gauge to suppress closed tasks: 2014/01/27 - 2
D772, R789 - Request a Load Balancing Service form does not have Environments in the drop down populated: on update set with D779
D776, R789 - Comments / Help Text as per the requirement are missing: on update set with D779
D777, R789: 2013/12/09 - 5
D778, R789: 2013/12/09 - 4
D779. R789 - Load balancing field is designated as a mandatory field when its not required to be one: 2013/12/09 - 6
D780, R789 - Load Balancing request: Sorry Page URL label text / Caption not as per the requirement specification: 2014/02/04 - 6
D781, R789 - Boolean options / check boxes captions not specified in the requirement: no update set found
D815, R966 Metrics Quality form - Date before 11/11 using Browsers IE & Firefox causes the page to hang or freeze: 2014/03/06 - 2
D818, R812 - Quantiity field not required for the Audio Conference Service Account: 2013/11/12 - 4
D827, D828, R780 SDR form: 2013/12/10 - 2
D836, R812 - Audio Conference Request: Phone validation required. (think I fixed this on one of the 2014/02/05 update sets.): no update set found
D837, R812 - FRU0016923 - Request cannot be placed when Contact email address Or Contact Phone numbers are not available: no update set found
D847, R1091 - FRU0016922 - SCTASK Variables Order display not consistent with RITM / other SCTASK forms: 2013/12/10 - 5
D848, R785: Changing 'Requested for' can leave values in fields if Requested_for is changed to a different user without those values populated: 2014/03/11 - 1
D849, R785: Reduce delivery time for the request: 2014/03/11 - 2
D850, R785 - Firewall form: Links in questions should link to other sites: 2014/02/10 - 3
D851, R785 - Firewall form: Form morphing should be different: 2014/02/10 - 4
D852, R785 - Firewall form: Form morphing should be different, round two: 2014/02/10 - 5
D856, R782 - Yale Meetingplace form: Missing Assignment group, name and department field values: 2014/02/11 - 4
D888, R812 - Audio Conference request: Client Phone number field is not editable when its prepopulated with a Phone number based off their profile: 2014/02/05 - 8
D889, R812 - Audio Conference request: Billing contact Phone number and PO Box is editable when there is not one for Billing contact: 2014/02/05 - 6, 2014/03/25 - 2
D891, R966 - QA Request: Drop down entry missing value: 2014/02/11 - 5
D892, R789 - Port number fields accept alphanumeric text and do not validate correctly: 2013/12/19 - 2
D896 - PMO FORM: Assignment going to wrong group: no update set found
D907, R792 - FAS HPC Account Creation Service Request: Quantity drop down is not required. Quantity Drop down is present: 2014/02/04 - 2
D919, R1035: 2014/01/17 - 4
D940,R788 - Assignment group is not populated for any of the Subversion requests: 2014/02/04 - 1
D943, R1091 - PTAEO validator is not working as expected and also user needs to click twice to add the item to cart: 2014/02/03 - 1, 2014/02/04 - 3
D944,R1091 - Shopping cart functionality broken: no update sets found
D948, R812 - Blank Contact PO Box field and readonly does not allow user to submit the request: 2014/03/04 - 1
D949, R788 - Subversion request: Requester email address does not match the corresponding requester selected from the people picker list: 2014/02/10 - 2
D956, R926 - IAM Attribute Release form: Assignment group is blank. It should be IS Identity and Access Management: 2014/02/18 - 1
D958, R926 - IAM Attribute form: Student Details Text box retains values or does not cleared out although the Students check box is unchecked: 2014/02/20 - 1
D959 - this was a PREPROD regression; nothing to advance, no actual update sets
D960 - this was a PREPROD regression; nothing to advance, no actual update sets
D961, D962, R664 - Template publishing form: Remove the approval process from the request: 2014/02/20 - 2
D962 - see D961
D963, R789 - Load Balancer form: Fields which are invisibile at the time of creating the request retain old values and are visible on RITM and SCTASK screens: 2014/03/05 - 1
D964, R789 - Load balance form: Testing date after projected use date is accepted by the system: 2014/03/05 - 2
D965, R966 Metrics form - Assignment group is not assigned: 2014/02/25 - 1
D968, R1034 Workflow for EliApps mail alias form broken when approval granted: 2014/02/28 - 1, 2014/04/02 - 1, 2014/04/02 - 5
D985 - Notifications: Remove approval process on ElipApps form: 2014/03/12 - 5
D988 - Load Balance request form: redux of date issues; need to revalidate opposing date field when fixing invalid date: 2014/03/14 - 1
D989, R789 - Load Balancer Form: Testing Date and Projected Use Date should be mandatory: 2014/03/20 - 1
D990, R789 - Load Balancer Form: issues that are complications of D989; probably a duplicate of D989.
D991, R789 - Load Balancer Form: issues that are complications of D989; probably a duplicate of D989.
D992: Prevent users from changing their date and time prefs, and reverse any that have been changed: 2014/03/25 - 1
D993, D994, R780: Fixing up issues with Security Design Review forms. There are two of them because there were two specs, and the specs were very different. Need to disable the form that we shouldn't show. Also, lose the shopping cart quantity on the form. 2014/03/20 - 3
D994 see D993
D995, R785 - Firewall form: Title does not match spec: 2014/03/21 - 1, 2014/03/24 - 2
D996, R785 - Firewall form: Caption for firewall does not match spec: 2014/03/21 - 2
D998, D785 - Firewall form: Caption for 'purpose of change' does not match spec: 2014/03/24 - 3,
D999 - nothing to advance.
D1000 - Certain Incident views shouldn't be different: 2014/03/24 - 1
D1001, R780 - SDR Form: Other field holds value when morphing form: 2014/03/24 - 5
D1003, R785 - Firewall form: Morphing the form leave values behind: 2014/03/24 - 4
D1004, R785 - Firewall form: Requested for doesn't work properly: 2014/03/25 - 3
D1005 - fixed elsewhere; nothing to advance.
D1009, R812 - Audioconference form: Need phone validation onSubmit: 2014/04/08 - 1
D1010, R780 - SDR form: Need to blank morphed application initiative values: 2014/04/08 - 3
D1011, R780 - SDR form: Need to blank morphed system critical values: 2014/04/08 - 4
D1012, R780 - SDR form: Need to validate date value: 2014/04/08 - 5
D1013, R780 - SDR form: Need to blank morphed why value: no update set found
D1014, R780 - SDR form: Spec deviation regarding practice, etc. Should change spec to match the way it was delivered, because the UAT approval was already granted : 2014/04/08 - 7
D1015, R1034 - Eli apps: Need slight validation on aliases request: 2014/04/09 - 1
D1016, R1034 - Eli apps: Spec deviation regarding workflow. Need to change the SPEC to match the way it was delivered, because we changed the SPEC during UAT: This was not tagged, but was fixed on an R1034 update set.
D1018, R780 - SDR form: Validate date onCheckout in addition to onChange: 2014/04/11 - 4
D1019, R812 - Audioconference form: Blank phone number and other related fields when morphing form: 2014/04/11 - 3
D1020, R926 - IAM Attribute form: Connection group checkboxes missing from SCTASK: 2014/04/11 - 2
D1021, R926 - IAM Attribute form: End date can be before start date, also both dates can be in past: 2014/04/14 - 1
D1022, R780 - SDR form: Need to clear out go-live and production date fields: 2014/04/16 - 2
D1023, R780 - SDR form: BAA field should get cleared when unused: 2014/04/16 - 3
D1024, R780 - SDR form: Type of application, Other field should get cleared when unused: 2014/04/16 - 4
D1025, R1147: Work note SCTASK rebroadcasts back to the SCTASK again, 2014/04/23 - 1
D1026, R1091: Microtier form: When Windows, the assignment group is wrong. 2014/04/21 - 1

update sets:

~~2013/04/01 - 1~~
2013/04/23 - 2
2013/04/26 - 1
~~2013/04/30 - 1~~
2013/05/28 - 2
~~2013/07/01 - 8~~
2013/07/10 - 9
2013/07/10 - 10
2013/07/24 - 7
2013/07/28 - 2
2013/07/31 - 7
2013/08/23 - 1
2013/09/09 - 4
2013/09/17 - 5
2013/09/25 - 3
2013/09/25 - 4
2013/09/26 - 4
2013/09/26 - 5
2013/10/10 - 7
~~2013/10/29 - 1~~
2013/10/30 - 3
2013/11/05 - 1
2013/11/05 - 2
2013/11/05 - 3
~~2013/11/05 - 4~~
2013/11/06 - 9
~~2013/11/12 - 4~~
2013/11/19 - 1
2013/12/09 - 4
2013/12/09 - 5
2013/12/09 - 6
~~2013/12/10 - 2~~
2013/12/10 - 4
2013/12/10 - 5
2013/12/10 - 8
~~2013/12/11 - 4~~
~~2013/12/13 - 1~~
2013/12/19 - 2
2014/01/17 - 4
2014/01/27 - 2
2014/02/03 - 1
2014/02/04 - 1
2014/02/04 - 2
2014/02/04 - 3
~~2014/02/04 - 6~~
2014/02/05 - 2
2014/02/05 - 6
2014/02/05 - 7
~~2014/02/05 - 8~~
2014/02/10 - 1 ( redeploy)
2014/02/10 - 2
2014/02/10 - 3
2014/02/10 - 4
2014/02/10 - 5
2014/02/11 - 4
2014/02/11 - 5
2014/02/14 - 1

2014/02/18 - 1
2014/02/20 - 1
2014/02/20 - 2
2014/02/25 - 1

2014/02/28 - 1
2014/03/04 - 1
2014/03/05 - 1
2014/03/05 - 2

2014/03/06 - 2
2014/03/11 - 1
2014/03/11 - 2
2014/03/12 - 5
2014/03/14 - 1
2014/03/17 - 1
2014/03/17 - 2
2014/03/18 - 1
2014/03/20 - 1
~~2014/03/20 - 3~~
2014/03/21 - 1
2014/03/21 - 2
2014/03/24 - 1
2014/03/24 - 2
2014/03/24 - 3
2014/03/24 - 4
~~2014/03/24 - 5~~
2014/03/25 - 1
~~2014/03/25 - 2~~
2014/03/25 - 3
2014/04/02 - 1
~~2014/04/02 - 2~~
2014/04/02 - 3
~~2014/04/02 - 4~~
2014/04/02 - 5
~~2014/04/02 - 6~~
2014/04/07 - 1
2014/04/07 - 2
2014/04/08 - 1
~~2014/04/08 - 3~~
~~2014/04/08 - 4~~
~~2014/04/08 - 5~~
~~2014/04/08 - 7~~
2014/04/09 - 1

2014/04/11 - 2
~~2014/04/11 - 3~~
~~2014/04/11 - 4~~
2014/04/14 - 1
~~2014/04/16 - 2~~
~~2014/04/16 - 3~~
~~2014/04/16 - 4~~

~~2014/04/21 - 1~~

~~2014/04/23 - 1~~

~~Manual deploy:~~

~~D992, there is a manual deploy; run the background script and enable (uncomment) the payload.~~

var user_count = 0; 
var user = new GlideRecord('sys_user'); 
user.addQuery('date_format', '!=', ''); 
user.query(); 

while (user.next()) { 
user_count ++; 
gs.print('User: ' + user.name + ', Format: ' + user.date_format); 
//user.date_format = ''; 
//user.update(); 
} 
gs.print('Total Users Modified: ' + user_count);

~~result:~~

0:00:00.272] Script completed: scriptTime: 0:00:00.258 id: yalepreproduction_1[glide.17] for: SELECT sys_user0.`sys_id` FROM sys_user sys_user0  WHERE sys_user0.`date_format` IS NOT NULL 
*** Script: User: Stuart Teal, Format: MM-dd-yyyy
*** Script: User: Daniel O'Connell, Format: MM-dd-yyyy
*** Script: User: Daniel Tinari, Format: dd/MM/yyyy
*** Script: User: William Welch, Format: MM-dd-yyyy
*** Script: User: Samuel Chevalier, Format: MM-dd-yyyy
*** Script: User: Timothy Lee, Format: MM-dd-yyyy
*** Script: User: Len Peters, Format: MM-dd-yyyy
*** Script: User: Jason Ignatius, Format: MM-dd-yyyy
*** Script: User: Robert Haig, Format: MM-dd-yyyy
*** Script: User: Daniel Yang, Format: MM-dd-yyyy
*** Script: User: Stephanie Scungio, Format: dd/MM/yyyy
*** Script: User: Charlie Queiroga, Format: MM-dd-yyyy
*** Script: User: Lynnette Averill, Format: MM-dd-yyyy
*** Script: User: Neal Greene, Format: dd/MM/yyyy
*** Script: User: Astrit Mulla, Format: MM-dd-yyyy
*** Script: User: Wen-tao Cheng, Format: yyyy-MM-dd
*** Script: User: Nathaniel Harrington, Format: dd.MM.yyyy
*** Script: User: Chris Kilbourne, Format: dd/MM/yyyy
*** Script: User: David Logie, Format: MM-dd-yyyy
*** Script: User: Jacklyn Trickett-Sargent, Format: MM-dd-yyyy
*** Script: User: Lucy Kapur, Format: MM-dd-yyyy
*** Script: User: Jill Short, Format: MM-dd-yyyy
*** Script: User: Michael Paquette, Format: MM-dd-yyyy
*** Script: User: Michael Macary, Format: MM-dd-yyyy
*** Script: User: Mahesh Velagapudi, Format: MM-dd-yyyy
*** Script: User: Jeffrey Goddu, Format: MM-dd-yyyy
*** Script: User: Glenn Hasiotis, Format: MM-dd-yyyy
*** Script: User: Steven Fielding, Format: MM-dd-yyyy
*** Script: User: Ali Makhzangi, Format: MM-dd-yyyy
*** Script: User: Michael Rath, Format: MM-dd-yyyy
*** Script: User: Theresa D'Arcangelo, Format: dd-MM-yyyy
*** Script: User: Eric Lieberman, Format: MM-dd-yyyy
*** Script: User: Paul Johnson, Format: MM-dd-yyyy
*** Script: User: Cynthia Welsh, Format: yyyy-MM-dd
*** Script: Total Users Modified: 34

Feb 21, 2014

~~R926 - Request: New Service Request for IAM - Attribute Release Form 2013/07/28 - 2, 2013/09/09 - 4, 2013/10/30 - 3, 2014/01/23 - 3~~
~~R938 - Request: Software Library Addition or Change 2013/09/13 - 1~~
~~R982 - "Telephone End user change" variable set 2013/06/28 - 5, 2013/07/09 - 1~~
~~R993 Mobile Device: Change 2013/07/19 - 3, 2013/08/22 - 4, 2013/09/05 - 1, 2013/09/11 - 1, 2013/09/19 - 1, 2013/09/26 - 1, 2013/12/06 - 6~~
~~R1073: Mobile Device Change: Add messaging on Corp to Personal 2013/11/01 - 5~~
~~R1078: Mobile Device: Add & Change - Remove Total Monthly Recurring Charge (excluding the device charge) 2013/11/12 - 5~~
~~R1112: Associate Financial Approval Workflow to Mobile Device Change Request Form 2013/12/02 - 1~~
~~R1113: Mobile Device Change. Clear all extraneous variable values upon checkout. 2013/11/14 - 2, 2013/11/19 - 2, 2013/12/04 - 2~~
~~D645, R1091 - Microtier form: Requested for field does not hold the value of the client primary user field. 2013/06/26 - 11, 2014/02/10 - 1~~
~~D646 - Change Assignment Group form: Requested_for field on RITM does not match value chosen on form 2014/02/11 - 3~~
~~D702 - Mobile Device Change: Reassign New End User - cannot change end user without also entering PTAEO 2013/11/08 - 2~~
~~D705 - Mobile Device Change: transfer Personal to Corporate - billing Account number Validated as a Phone Number 2013/11/08 - 3~~
~~D706 -Mobile Device Change : transfer Personal to Corporate - Provider Selection field bar behaves differently with different providers 2013/11/11 - 6~~
~~D707 - Change Mobile Device: Transfer Personal to Corporate - Calling plans show AT&T plans only regardless of provider selected. (fixed on D705)~~
~~D710: Mobile Device Change. Clear plan and add-ons if vendor is- changed. 2013/11/12 - 3~~
~~D712 - Mobile Device Change: Change Provider Plan or Model - Missing entire input section for device, provider, and plan. No card; think this was just a manual fixup~~
~~D722, R938 - Software Library request: Error Or Validation messages display multiple times 2014/02/07 - 3~~
~~D723, R938 - Software Library request: SCTASK does not display the request form fields 2014/02/04 - 4~~
~~D814: R1073 Mobile Device Change: Make message be in red font 2013/11/26 - 2~~
~~D857 - Request: FAS HPC Acct Creation RITM Requested for in the variables and Header section do not match 2013/12/09 - 3~~
~~D860 - Request: YaleConnect Migration item doesn't assign SC Tasks to CTS Email Migration NO CARD, data fixup.~~
~~D867: Mobile Device Change - remove Search box. 2013/12/06 - 7~~
~~D868: Mobile Device Change - Cannot complete request for End User Only change in Certain subversions of Internet Explorer. All other browsers and some IE are fine. Fixed by D877~~
~~D869: MDC - Financial Approvers were not assigned to RITM. (2013/12/06 - 6, fixed upstream on requirement, Platform bug with long question answer choices)~~
~~D870: Mobile Device Change, Corp to Personal, Date to end service calendar widget should not accept yesterday as valid. 2013/12/11 - 1~~
~~D873: Mobile Device Change - Need to show 'Enter New mobile device model' on PERS to CORP. 2013/12/11 - 5~~
~~D874: Mobile Device Change. Enter new Model should be required field. 2013/12/11 - 2~~
~~D875: Mobile Device Change. Enter New Calling/Data Plan should be required field. 2013/12/12 - 1, 2013/12/16 - 1, 2013/12/17 - 1~~
~~D876: Mobile Device Change: C2C to Yale, fields should be marked as required. 2013/12/17 - 2~~
~~D877: Mobile Device Change. Missing Contact Information Section when Change type = Change PTAEO/End User. 2013/12/18 - 3, 2013/12/19 - 3, 2013/12/20 - 2~~
~~D878: Mobile Device Change. Missing Comments Section on Change end user form. FIXED on D877~~
~~D879: Mobile Device Change. Edit shopping cart values not saved. 2013/12/31 - 1~~
~~D880: MDC: P2C, Staying with provider = NO. Fields should be marked as required. FIXED on D876~~
~~D881: MDC, P2C: Staying with Current Provider =NO. Plan and add on costs not totaled. 2013/12/17 - 3~~
~~D882: MDC. C2C Out of Yale. Date error does not clear when valid date is entered. FIXED elsewhere.~~
~~D886 - MDC: On change Provider Plan or Model, need to pass appropriate variables into SCTASK. 2013/12/18 - 1~~
~~D893 - MDC - C2C out of yale. SCTASK cannot be closed. 2013/12/20 - 3~~
~~D895: MDC Change PTAEO and User. FA did not auto-approve as expected. 2014/01/03 - 1, 2014/01/06 - 1~~
~~D908 - Notifications: Add ethernet. Request confirmation sent to <requested for> - should be <opened by> Nothing to do for this defect.~~
~~D911 - TestRegression: Pager Add new - Financial Approval being bypassed. 2014/01/17 - 5~~
~~D912 - TestRegression: Internet Explorer only: Pager Change: Replace Lost: Error on Submit indicating invalid PTAEO 2013/10/30 - 6, 2014/01/21 - 1~~
~~D913; TestEnvRegression: Mobile Device Add - Catalog selection label repeated. 2014/01/21 - 2~~
~~D915 - TestEnvRegression: Mobile device delete. Contact email editable when it should not be. 2014/01/21 - 3~~
~~D916 - TestEnvRegression. Mobile Device Change. Duplicate Approval Notifications sent. 2014/02/06 - 1, 2014/02/12 - 1~~
~~D917 - TestEnvRegression: Mobile Device Change: Transfer Personal to Corp. Default provider should be Verizon. 2014/01/21 - 4~~
~~D930: Notifications: Approval Request Escalation Notice - several things to fix. 2014/01/27 - 5~~
~~D931: Notifications: Mobile device Delete. Request Confirmation - Wrong Addressee: 2014/01/27 - 4~~
~~D932: Notifications: Pager Change User. two different request confirmation emails sent. wrong Addresee on 'correct' email. 2014/01/27 - 3~~
~~D933 - Compiled Notifications text changes. 2014/01/27 - 6, 2014/01/28 - 1~~
~~D934: TestEnvRegression: Pager Add : Requested for field variables disagree with RITM Header. 2014/01/24 - 1~~
~~D938: Notifications: Link sent to customers to check their Request ticket status is broken. (FIXED BY D933).~~
~~R926, D956 - IAM Attribute Release form: Assignment group is blank. It should be IS Identity and Access Management. 2014/02/18 - 1~~

update sets:

2013/06/26 - 11
2013/06/28 - 5
2013/07/09 - 1
2013/07/19 - 3
~~2013/07/28 - 2~~
2013/08/22 - 4
2013/09/05 - 1
~~2013/09/09 - 4~~
2013/09/11 - 1
2013/09/13 - 1
2013/09/19 - 1
2013/09/26 - 1
~~2013/10/30 - 3~~
2013/10/30 - 6
2013/11/01 - 5
2013/11/08 - 2
2013/11/08 - 3
2013/11/11 - 6
2013/11/12 - 3
2013/11/12 - 5
2013/11/14 - 2
2013/11/19 - 2
2013/11/26 - 2
2013/12/02 - 1
2013/12/04 - 2
2013/12/06 - 6
2013/12/06 - 7
2013/12/09 - 3
2013/12/11 - 1
2013/12/11 - 5
2013/12/12 - 1
2013/12/16 - 1
2013/12/17 - 1
2013/12/17 - 2
2013/12/17 - 3
2013/12/18 - 1
2013/12/18 - 3
2013/12/19 - 3
2013/12/20 - 2
2013/12/20 - 3
2013/12/31 - 1
2014/01/03 - 1
2014/01/06 - 1
2014/01/17 - 5
2014/01/21 - 1
2014/01/21 - 2
2014/01/21 - 3
2014/01/21 - 4
~~2014/01/23 - 3~~
2014/01/24 - 1
2014/01/27 - 3
2014/01/27 - 4
2014/01/27 - 5
2014/01/27 - 6
2014/01/28 - 1
2014/02/04 - 4
2014/02/06 - 1
2014/02/07 - 3
2014/02/10 - 1
2014/02/11 - 3
2014/02/12 - 1
~~2014/02/18 - 1~~

manual deploy:

~~IAM form after deploy: Enable the Access service catalog category in PRE-PROD, leave it hidden in PROD.~~

Dec 13, 2013

~~D811 - State being not updated on RITM View for all the PMO Forms (Already committed?) 2013/11/20 - 1~~
~~R956 - Request: New Service Request for Request New Webfarm Applicati 2013/09/18 - 4, 2013/09/26 - 7, 2013/11/06 - 5, 2013/11/12 - 1~~
~~/end RTS~~
~~R970 - Mobile Device: Add New catalog item 2013/07/10 - 2, 2013/08/12 - 1~~
~~R1020: Financial Approval Workflow v2.0 (nothing to commit; this is already there)~~
~~R1072: Mobile Device Add and Mobile Device Change. Changing the SPEC for messaging on the form. 2013/11/01 - 4 (may need to push this again when Change goes to PROD)~~
~~R1110: Mobile Add: Associate Financial Approval Workflow to Request Form 2013/11/11 - 2, 2013/11/11 - 5~~
~~R1127: Ethernet: Auto-populate contact fields 2013/12/02 - 3~~
~~R1142: Reduce TWO PTAEO workflow timers from 10 minutes to 3 minutes. 2013/12/10 - 7~~
~~D677: Mobile Device Add: Remove search box, place in correct category. 2013/09/27 - 2~~
~~D691 - Add Mobile Device - Calling/data plans should be filtered according to selected provider. 2013/10/04 - 2~~
~~D724 - Mobile device add - Add-on list not cleared if new provider selected. Common to all mobile device forms. 2013/11/08 - 1~~
~~D813: Mobile Device Plan Updates not applied correctly. 2013/11/25 - 1~~
~~D823 - Financial Approval Workflow 2 PTAEO: Only one approval requested - should be two. 2013/11/15 - 2, 2013/11/15 - 3, 2013/11/15 - 5, 2013/11/18 - 4, 2013/11/22 - 4~~
~~D829: Mobile Device Add - Calling / Data Plan should be a required field. 2013/11/22 - 1~~
~~D832: Financial Approval 2-PTAEO - Approved Notification going out before RITM fully approved. 2013/11/18 - 5, 2013/11/20 - 2~~
~~D834: FA 2P - One time charge approver disappeared from list with no action from user. 2013/11/22 - 7~~
~~D840: FA2P: RITM Fulfilled based on one secondary Approval only. 2013/11/26 - 4~~
~~D841: FA2P - Auto Approve did not occur as expected. 2013/11/26 - 3~~
~~D853: TWO PTAEO Financial Approval Workflow: Upon escalation, secondary approver requested for ORG where approval has already been granted. 2013/11/22 - 3~~
~~D863 - FA2P. Secondary approver action over-rides initial approver action. 2013/12/06 - 2~~

update sets:

~~2013/07/10 - 2~~
~~2013/08/12 - 1~~
~~2013/09/18 - 4~~
~~2013/09/26 - 7~~
~~2013/09/27 - 2~~
~~2013/10/04 - 2~~
~~2013/11/01 - 4~~
~~2013/11/06 - 5~~
~~2013/11/08 - 1~~
~~2013/11/11 - 2~~
~~2013/11/11 - 5~~
~~2013/11/12 - 1~~
~~2013/11/15 - 2~~
~~2013/11/15 - 3~~
~~2013/11/15 - 5~~
~~2013/11/18 - 4~~
~~2013/11/18 - 5~~
~~2013/11/20 - 2~~
~~2013/11/22 - 1~~
~~2013/11/22 - 3~~
~~2013/11/22 - 4~~
~~2013/11/22 - 7~~
~~2013/11/25 - 1~~
~~2013/11/26 - 3~~
~~2013/11/26 - 4~~
~~2013/12/02 - 3~~
~~2013/12/06 - 2~~
~~2013/12/10 - 7~~

Nov 29, 2013

~~R931 - Telephone Services Delete (including FA) 2013/06/04 - 2, 2013/06/04 - 3, 2013/06/07 - 2, 2013/06/18 - 3, 2013/07/17 - 1, 2013/07/19 - 7, 2013/08/27 - 8~~
~~R992 - Mobile Device Plan Delegated Maintenance 2013/07/03 - 1~~
~~R994 Mobile Device: Delete 2013/07/19 - 2~~
~~R1111: Mobile Delete: Associate Financial Approval Workflow to Request Form 2013/11/11 - 4~~
~~R1122: Associate Financial Approval Workflow with Telephone Services Delete 2013/11/22 - 2~~
~~D517 - Telephone Delete: Number verification fails onSubmit(). 2013/06/20 - 2~~
~~D574 - Telephone Delete: date validation issues 2013/07/31 - 6, 2013/11/22 - 6~~
~~D589 - Mobile Device Delete. Wrong assignment group. 2013/07/31 - 10~~
~~D623: Delete Mobile Device. Phone number issues, and date issues. 2013/08/19 - 3~~
~~D636: Telephone Services Delete: Validate the end date more 2013/08/27 - 2~~
~~D673 - Telephone Delete: Requested for not indicated as required field. 2013/10/15 - 2~~
~~D674 - Delete Telehone request - date picker used but system reports error- invalid date. 2013/11/05 - 5~~
~~D694 - Delete Mobile Device - Date picker errors with valid date. 2013/11/06 - 2~~
~~D695 - Delete Telephone services has an extra title bar.2013/10/15 - 3~~
~~D854: Telephone Delete: Missing Notification in Gmail on Escalation. No update set for this one. It was spurious behavior that fixed itself.~~
~~D855 - R994 Mobile device delete: date picker allows yesterday as valid date. 2013/11/22 - 5~~

update sets:

2013/06/04 - 2
2013/06/04 - 3
2013/06/07 - 2
2013/06/18 - 3
2013/06/20 - 2
2013/07/03 - 1
2013/07/17 - 1
2013/07/19 - 2
2013/07/19 - 7
2013/07/31 - 6
2013/07/31 - 10
2013/08/19 - 3
2013/08/27 - 2
2013/08/27 - 8
2013/10/15 - 2
2013/10/15 - 3
2013/11/05 - 5
2013/11/06 - 2
2013/11/11 - 4
2013/11/22 - 2
2013/11/22 - 5
2013/11/22 - 6

Manual deploy:

Go to Scheduled Import. Force the import for MobileDevicePlans. Watch progress and confirm it completes without error. This populates the mobile device plans.
Check on the Service Catalog. In PROD, nothing in the category Phones and Cable TV should be visible. In PRE-PROD, we should see Pager subcategory, Mobile Device Delete, and Telephone Services Delete.

Nov 22, 2013

~~R841 - Pager Add (including FA) (This has already been applied to PROD)~~
~~R842 - Pager Change (including FA) Mostly applied, but also 2013/07/12 - 1~~
~~R843 - Pager Delete (including FA) Mostly applied, but also 2013/10/17 - 4~~
~~R1038: Pager Add New. Set maximum quantity for group pager.2013/09/13 - 2~~
~~R1081: Financial Approval Workflow One PTAEO: Attach to Pager Add. 2013/10/22 - 3~~
~~R1082 - Attach FA to Pager: Change 2013/10/30 - 11,2013/10/31 - 5~~
~~R1083 - Attach FA to Pager: Delete 2013/10/31 - 2,2013/10/31 - 4~~
~~R1101 - Setting a Group Pager Quantity Upper Limit on Add Pager Form 2013/10/31 - 1~~
~~R1111: Mobile Delete: Associate Financial Approval Workflow to Request Form 2013/11/11 - 4~~
~~R1114: Pager: Add New: Group pager, set minimum quantity to two 2013/11/12 - 6~~
~~R1115: Pager Add, Change & Delete: Update item description in service catalog 2013/11/12 - 7~~
~~R1116: Pager forms: Update pickup location details 2013/11/12 - 8, 2013/11/13 - 2, 2013/11/18 - 3~~
~~R1117: Pager Change & Delete: update phone number variable description 2013/11/12 - 9~~
~~D486 - Pager Add & Change: Make "Requested for" field actually change "requested_for" in workflows 2013/05/03 - 1~~
~~D496 - Pager change: Skip financial approval if replace lost/stolen pager. 2013/05/22 - 2, 2013/11/01 - 3~~
~~D497 - Pager add: Modify workflow for group pagers. 2013/05/24 - 1~~
~~D498 - Pager change: Modify workflow for 'requested for'. 2013/05/28 - 1, 2013/09/24 - 1~~
~~D542 - Pager Add workflow should set Stage Complete when fulfillment completes. 2013/07/18 - 3~~
~~D546 - Three pager catalog items: short description. 2013/07/17 - 4, 2013/09/17 - 4~~
~~D581 - Pager change R842: Needs requested_for field 2013/07/25 - 1~~
~~D586 - Pager Change: Need to fix help text and workflow issues. 2013/07/30 - 1, 2013/07/30 - 2~~
~~D591 - Pager change help text was improperly placed. 2013/07/31 - 4~~
~~D606 - Pager Add. Fix SCTASK fulfillment. 2013/08/07 - 2, 2013/08/13 - 1~~
~~D610 - Pager Delete. Date validation needs to be retested. 2013/08/14 - 2, 2013/08/19 - 2~~
~~D614 - "Contact information for telco forms" variable set doesn't prevent submit of bad info 2013/08/08 - 1, 2013/08/15 - 2~~
~~D616 - "Contact information for telco forms" could not handle phone numbers that do not contain area codes. 2013/08/15 - 1, 2013/08/19 - 1~~
~~D617 - Pager Add New. Prevent leading zeros on quantity. 2013/08/15 - 3~~
~~D621 - Add "Requested for" field to Pager Delete form. 2013/08/16 - 2~~
~~D637: Pager Delete: Edit to form language 2013/08/27 - 3~~
~~D638: Pager Delete: Needed help text on phone number field. 2013/08/27 - 4~~
~~D639: Pager Delete: Display precise error message when submitting bad date 2013/08/27 - 5~~
~~D640: Pager Delete: Set one year cap on future end dates 2013/08/27 - 6~~
~~D644: Pager Add New, Group Pager. RITM quantity should match group pager quantity 2013/09/09 - 3~~
~~D657: Pager Add, Change & Delete: catalog items should have search box removed 2013/07/17 - 4~~
~~D658: Pager Change - PTAEO prevents submit 2013/10/17 - 1, 2013/10/29 - 2~~
~~D660: Pager Add - Quantity getting applied to non-group pagers 2013/10/17 - 3~~
~~D761 - question on notification - request escalated for approval. 2013/11/08 - 5~~
~~D774: Add pager - Est. Del. Date in RITM is blank. 2013/10/30 - 10, 2013/10/31 - 3~~
~~D774, D789,D790: Pager Add: Del Date, Due by and Est Del Date should match. 2013/10/31 - 3~~
~~D796: Pager Change - Can submit change service with both Model and Coverage set to no change. 2013/11/01 - 2, 2013/11/18 - 2~~
~~D797: Pager Change - Financial approval request going to wrong approver. 2013/11/01 - 1~~
~~D799: Pager Change: No financial approval required on 'Replace Lost/Broken' 2013/11/01 - 3~~
~~D801: Pager Change. Re-assign End User Only - Financial approval always defaults to Start Admin 2013/11/04 - 4~~
~~D804: Pager Delete - Date Entry in IE8 produces error. 2013/11/04 - 5, 2013/11/13 - 1~~
~~D805 - Pager Delete: Incorrect Date validation message displayed for current date 2013/11/13 - 1~~
~~D824: Financial Approval Workflow 2 PTAEO - On reject, spurious email generated 2013/11/15 - 1~~
~~D825: R1116: Pager Change - pickup location should be hidden. 2013/11/13 - 2~~

Update set list:

2013/05/03 - 1
2013/05/22 - 2
2013/05/24 - 1
2013/05/28 - 1
2013/07/12 - 1
2013/07/17 - 4
2013/07/18 - 3
2013/07/25 - 1
2013/07/30 - 1
2013/07/30 - 2
2013/07/31 - 4
2013/08/07 - 2
2013/08/08 - 1
2013/08/13 - 1
2013/08/14 - 2
2013/08/15 - 1
2013/08/15 - 2
2013/08/15 - 3
2013/08/16 - 2
2013/08/19 - 1
2013/08/19 - 2
2013/08/21 - 1
2013/08/27 - 3
2013/08/27 - 4
2013/08/27 - 5
2013/08/27 - 6
2013/09/09 - 3
2013/09/13 - 2
2013/09/17 - 4
2013/09/24 - 1
2013/10/17 - 1
2013/10/17 - 3
2013/10/17 - 4
2013/10/22 - 3
2013/10/29 - 2
2013/10/30 - 10
2013/10/30 - 11
2013/10/31 - 1
2013/10/31 - 2
2013/10/31 - 3
2013/10/31 - 4
2013/10/31 - 5
2013/11/01 - 1
2013/11/01 - 2
2013/11/01 - 3
2013/11/04 - 4
2013/11/04 - 5
2013/11/08 - 5
2013/11/11 - 4
2013/11/12 - 6
2013/11/12 - 7
2013/11/12 - 8
2013/11/12 - 9
2013/11/13 - 1
2013/11/13 - 2
2013/11/15 - 1
2013/11/18 - 2
2013/11/18 - 3

58 updates. That makes this bigger than last weeks update, and I think that makes this the biggest update ever.

MANUAL DEPLOYMENT:

~~Add category Phones and CableTV to Service Catalog.~~
~~Should Yale MeetingPlace teleconference be visible (within Phones and CableTV)? I don't know whether or not it should be hidden.~~
~~set catalog items inactive: "PTAEO reusable UI initial and recurring" and "Prototype mobile device catalog request"~~
~~Go to DEV. Do an XML export of Pagers SC category. Do an XML import of the SC category in PROD.~~
~~Go to DEV. Do an XML export of Telephone Services SC category. Do an XML import of the SC category in PROD. Set the Telephone Services category to NonActive.~~

Nov. 15, 2013

~~D826: Ethernet Add: SCTASK version of PTAEO is misaligned in PRE-PROD and PROD 2013/11/14 - 1~~
~~R1040: Retire 'Finalize YaleConnect Migration' Service Request 2013/10/29 - 9~~
~~R1062 - Request: Make spelling in dropdowns match. 2013/10/30 - 2~~
~~R808: New Catalog Item for "Request a New MOVI Svc Acct" 2013/04/29 - 6, 2013/11/06 - 6, 2013/11/06 - 7~~
~~D817,R808 - Quantity Drop down is not required on this Request 2013/11/12 - 2~~
~~D807 , R808 - Invalid email can be submitted for the request SAME AS R808~~
~~END READY TO SERVE : BEGIN START REPLACEMENT~~
~~R847: Ethernet Add 2013/05/07 - 1,2013/05/30 - 1,2013/05/30 - 2,2013/07/19 - 8,2013/07/24 - 4,2013/08/13 - 2~~
~~R895 Second time committing Contact info for telco forms: 2013/05/01 -2 (already committed), 2013/07/24 - 3, 2013/07/26 - 1, 2013/07/26 - 2~~
R1020: FINANCIAL APPROVAL WORKFLOW (THIS WILL HAVE TO BE FURTHER ADVANCED LATER, BUT MOST OF IT NEEDS TO GO NOW) 2013/09/27 - 1,2013/10/02 - 3,2013/10/07 - 3,2013/10/16 - 1,2013/10/17-5,2013/11/11 - 1,2013/11/11 - 3
~~R1099: Financial Approval Workflow One PTAEO: Attach to Ethernet Add. 2013/10/22 - 2~~
~~R1105: Add Ethernet - Set Upper limit = 50 2013/10/29 - 6~~
~~R1106: Add Ethernet - Update Delivery Time on Req Form 2013/10/29 - 7~~
~~R1107: Ethernet Add: Create new question on form 2013/11/04 - 2,2013/11/06 - 3,2013/11/06 - 8~~
~~R1108: PTAEO: Improve messaging on invalid length ORG field 2013/11/04 - 3~~
~~D506 - Ethernet Add New form should not show Floor variable from variable set. 2013/05/31 - 1,2013/07/24 - 4~~
~~D575 - Requested for broken on Ethernet Add form. 2013/07/24 - 1,2013/10/25 - 4~~
~~D582 - Building Data variable sets: Relabel field 2013/07/25 - 2~~
~~D585 & R895 - "Contact Information for telco forms" variable set needs to be retested SAME AS R895~~
~~D642: Ethernet Add New: Limit 'requested for' to active users. 2013/08/27 - 7~~
~~D732: Ethernet: Contact Info - phone number required 2013/10/23 - 3~~
~~D736: Financial Approval: Approval info not carried thru to SCTASK 2013/10/25 - 6~~
~~D740 - Fin App - Bolt member request not auto-approved. SPEC change. 2013/10/25 - 5~~
~~D746: Financial Approval: 5 minute timer on initial approver should not exist 2013/10/25 - 1~~
~~D747 - Fin App - After Initial Approver timeout, initial approver should still be able to approve request. SAME AS D746~~
~~D748 - Fin App - Clarification of approver states and Req Status options after initial timeout. SAME AS D746~~
~~D750 - FA notification (Confirmation) inaccurate text 2013/10/28 - 1,2013/10/28 - 2,2013/10/28 - 3,2013/10/29 - 4,2013/10/30 - 12~~
~~D751 - FA notification (Rejected) inaccurate text 2013/10/28 - 4, 2013/10/29 - 4~~
~~D752 - FA notification (Cancelled) inaccurate text 2013/10/29 - 4~~
~~D754 - FA notification (Approved) inaccurate text 2013/10/29 - 4~~
~~D755 - FA notification (Resolved) inaccurate text 2013/10/29 - 4~~
~~D759 - FA notification (Pending Approval) inaccurate text 2013/10/29 - 4~~
~~D760 - Financial Approval Workflow: Approver can change approval after RITM cancellation 2013/10/30 - 8~~
~~D764 - Ethernet Add: IE8, Stack overflow on changing qty 2013/10/29 - 5~~
~~D765 - Request OPENED BY BOLT member does not auto-approve. 2013/10/29 - 3~~
~~D768,R841 - Request should be in the state it was originally set to be 2013/10/30 - 9~~
~~D771 - R1106 Update Delivery time to 10 days. 2013/10/30 - 7~~
~~D795: Financial Approval notifications for accept and reject firing twice. 2013/10/31 - 6~~

~~deploy order:~~

2013/11/14 - 1
2013/04/29 - 6
2013/05/07 - 1
2013/05/30 - 1
2013/05/30 - 2
2013/05/31 - 1
2013/07/19 - 8
2013/07/24 - 1
2013/07/24 - 3
2013/07/24 - 4
2013/07/25 - 2
2013/07/26 - 1
2013/07/26 - 2
2013/08/13 - 2
2013/08/27 - 7
2013/09/27 - 1
2013/10/02 - 3
2013/10/07 - 3
2013/10/16 - 1
2013/10/17 - 5
2013/10/22 - 2
2013/10/23 - 3
2013/10/25 - 1
2013/10/25 - 4
2013/10/25 - 5
2013/10/25 - 6
2013/10/28 - 1
2013/10/28 - 2
2013/10/28 - 3
2013/10/28 - 4
2013/10/29 - 3
2013/10/29 - 4
2013/10/29 - 5
2013/10/29 - 6
2013/10/29 - 7
2013/10/29 - 9
2013/10/30 - 2
2013/10/30 - 7
2013/10/30 - 8
2013/10/30 - 9
2013/10/30 - 12
2013/10/31 - 6
2013/11/04 - 2
2013/11/04 - 3
2013/11/06 - 3
2013/11/06 - 6
2013/11/06 - 7
2013/11/06 - 8
2013/11/11 - 1
2013/11/11 - 3
2013/11/12 - 2

That's 51 update sets. Quite a lot of work finally going into PROD.

Nov. 8, 2013

~~R1026: data loader for BOLT team data; originally 2013/09/11 - 4, 2013/09/18 - 3, 2013/09/19 - 2. Also had a defect D753 that fixed a transform script bug.~~
~~R1037: Force variables read-only on RITM and SCTASK. 2013/08/14 - 1, 2013/10/01 - 1~~
~~R1042: Collapse variable widget on RITM, expand on SCTASK. 2013/08/22 - 1~~
D659: Was a regression caused by D1037. The fix was just to disable a script, which we later re-enable. This is update set 2013/09/18 - 5. It is safe to skip this update set, but might as well promote for the sake of consistency.
~~D661: Duplicate of D659. See notes for D659.~~
~~D753: Data loader for BOLT Team data not clearing people off record if a person leaves and nobody replaces them. 2013/10/25 - 2, 2013/10/25 - 3~~

~~apply order:~~

2013/08/14 - 1
2013/08/22 - 1
2013/09/11 - 4
2013/09/18 - 5
2013/09/18 - 3
2013/09/19 - 2
2013/10/01 - 1
2013/10/25 - 2
2013/10/25 - 3

~~manual deploy: must modify Data Source for DWH-DEPT, DWH-DIV, DWH-ORG.~~

~~Change Mid server to the midprd01, manually override the connection string to:~~

~~jdbc:oracle:thin:@ldap://oid.its.yale.edu:389/dwh1,cn=oracleContext,dc=world~~

~~Then manually do a test load 20 records on DIV, DEPT, ORG to confirm they are all still working right.~~

Then do a manual kickoff of the scheduled Import on DIV. DIV will automatically launch DEPT and ORG. This will take thirty minutes or so altogether. Then go to look at the ORG table. You should see a variable for BOLT member, and it should be populated with people. You may need to adjust your column view to add in the BOLT member. You can also see it on an individual ORG record.

Aug 23, 2013

D588 - ESS: Several small defects on R933.
update set 2013/07/31 - 5
2013/07/31 -9

R652 - ESS: replace the word "incident" on new incident catalog item
update set 2013/05/15 - 3
and 2013/05/15 - 4

R654 - ESS: add new menu item to launch New Ticket (Incident)
update set 2013/05/15 - 2

R933 - ESS New Incident Form: Change form layout
update set 2013/06/05 - 3
2013/07/31 - 9

R950 - ESS New Incident Form: Assign new incident to specific CTS team
update set 2013/06/06 - 3

R957 - ESS New Incident Form: Redirect to "thank you" page onSubmit if from ESS
update set 2013/06/10 - 3

R967 - ESS: Increase font size on thank you page
update set 2013/07/19 - 1

ESS:
2013/05/15 - 2
2013/05/15 - 3
2013/05/15 - 4
2013/06/05 - 3
2013/06/06 - 3
2013/06/05 - 3
2013/06/10 - 3
2013/06/12 - 3
2013/07/19 - 1
2013/07/31 - 5
2013/07/31 - 9

July 26, 2013

R925: Change display width of stage field when viewing RITM.
update set 2013/06/04 - 1
2013/06/19 - 2

R934: PTAEO relabel the fields
update set 2013/07/08 - 3

update sets for this release:
2013/06/04 - 1
2013/06/19 - 2
2013/07/08 - 3

June 21, 2013

R949 - ESS Replace "Ticket" with "Incident" in menu headers
update set 2013/06/05 - 2
2013/06/20 - 3

D515 - ESS: Service Requests: Revise gauge to show requested_for requests
update set 2013/06/12 - 3

R671 - ESS Allow customers to see closed Incidents
update set 2013/05/07 - 3

R836 - ESS Separate Incidents and Requests views
update set 2013/05/06 - 2

R923 - ESS Make changes to show resolved Requests
update set 2013/05/15 - 1

D450 - Resolving a parent Incident or a parent Problem will re-open a closed child incident
update set 2013/06/07 - 1

ESS, just the part that is shipping: D515,R671,R836,R923,R949
2013/05/06 - 2
2013/05/07 - 3
2013/05/15 - 1
2013/06/05 - 2
2013/06/12 - 3
2013/06/20 - 3

D450:
update set 2013/06/07 - 1

June 3, 2013

R894 - Variable set for displaying building information
update set 2013/05/01 - 3

R895 - Variable set for collecting telco information
update set 2013/05/01 - 2

R924 - PTAEO copy button needs to be real javascript button
update set 2013/05/16 - 2

PTAEO copy:
2013/05/16 - 2

Ethernet:
2013/05/01 - 2
2013/05/01 - 3

May 17, 2013

D488 - Filter out defective Building data records
update set 2013/05/06 - 1

R838 START 63 Copy button for Initial and Recurring PTAEO.
update set 2013/04/18 - 1

D485 - PTAEO copy button should STOP copying expenditure type
update set 2013/05/07 - 2

PTAEO copy:
2013/04/18 - 1
2013/05/07 - 2

building data fix:
2013/05/06 - 1

May 4, 2013

73 Making a new data ingress to get building data from YTM, aka Pinnacle.
update set 2013/04/25 - 2
this is a data loader, and therefore it needs to be slightly different
in each instance, with regard to midserver and PROD / DEV / TEST instances.
~~DEV: middev01, YBT3, rick~~
~~TEST: midtst01, YBT2, rick~~
~~PROD: midprd01, YBT1, kim~~

78 PTAEO messaging to deny submit on invalid PTAEO
update set 2013/04/12 - 1

D481 - Defect START D5: Prevent bad PTAEO submit when using back button
trick.
update set 2013/04/25 - 3

82 Categorize the START catalog items into the ITS website categories.
Then hide them so they don't show in production.
update set 2013/04/25 - 5

deploy in the order
2013/04/12 - 1
2013/04/25 - 2
2013/04/25 - 3
2013/04/25 - 5

April 12, 2013

66 Catalog Item: Pager: Add new
update set: 2013/03/20 - 2
advanced to TEST, errors: 3, force committed them
status: UAT-ed in DEV
hidden from end users until START launch. Must access from direct URL: https://yaledevelopment.service-now.com/com.glideapp.servicecatalog_cat_item_view.do?sysparm_id=b0ba89646d90c90094adafb37e1f4534&sysparm_stack=no

67 Catalog Item: Pager: Change
update set: 2013/04/05 - 2
advanced to TEST, errors: 8, force committed them
status: UAT-ed in DEV
hidden from end users until START launch. Must access from direct URL: https://yaledevelopment.service-now.com/com.glideapp.servicecatalog_cat_item_view.do?sysparm_id=30b5a8bd4ce089007ac0de9c82292b22&sysparm_stack=no

69 PTAEO prevent submission if invalid as verified by SOAP service
update set: 2013/04/03 - 1, 2013/04/09 - 1
advanced to TEST, errors: 36, force committed them
status: UAT-ed in DEV
feature set is integrated into each catalog usage of PTAEO

74 Modify PTAEO backend for sending SYSDATE to SOAP service
update set: 2013/04/05 - 1
advanced to TEST, errors: 6, force committed them
status: UAT-ed in DEV
feature set is integrated into each catalog usage of PTAEO

77 Modify PTAEO backend for using PRODUCTION SOAP webmethods Service
update set: 2013/04/04 - 2
advanced to TEST, no errors
status: UAT-ed in DEV
feature set is integrated into each catalog usage of PTAEO

deploy this set in the order of:
2013/03/20 - 2
2013/04/03 - 1
2013/04/04 - 2
2013/04/05 - 1
2013/04/05 - 2
2013/04/09 - 1

March 2013

~~50 build a Service Catalog reusable PTAEO UI, with enforcement of valid formatting~~

~~Special notes about advancing 50 and 51 to test: http://isa.its.yale.edu/confluence/display/SN/advancing+PTAEOs+to+TEST+on+2013+March+24~~

~~Advancing this to test. The update sets for SNART 50:~~

- ~~2013/02/20 - 1, 2013/03/01 - 1, 2013/03/08 - 1, 2013/03/08 - 5, 2013/03/14 - 2~~

~~51 build an interface for PTAEO to properly submit, validate, return ok/bad against a third-party system~~

~~Advancing this to test. The update sets for SNART 51:~~

- ~~2013/01/17 - 3, 2013/01/29 - 1, 2013/01/29 - 2, 2013/01/31 - 1, 2013/02/01 - 2, 2013/02/04 - 4, 2013/02/04 - 5, 2013/02/04 - 6, 2013/02/05 - 1, 2013/02/15 - 1, 2013/02/21 - 3~~

56 Data ingress for TeamLead OpsMgr
The u_cmn_organization contains ORG data. Right now, there is a field called u_head which holds the sys_id for the person who is the LeadAdmin. We need an additional field to hold the OpsManager sys_id for that person, as well as a new data ingress scheduled load to vacuum this data into ServiceNow.
contained in update sets 2013/02/28 - 3, and 2013/03/04 - 1. These update sets have been moved to TEST and sent to testing.
there is manual maintenance after applying these update sets; must manually fixup the midserver and Oracle instance to match the SN INSTANCE where the update sets are being applied.

~~Deliverable will be that when we hover over the ORG for a user, we will see the LeadAdmin and OpsMgr for this ORG.~~

68 Catalog Item: Pager: Delete
update set: 2013/03/20 - 1
advanced to TEST, errors: 8, force committed them
status: UAT-ed in TEST, ready for Hari
hidden from end users until START launch. Must access from direct URL: https://yaletest.service-now.com/com.glideapp.servicecatalog_cat_item_view.do?sysparm_id=b5f54d246d90c90094adafb37e1f45ff

requirements advanced to PROD for Start replacement

June ??, 2014 release, the crawl release

update sets (8)

June ??, 2014 (May 21, 2014 tentatively, this is the never-launched 2014-04-24 release with R780, R812, R1147 removed)

update sets:

Manual deploy:

Apr 24, 2014 (originally, then release cancelled. Release reduced, and scheduled for May 14, 2014, now cancelled again; building a new listing because so much has changed)

update sets:

Feb 21, 2014

update sets:

manual deploy:

Dec 13, 2013

update sets:

Nov 29, 2013

update sets:

Manual deploy:

Nov 22, 2013

Update set list:

Nov. 15, 2013

Nov. 8, 2013

Aug 23, 2013

July 26, 2013

June 21, 2013

June 3, 2013

May 17, 2013

May 4, 2013

April 12, 2013

March 2013