Add Non-Change Events to Change Calendar

[mikecline83]

Hello,

Our company's CAB uses the calendar view on the Change Overview dashboard to go over the week's upcoming Changes. The CAB has requested that we start adding major events to the Change calendar that would potentially be effected by those scheduled Changes. As of right now, they are being added by creating an RFC that contains the event info even though there is no "change" happening. The SN Admins don't believe that this is the most effective way to accomplish what they want but also don't know a better way. I was wondering if any other companies out there have run into a similar problem or have any ideas?

TAI,

--Mike and eric.gauthier

[john_becu]

Hi Joe, So lets say we wanted to show Holidays on the change calendar, how would one go about adding those events into the calendar so the holiday would at the least show up in the appropriate day in the calendar report, even better could one format the day on the calendar report to display differently, Different color with a label perhaps, so the holiday stands out on the calendar and reminds CAB to take the day into consideration.

Then in scenario 2, if we have Business Events that affect usage patterns on our CI etc. You are suggesting that we create a schedule to add all those events and then expose that to the Change Calendar by modifying the 'Maintenance Windows and Changes' entry?

Thanks for your help

[Joe McCarty1]

I don't believe you change the background of the day.   The following change to the maintenance windows and changes scheduled page shows how you can have holidays, changes, blackout and maintenance windows all in the same calendar (and any other type of schedule you decide to add).

The Calendar Server Ajax Processor field should be modified with the commented lines below:

var g = new GlideRecord('cmn_schedule');
   g.addQuery('name', 'application');
   g.query();

   while (g.next()) {
   schedulePage.addSchedule(g.sys_id, '#808080', null, true);
   }

   g.initialize();
   g.addQuery('name', 'server');
   g.query();

   while (g.next()) {
   schedulePage.addSchedule(g.sys_id, '#73A8F0', null, true);
   }

   g.initialize();
   g.addQuery('type', 'blackout');
   g.query();

   while (g.next()) {
   schedulePage.addSchedule(g.sys_id, '#F00', null, true);
   }

   g.initialize();
   g.addQuery('name', 'network');
   g.query();

   while (g.next()) {
   schedulePage.addSchedule(g.sys_id, '#FF6600', null, true);
   }
   /*Add holiday schedules (must set type on holiday schedule record)*/
   g.initialize();
   g.addQuery('type', 'holiday');
   g.query();

   while (g.next()) {
   schedulePage.addSchedule(g.sys_id, '#000000', null, true);
   }


   /*Add maintenance schedules not explicitly named */
   g.initialize();
   g.addQuery('type', 'maintenance');
   g.query();

   while (g.next()) {
   schedulePage.addSchedule(g.sys_id, '#00FF00', null, true);
   }

   gr = new GlideRecord('change_request');
   gr.query();
   while (gr.next()) {
   var start = gr.start_date.getDisplayValue();
   var end = gr.end_date.getDisplayValue();
   var item = schedulePage.addItem(gr, start, end, '', '#318047'); 
   if (item) {
   item.setDescription(gr.short_description.toString());
   }
   }

Then you can visit the calendar view at https://<your instance>/show_schedule.do?sysparm_type=maint which should show something like this:

The OOB holiday calendar is an 'Exclusion' type calendar and so they always show up as Gray (Notice Cinco De Mayo in on Friday May 5).   If you wanted to specify a color, you'd need to have a holiday calendar that isn't the exclusion type which is certainly doable.

Hope this helps.

[Karlie]

Hi! Sorry to bring up an old topic, but we have this working in our Jakarta instance for a calendar that shows planned outages, maintenance, and our holidays. We noticed in Kingston there is a new UI for the calendars but this didn't effect our current calendar we created. Do you know how I can use that new UI with this? Thanks.

[Henrik Jutterst]

Hi and thanks for the post. I was really looking for a way to filter out some data from the show_schedule.do?sysparm_type=maint page and your post here helped me to solve it. Thanks for keeping the community alive with good information!

Kind regards
/Henrik