Automate change request with change tasks creation for monthly patching activities

[Arjun Reddy Yer]

required help @Vasantharajan N @Ankur Bawiskar @Voona Rohila @WillieW @RaghavSh 

As I need to automate the standard change request creation every 2nd Friday of the month for the change templates that I have with me along with that change tasks also need to create and those change tasks need to auto assign to assignment groups that I have with 

Short Description: [assignment_group] Microsoft Patching

Description: New Microsoft patches installed

Change Template:

1. Monthly Microsoft Patching

2. Monthly PMPC Patching

Assignment Groups:

1. Supply Chain Engineering
2. Corporate Engineering
3. Digital Engineering

[Ankur Bawiskar]

@Arjun Reddy Yer 

you can create scheduled job which runs daily and it will check if today is 2nd Friday of mont

this you can check in condition of scheduled job

once condition becomes true you can write sample script below

answer = false;
var gdt = new GlideDateTime();

// 1 is Monday and 5 is Friday

if ((gdt.getDayOfMonthLocalTime() >= 8 && gdt.getDayOfMonthLocalTime() <= 14) && (gdt.getDayOfWeekLocalTime() == 5)) {

    answer = true;

}

Script below

(function() {
    var templateName = 'your_standard_change_template'; // Replace with your template name
    var assignmentGroup = 'Microsoft Patching'; // Replace with your assignment group

    var change = new GlideRecord('change_request');
    change.initialize();
    change.type = 'standard'; // Ensure the change type is standard

    change.assignment_group.setDisplayValue(assignmentGroup);

    // Apply the template
    if (change.applyTemplate(templateName) == 0) {
        gs.info('Template applied successfully to change request');
    } else {
        gs.info('Failed to apply template');
    }

    // Insert the change request
    var changeSysId = change.insert();
    gs.info('Standard change request created: ' + changeSysId);

    // add logic here to create change tasks

})();

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏