SMSUG.ca

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

Garth Jones

April 2013 - Posts

  • Video card with Sound card.

    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',
        Sound.Description0 as 'Sound card'
    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 dbo.v_GS_SOUND_DEVICE Sound on Sound.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' 
  • 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' 
  • Video Card details

    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', 
        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'
  • Find all webcam - SQL

    Use this query to find all webcam – SQL reports

    select 
        CS.Name0, 
        SD.Name0,
        SD.DeviceID0
    from 
        dbo.v_GS_COMPUTER_SYSTEM CS
        join dbo.v_GS_SYSTEM_DEVICES SD on CS.ResourceID = SD.ResourceID
    Where 
        SD.Name0 like '%Webcam%'
  • Find all webcam – WQL

    Use this WQL query to find all webcam

    http://social.technet.microsoft.com/Forums/en-US/configmgrai/thread/fa5fcfe2-69ef-4482-adfc-de25d6d19669/?prof=required

    select 
        SMS_R_System.Name, 
        SMS_G_System_SYSTEM_DEVICES.Name, 
        SMS_G_System_SYSTEM_DEVICES.DeviceID 
    from  
        SMS_R_System 
        inner join SMS_G_System_SYSTEM_DEVICES on SMS_G_System_SYSTEM_DEVICES.ResourceID = SMS_R_System.ResourceId 
    where 
        SMS_G_System_SYSTEM_DEVICES.Name like "%webcam%"
    .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, "Courier New", courier, monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } .csharpcode .kwrd { color: #0000ff; } .csharpcode .str { color: #006080; } .csharpcode .op { color: #0000c0; } .csharpcode .preproc { color: #cc6633; } .csharpcode .asp { background-color: #ffff00; } .csharpcode .html { color: #800000; } .csharpcode .attr { color: #ff0000; } .csharpcode .alt { background-color: #f4f4f4; width: 100%; margin: 0em; } .csharpcode .lnum { color: #606060; }

This Blog

Syndication

News

Training

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