SCCM report for MachineName_Make_Model_Architecture_Username_RAM

Below Report provides;

-          Machine name

-          Manufacturer

-          Model Architecture

-          User name and Memory size

***********************************************************

SELECT    v_GS_COMPUTER_SYSTEM.Name0 AS [Machine Name],

v_GS_COMPUTER_SYSTEM.Manufacturer0 AS Manufacturer, v_GS_COMPUTER_SYSTEM.Model0 AS Model,

v_GS_COMPUTER_SYSTEM.SystemType0 AS Architecture, v_GS_COMPUTER_SYSTEM.UserName0 AS Username,

          v_GS_PHYSICAL_MEMORY.Capacity0 AS [RAM Size]

FROM      v_GS_COMPUTER_SYSTEM

INNER JOIN v_GS_PHYSICAL_MEMORY ON v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_PHYSICAL_MEMORY.ResourceID

************************************************************
More SCCM custom reports can be found here