Need report on users adding themselves in and out of on call via their group record

[SREEVES]

We have a field on the sys_user_grmember table called on call where users can add them in and out of "on call".  This was the method we used to use for scheduling on call prior to the new options and we still have some teams that use it.  We have a request to run a report of when a user added themselves in and out of on call by changing the value from false to true.   

I have searched for any way to run this and have yet to find any way to do it so I thought I would see if any of you have any thoughts on ways to possibly report on it. 

[Gurpreet07 · Accepted solution]

Hi, This can be achieved in two ways

1. Enable audit for sys_user_grmember  table and configure a report with appropriate filters 

https://docs.servicenow.com/bundle/vancouver-platform-security/page/administer/security/task/t_Enabl...

https://docs.servicenow.com/bundle/vancouver-platform-security/page/administer/security/concept/c_Un...

2. Create a custom table to track the changes to the field. Use a business rule to create / update a log of the change done on the sys_user_grmember  table and then configure a report on the custom table.