Create a Blackout Calendar in Data Visualizations

dwerner
Kilo Sage
  Hi there. I am trying to create a blackout calendar in Data Visualizations but I'm not having much luck and I could use some help.
  Here is the configuration for the Data Visualization:
 
data_v_01.png
data_v_02.png
 
  I created this Blackout Schedule (cmn_schedule_blackout):
 
data_v_04.png
 
  And contained within the Blackout Schedule is this Schedule Entry (cmn_schedule_span):

data_v_03.png

 
  I have referenced these links for creating the calendar, but they have not helped:
 
 
  I have tried using the cmn_schedule_span and cmn_schedule_blackout tables in the Table field in the Data Visualization configuration but neither works.  
  I am on Zurich Patch 8.  Any help you can provide would be greatly appreciated.
 
Thank you,
Dustin
3 REPLIES 3

Tanushree Maiti
Tera Patron

Hi @dwerner 

 

Check this :

How to create Calendar Report on Blackout Schedules with start and end schedule time 

https://www.servicenow.com/community/itsm-forum/how-to-report-on-blackout-and-maintenance-schedules/...

https://www.youtube.com/watch?v=ARXhKogczYg

Blackout & Maintenance Schedules in a nutshell

Please Accept the solution if it assisted you with your question & Mark this response as Helpful.
Regards
Tanushree Maiti
ServiceNow Technical Architect
LinkedIn: https://www.linkedin.com/in/tanushreemaiti

dwerner
Kilo Sage

Hi Tanushree.  Thank you for replying to my message.  My user found someone who knows a lot more about dashboards than I do and they were able to help them get the blackout calendar set up.  I don't know exactly what was done to solve the issue, but I will find out and when I do I will post it here.

 

Thanks,
Dustin

Dr Atul G- LNG
Tera Patron

Hi @dwerner 

I created a report for the same and I’m able to see my blackout schedule.

You cannot add two tables in a single report/query at the same time.

 

DrAtulGLNG_0-1779949033294.png

 

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************