For full details see the forum post: https://www.myitforum.com/forums/Query-to-report-Machines-Platform-information-m235322.aspx

 

Select 
  Name0,
  SystemType0
From
  dbo.v_GS_SYSTEM