How to report on blackout and maintenance schedules

[RobinR1]

I have seen several topics on creating blackout schedules, and turning on various modules to view them,   

However, I want to be able to report on them.  There does not seem to be a way to develop reports on schedule_entry table and develop your own reports on schedules of the Blackout type, Maintenance type, etc. to publish for end user usage in planning their changes.

How do you report on / publish a view for blackout and maintenance schedules?  I need to provide filtered content for others to view. 

[sachin_namjoshi]

Please check blog below which lists tables used in blackout and maintenance schedules.

You can report on these tables.

https://community.servicenow.com/community?id=community_blog&sys_id=e30d6ea5dbd0dbc01dcaf3231f96190d

Regards,

Sachin

[RobinR1]

thanks, Sachin!  I reviewed that article and it is very helpful for setup and administrative purposes.  However, I can still not write my own reports on the tables involved.  Here are some challenges: 

The Cmn_schdule_span table entries have Start Date Time values that will not appear on a calendar-formatted report.

The cmn_schedule_span.Start date time cannot be referenced in date filtering such as 'greater than today' , etc.   It appears to function as a text field.

Is the cmn_schedule_span.Start Date Time meant to be available as a date-time field for reporting?  Perhaps ours is defined wrong? (we are on the London version).

Many thanks

[gautamsk]

Hello @RobinR ,

I also have the same requirement  in my company i.e to run calendar report on blackout schedules. Were you able to find a solution for the above requirement?

Thanks

Gautam

[MikkelJ]

Hi Robin

In case this is still relevant, i have made solution that you or others may benefit from. 

Start date time and end date time are Schedule Date Time data types. These are automatically populated when dates are entered into the date range selector.

Do the follwing:
1. Create a new Date/time column on the cmn_schedule_span table named "Calender start date span". The technical name should be u_my_start_date. 

2. Create a new Date/time column on the cmn_schedule_span table named "Calender end date span". The technical name should be u_my_end_date. 

Create a business rule on the cmn_schedule_span table, set it to run before, and trigger when

End date changes or start date time changes. 

Use the following script: 

(function executeRule(current, previous /*null when async*/) {

current.u_my_start_date = current.start_date_time.getDisplayValue();
current.u_my_end_date = current.end_date_time.getDisplayValue();
})(current, previous);

This way, the Date time fields will always be populated with values when new records are crated. When making your calender report, report on the field "Calender start date span".