SMSUG.ca

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

Garth Jones

Video Card Details v2

For full details please see

http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c42ba8cf-02a5-4e2e-8d20-39b05a4a5740

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', 
    VC.VCRam 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 
    left outer join (
        select     
            VC.ResourceID,
            VC.Name0,
            Convert(VarChar, VC.AdapterRam0 / 1024) + ' MB' as 'VCRAM'
        from 
            dbo.v_GS_Video_Controller VC 
        Where
            VC.Name0 != 'ConfigMgr Remote Control Driver'
            and VC.AdapterRam0 is not null) VC on  R.ResourceID = VC.ResourceId 
where 
    SD.CompatibleIDs0 = 'ACPI\Processor' 

Comments

 

Video Card Details v2 | My CMS said:

Pingback from  Video Card Details v2 | My CMS

June 10, 2013 5:40 PM

This Blog

Syndication

News

Training

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