pushnotificaitonreport.sql

SELECT
    P.Id,
    P.FirstName,
    P.LastName,
    P.Email
FROM
    [Person] P
JOIN [PersonAlias] PA
    ON PA.PersonId = P.Id
JOIN [PersonalDevice] PD
    ON PD.PersonAliasId = PA.Id
WHERE
    EXISTS (
        SELECT Id
        FROM [PersonalDevice] PDA
        WHERE PDA.PersonAliasId = PA.Id
        
    )
Group By
    P.Id,
    P.FirstName,
    P.LastName,
    P.Email