Inventory of Video Card details

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 = 'ACPI\Processor'
    and VC.Name0 != 'ConfigMgr Remote Control Driver'