Feb 20, 2014

...

R1199

R1199 was originally completed in February 2014 in DEV, and was part of the April release. It became absolutely needed in PROD, as the midserver kept breaking and we didn't know until users told us it broke. Committed it into PROD out-of-band April 23, 2014. It has become indispensible. Committing it out of band after the April release was delayed was absolutely the right choice.

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
• 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
• D827, D828, R788  SDR form: 2013/12/10 - 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, R1034 - 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
• D1055: Wordpress Site Request: State for the request is not set to Closed complete. 2014/06/12 - 5
• D1056: Data Center IP Request: State is not set to Closed complete. 2014/06/12 - 6
• D1057: Deploy Webfarm Request: Item state field and State field on the RITM Screen does not have expected values. 2014/06/12 - 7
• D1058: Drupal Deployment form: Item State and State do not hold the values of 'Closed' and Closed Complete respectively. 2014/06/13 - 1
• D1059: Drupal Migration Form: RITM Item State value is New and State Value is Open. 2014/06/13 - 2
• D1060: Lunch and Learn Request: State for the Request form is not set to Closed Complete. 2014/06/13 - 3
• D1061: Software Library Addition Change form: Item State and State have the values New and Open respectively on the RITM form 2014/06/13 - 4
• D1062: Software Deployment Request form: Item State is New and State of RITM is Open respectively. 2014/06/17 - 1
• D1064: Internal ITS Request: Item State still New when SCTASK complete 2014/06/25 - 1

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 - 2
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/04 - 6
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 

Manual deploy:

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);

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, R788  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, R1034 - 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 

Manual deploy:

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);

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

...

• 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. 

...