Tables that hold current on-call info
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-30-2018 01:50 PM
I have a need to get all of the people who are on-call at a given moment in time. If I have 11 rotations for example and only one person is on-call at any moment in time I would want to get 11 records.
I would prefer to select the data from tables. It looks like "SCHEDULE ENTRY" might have some of the information I need. Or it might be "ROSTER SCHEDULE ENTRY" but neither of these tables even give me all of the information (I know I need to get additional data from GROUPS, USER, etc) but where/how would I get those 11 records. Can someone help me out and point me the way? Thanks.
- Labels:
-
Service Level Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-21-2024 10:03 PM
Hi did you find solution for this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-22-2024 06:10 AM
Yes and no but I have a solution that works for me - I get the active shifts from the Shift table then for each shift, call:
https://xxx.service-now.com/api/now/on_call_rota/whoisoncall?rota_ids= <sys_id for shift>
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-04-2025 08:52 AM
Hi,
Please refer to the "v_rotation" table, which contains the list of all current on-call members.
