On-Call Scheduling get On-call members and their working time

Anoushka99
Tera Contributor

In the on-call scheduling module, I have a requirement to get the data of all the on-call persons and their shift timings depending on the group.

Ex: Group A has 1 member and that member works from 9:00 AM to 5:00 PM on weekdays. 

I need the start and end times of all the members in a particular group.

Note: There is one table On-Call Hours (st_on_call_hour) which fulfills my requirements but no data gets stored in this table.

 

Thank You for your help

3 REPLIES 3

Community Alums
Not applicable

Hi @Anoushka99 ,

When you follow the doc, the "Group" field would determine your requirement.

https://docs.servicenow.com/en-US/bundle/utah-it-service-management/page/administer/on-call-scheduli...

 

Anoushka99
Tera Contributor

Hello Sandeep,

 

Thank you for this, but I am looking for something a little more than that

Is there any way I can get that data in JSON format or in an Excel file

Is there a table where all these values are stored?

I'm struggling with the same thing. Found the script include that generates data for that table, but have been unable to find anything that calls it. Especially as it is server-side only. There has to be a query business rule or something of that nature that triggers on any search for that table to generate the data.