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
10-31-2018 04:56 AM
Use Schedule Report module under On-Call. Add your groups, it will show you comprehensive list of users on-call. They filter Start and End dates by datetime.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-31-2018 05:49 AM
I really don't believe that I can. I am creating a Microsoft Flow using the ServiceNow connector so I believe that I am limited to the tables surfaced there. The data from that report is what I am looking for - I just need to know the source tables.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-31-2018 07:03 AM
Correct, it's not a table as the report is built on the fly and not stored in the table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-31-2018 07:09 AM
But the data is stored somewhere. I'm just hoping to find the "where". Thanks again.
