...your virtual communITy
Welcome to Sign in | Join | Help
in Search

Garth Jones

Video Card details

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



Video Card details | My CMS said:

Pingback from  Video Card details | My CMS

June 10, 2013 5:40 PM

This Blog




Powered by Community Server (Non-Commercial Edition), by Telligent Systems