SELECT
inf.affinity_type AS [AffinityType],
nd.node_state_desc AS [NodeStateDesc],
mnd.memory_node_id AS [ID],
nd.processor_group AS [GroupID],
nd.cpu_affinity_mask AS [CpuIds],
nd.online_scheduler_mask AS [CpuAffinityMask]
FROM
sys.dm_os_memory_nodes AS mnd
INNER JOIN sys.dm_os_sys_info AS inf ON 1=1
INNER JOIN (SELECT SUM (cpu_affinity_mask) AS cpu_affinity_mask,
        SUM(online_scheduler_mask) AS online_scheduler_mask,
        processor_group,
        node_state_desc,
        memory_node_id
        FROM sys.dm_os_nodes
        GROUP BY memory_node_id, node_state_desc, processor_group) AS nd ON nd.memory_node_id = mnd.memory_node_id
ORDER BY ID ASC