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:
- Supply Chain Engineering
- Corporate Engineering
- Digital Engineering
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! 🙏
