SCCM Machine name with OS and bit value report

SQL Query:

SELECT        dbo.v_GS_SYSTEM.Name0, dbo.v_GS_SYSTEM.SystemType0, dbo.v_GS_OPERATING_SYSTEM.Caption0

FROM            dbo.v_GS_SYSTEM INNER JOIN

                         dbo.v_GS_OPERATING_SYSTEM ON dbo.v_GS_SYSTEM.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID