How Does ServiceNow Identify Who Owns a Schedule in the cmn_schedule Table?

[humza_abdullah]

Hello everyone,

I am working with the cmn_schedule & cmn_schedule_span table in ServiceNow and am trying to understand how the system identifies which user a particular schedule belongs to.

My goal is to create a catalog item that allows managers to schedule off times for their workers. For this, I need to know how the schedules in these tables are linked to specific users.

Any help will be appreciated.

Thanks.

[humza_abdullah]

Never mind I found it.
I needed to look in the sn_csm_service_organization_external_staff table theres a Schedule Reference field.
Thanks 

[humza_abdullah]

Never mind my never mind.

That field is also all blank for some reason

[humza_abdullah · Accepted solution]

For anyone in the future looking for the answer I finally found it.

agent_events.list

Your welcome.