How to export OnCall data from the DB

With this little SQL query you will be able to export OnCall data from the Enterprise Alert SQL database:

WITH OnCallUsers AS (
    SELECT 
        t1.ADRNAME,
  t1.ADRPAGER,
        t1.ADREMAIL,
  t4.TeamDisplayName,
        ROW_NUMBER() OVER (PARTITION BY t2.OnCallPlanID ORDER BY t3.HIERARCHY ASC) AS rn
    FROM [EnterpriseAlert].[dbo].[MMPROFILES] t1
    JOIN [EnterpriseAlert].[dbo].[OnCallPlanUsers] t2 ON t1.ID = t2.ProfileID
    JOIN [EnterpriseAlert].[dbo].[OnCallPlanShifts] t3 ON t2.ID = t3.OnCallPlanUserID
  JOIN [EnterpriseAlert].[dbo].[TeamOnCallPlans] t4 ON t2.OnCallPlanID = t4.OnCallPlanID
    WHERE t1.PROFStatus = 0 AND GETDATE() BETWEEN t3.datestart AND t3.dateend
)
SELECT *
FROM OnCallUsers
WHERE rn = 1;

Just modify for your needs.