SCRIPT: How to check Replication subscribtion type?

 USE distribution;
GO
 
SELECT
    da.publisher_db,
    da.publication,
    da.subscriber_name       AS subscriber,
    da.subscriber_db,
    CASE da.subscription_type
         WHEN 0 THEN 'Push'
         WHEN 1 THEN 'Pull'
         ELSE 'Unknown'
    END                      AS subscription_type,
    da.local_job,            -- 1=agent job runs here (Distributor), typical for Push
    da.name                  AS agent_job_name
FROM dbo.MSdistribution_agents AS da
WHERE subscriber_db <> 'virtual'
ORDER BY da.publisher_db, da.publication, da.subscriber_name;