On-Call Schedule Dashboard
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2014 12:07 PM
We recently implemented the On-Call Rotation application in our instance to replace the a spreadsheet that was kept by the IT managers on SharePoint. At first everyone loved the idea of an automated on-call rotation and that it would be available in the cloud for easier access. Shortly after being rolled out though the management team realized they would need to pull the Rotation Schedule Report each time they wanted to see who was on-call. As a solution to making this easier it was suggested that a Dashboard be created for all On-Call groups for the current week. This sounded 'tall good and easy, until I went to look into it and realized that the Rotation Schedule Report isn't a normal report, but a UI Page that generates the report on the fly. From what I can tell the report is generated based off of the v_rotation table which is only populated from that UI Page.
Has anyone come across this or can help me figure out how to create a dashboard to replace having to generate the report using the UI Page? It just needs to be the current week and all the On-Call groups?
- Labels:
-
User Interface (UI)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2014 12:29 PM
There's the Calendar report that shows a calendar view of the on-call schedule.
It's hacky but what if you embed show_schedule.do?sysparm_type=roster&sysparm_include_view=weekly into a content block and added that to a dashboard? Then you'd get a nice graphical calendar every time you pull up the dashboard. Would be prettier than looking through a List.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2014 01:09 PM
I'll try and and see how it works out. The advantage of the List though is it shows everyone's contact number, thanks for the suggestion though.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2014 12:16 PM
Thank you Jon, that was a great idea.
Added the iframe content block and created a dashboard that runs only the on-call roster.
I wish we could get all the groups to display on one page, but this works for now.
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2014 01:14 PM
Well I answered my own question set up a block for formatted using https://uams.service-now.com/schedule_formatted_report.do?sysparm_groups=3dae2374399905009e7959ab704... for the code block and now i have a formatted table and a calendar view that i can select the group on the dashboard as well.
