For full details please see
select distinct R.Netbios_Name0 as 'Name', R.User_Name0 as 'User', CS.Manufacturer0 as 'Manufacturer', CS.Model0 as 'Model', BIOS.SerialNumber0 as 'Serial', SD.Name0 as 'Processor', RAM.TotalPhysicalMemory0 as 'Memory', VC.Name0 as 'Video Card', Convert(VarChar, VC.AdapterRam0 / 1024) + ' MB' as 'Video Card RAM' from dbo.v_R_System R inner join dbo.v_GS_X86_PC_MEMORY RAM on RAM.ResourceID = R.ResourceId inner join dbo.v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = R.ResourceID inner join dbo.v_GS_PC_BIOS BIOS on BIOS.ResourceID =R.ResourceId inner join dbo.v_GS_SYSTEM_DEVICES SD on SD.ResourceID = R.ResourceId inner join dbo.v_GS_Video_Controller VC on R.ResourceID = VC.ResourceID where SD.CompatibleIDs0 = 'ACPIProcessor' and VC.Name0 != 'ConfigMgr Remote Control Driver'