SQL Query to get the no of employees assigned a Work Schedule Assignment Administration
SELECT DISTINCT SCHEDULE_NAME, SCHEDULE_TYPE_CODE , ASSIGNMENT_NUM FROM FUSION.ZMM_SR_SCHEDULES_VL WHERE SCHEDULE_NAME LIKE '%Provide your workschedule name here%'