Query has NetObjectID = 1 as an example, simply replace with the node id necessary (or adjust as needed to show all data).
SELECT n.Caption ,p.PollerID ,p.PollerType ,p.Enabled ,p.NetObjectID FROM Orion.Pollers AS p INNER JOIN Orion.Nodes AS n ON n.NodeID = p.NetObjectID AND p.NetObjectType = 'N' AND p.Enabled = 1 INNER JOIN Orion.DeviceStudio.PollerAssignments AS d ON d.NetObjectID = n.NodeID AND d.NetObjectType = 'N' AND d.Enabled = 1 WHERE p.NetObjectID = 1 UNION ALL ( SELECT n.Caption ,d.ID AS [PollerID] ,dt.Name AS [PollerType] ,d.Enabled ,d.NetObjectID FROM Orion.DeviceStudio.PollerAssignments AS d INNER JOIN Orion.Nodes AS n ON d.NetObjectID = n.NodeID AND d.NetObjectType = 'N' AND d.Enabled = 1 INNER JOIN Orion.DeviceStudio.Pollers AS dp ON dp.PollerID = d.PollerID INNER JOIN Orion.DeviceStudio.Technologies AS dt ON dt.TechnologyID = dp.TechnologyID WHERE d.NetObjectID = 1 )