none
All video cars in a specific collection..?

    Question

  • Hi guys,

    I need to create a simple query in SCCM 2007...this query will show the video cards models in one selected collection.

    I was looking for information and i didn´t find anything...some help? please! ^^


    • Edited by Laref Monday, April 15, 2013 10:09 AM
    Monday, April 15, 2013 10:08 AM

Answers

All replies

  • This SQL query will gather video card memory information in Kilobytes (Kb) for the machines in your database.

    SQL Query:

    Select
    SD.Name0 'Machine Name',
    VC.Name0 'Video Card',
    Convert(VarChar, VC.AdapterRam0 / 1024) + ' MB'

    From v_R_System SD
    Join v_Gs_Video_Controller VC on SD.ResourceID = VC.ResourceID

    Where VC.Name0 <> 'ConfigMgr Remote Control Driver'
    Order By SD.Name0



    check if this could be help you


    Sharad Singh | My blogs: SharadTech | Twitter: @SinghSharaad | | Please remember to click “Mark as Answer” on the post that helps you.This can be beneficial to other community members reading the thread.

    Monday, April 15, 2013 10:18 AM
  • Thanks SinghSharad,

    I need to put the video card query in this report that i had created:

    select distinct 
    v_R_SYSTEM.Netbios_Name0 as Name,
    v_R_System.User_Name0 as User,
    v_GS_COMPUTER_SYSTEM.Manufacturer0 as Manufacturer, 
     v_GS_COMPUTER_SYSTEM.Model0 as Model,
     v_GS_PC_BIOS.SerialNumber0 as Serial,
    v_GS_SYSTEM_DEVICES.Name0 as Processor, 
    v_GS_X86_PC_MEMORY.TotalPhysicalMemory0 as Memory
    from  v_R_System inner join v_GS_X86_PC_MEMORY 
    on v_GS_X86_PC_MEMORY.ResourceID = v_R_System.ResourceId inner join v_GS_COMPUTER_SYSTEM 
    on v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System.ResourceID inner join v_GS_PC_BIOS
    on v_GS_PC_BIOS.ResourceID =v_R_System.ResourceId inner join v_GS_SYSTEM_DEVICES
    on v_GS_SYSTEM_DEVICES.ResourceID = v_R_System.ResourceId where 
    v_GS_SYSTEM_DEVICES.CompatibleIDs0 = 'ACPI\Processor'

    Can you help me?

    Thank you very much!

    Monday, April 15, 2013 10:35 AM
    • Proposed as answer by SinghSharad Monday, April 15, 2013 12:20 PM
    Monday, April 15, 2013 11:39 AM
    Moderator
  • select distinct
    v_R_SYSTEM.Netbios_Name0 as Name,
    v_R_System.User_Name0 as User,
    v_GS_COMPUTER_SYSTEM.Manufacturer0 as Manufacturer,
     v_GS_COMPUTER_SYSTEM.Model0 as Model,
     v_GS_PC_BIOS.SerialNumber0 as Serial,
    v_GS_SYSTEM_DEVICES.Name0 as Processor,
    v_GS_X86_PC_MEMORY.TotalPhysicalMemory0 as Memory
    Convert(VarChar, VC.AdapterRam0 / 1024) + ' MB' as 'Video Card RAM'
    from 
    v_R_System inner join v_GS_X86_PC_MEMORY
    on v_GS_X86_PC_MEMORY.ResourceID = v_R_System.ResourceId inner join v_GS_COMPUTER_SYSTEM
    on v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System.ResourceID inner join v_GS_PC_BIOS
    on v_GS_PC_BIOS.ResourceID =v_R_System.ResourceId inner join v_GS_SYSTEM_DEVICES
    on v_GS_SYSTEM_DEVICES.ResourceID = v_R_System.ResourceId
    where
    v_GS_SYSTEM_DEVICES.CompatibleIDs0 = 'ACPI\Processor'

    Sharad Singh | My blogs: SharadTech | Twitter: @SinghSharaad | | Please remember to click “Mark as Answer” on the post that helps you.This can be beneficial to other community members reading the thread.

    • Proposed as answer by SinghSharad Monday, April 15, 2013 12:20 PM
    Monday, April 15, 2013 12:20 PM
  • Thanks Garth, i have used your link, and the results are duplicated...do you know why?

     BEBRM009   50126   Dell Inc.   Latitude D610   88ZMY1J   Intel(R) Pentium(R) M processor 1.73GHz   2088304   Mobile Intel(R) 915GM/GMS,910GML Express Chipset Family   
     BEBRM009   50126   Dell Inc.   Latitude D610   88ZMY1J   Intel(R) Pentium(R) M processor 1.73GHz   2088304   Mobile Intel(R) 915GM/GMS,910GML Express Chipset Family   128 MB 

    We are very close!! thank you!!

    Monday, April 15, 2013 12:36 PM
  • select distinct
    v_R_SYSTEM.Netbios_Name0 as Name,
    v_R_System.User_Name0 as User,
    v_GS_COMPUTER_SYSTEM.Manufacturer0 as Manufacturer,
     v_GS_COMPUTER_SYSTEM.Model0 as Model,
     v_GS_PC_BIOS.SerialNumber0 as Serial,
    v_GS_SYSTEM_DEVICES.Name0 as Processor,
    v_GS_X86_PC_MEMORY.TotalPhysicalMemory0 as Memory
    Convert(VarChar, VC.AdapterRam0 / 1024) + ' MB' as 'Video Card RAM'
    from 
    v_R_System inner join v_GS_X86_PC_MEMORY
    on v_GS_X86_PC_MEMORY.ResourceID = v_R_System.ResourceId inner join v_GS_COMPUTER_SYSTEM
    on v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System.ResourceID inner join v_GS_PC_BIOS
    on v_GS_PC_BIOS.ResourceID =v_R_System.ResourceId inner join v_GS_SYSTEM_DEVICES
    on v_GS_SYSTEM_DEVICES.ResourceID = v_R_System.ResourceId
    where
    v_GS_SYSTEM_DEVICES.CompatibleIDs0 = 'ACPI\Processor'

    Sharad Singh | My blogs: SharadTech | Twitter: @SinghSharaad | | Please remember to click “Mark as Answer” on the post that helps you.This can be beneficial to other community members reading the thread.

    thanks for the correction Sigh, but it doesn´t work:

    "[42000][156]...Incorrect syntax near the keyword 'User'.

    Monday, April 15, 2013 12:40 PM
  • May i guess Here One is Showing RAM 128 MB another one is null ,so it treat as unique..

    Narahari

    Monday, April 15, 2013 12:53 PM
  • May i guess Here One is Showing RAM 128 MB another one is null ,so it treat as unique..

    Narahari


    You guess is correct. For whatever reason this PC is showing that it has BOTH 128MB and NULL for Video RAM.

    http://www.enhansoft.com/


    Monday, April 15, 2013 1:57 PM
    Moderator
  • ok...but what´s wrong?

    I have this report:

    select distinct 
    v_R_SYSTEM.Netbios_Name0 as Machine,
    v_R_System.User_Name0 as User,
    v_GS_COMPUTER_SYSTEM.Manufacturer0 as Manufacturer, 
     v_GS_COMPUTER_SYSTEM.Model0 as Model,
     v_GS_PC_BIOS.SerialNumber0 as Serial,
    v_GS_SYSTEM_DEVICES.Name0 as Processor, 
    v_GS_X86_PC_MEMORY.TotalPhysicalMemory0 as Memory
    from  v_R_System inner join v_GS_X86_PC_MEMORY 
    on v_GS_X86_PC_MEMORY.ResourceID = v_R_System.ResourceId inner join v_GS_COMPUTER_SYSTEM 
    on v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System.ResourceID inner join v_GS_PC_BIOS
    on v_GS_PC_BIOS.ResourceID =v_R_System.ResourceId inner join v_GS_SYSTEM_DEVICES
    on v_GS_SYSTEM_DEVICES.ResourceID = v_R_System.ResourceId where 
    v_GS_SYSTEM_DEVICES.CompatibleIDs0 = 'ACPI\Processor'

    It´s show 5463 computers...and I need to join to this report the videocards and soundcards of all the computers....and when Im trying in differents reports I obtained less computers¿? :( i'm very confused...sorry...

    sorry for my english:( 

    Monday, April 15, 2013 2:12 PM
  • I have located the problem...if I exclude the driver 'config manager...'of the query there are a lot of computers with this driver only, and other computers with this driver and his own driver.

    And this is the problem... :(

    Monday, April 15, 2013 2:59 PM
  • I'm getting confused, Which query are you playing? Are you using the query that I posted to my blog or the one above?

    http://www.enhansoft.com/

    Monday, April 15, 2013 3:05 PM
    Moderator
  • Sorry for the confusion.

    Im making test with both.

    The problem are my computers...i have a lot of machines with the 'standar vga driver' and when I used remote tools with these computers this driver is replace with the 'configmgr remote control driver' example:

    Report Name: Video card information for a specific computer
    Category: Hardware - Video Card
    Comment: Displays summary information about the video cards on a single computer
    Parameters:
    Computer Name SUC0125

    4/15/2013 5:28:50 PM       (Number of Records: 1)

     SUC0125   ConfigMgr Remote Control Driver   4.00.6163.1000   vga.sys,framebuf.dll,vga256.dll,vga64k.dll   VideoController1   32   1024   768   1 


    If I execute the query excluding the 'sccm driver' i lost these computers...and if I include the sscm driver I obtain duplicated computers, like this:

    Report Name: Video card information for a specific computer
    Category: Hardware - Video Card
    Comment: Displays summary information about the video cards on a single computer
    Parameters:
    Computer Name SUC0125C01
     Video card information for a specific computer

    4/15/2013 5:24:31 PM       (Number of Records: 2)

     SUC0125C01   ConfigMgr Remote Control Driver   4.00.6163.1000   igxprd32.dll   VideoController1   32   1024   768   60 

     SUC0125C01   Intel(R) Q35 Express Chipset Family   6.14.10.5016     VideoController2         

    Thank you very much for your help!





    • Edited by Laref Monday, April 15, 2013 3:30 PM
    Monday, April 15, 2013 3:26 PM
  • Ok here is what I recommend

    1. Pick only one of the queries and keep work on it only… Make sure that we know which one that you have picked
    2. List the problems that you are having with the query.
      1. i.e.  it shows duplicate rows
      2. i.e. I’m not seeing all of my PCs.
      3. Etc.

    FYI, Based on what I understand your issue is, you will need a left outer join on the VC view.


    http://www.enhansoft.com/

    Monday, April 15, 2013 4:06 PM
    Moderator
  • Hi Garth,

    You are right!

    1. I want to work with this query only: http://smsug.ca/blogs/garth_jones/archive/2013/04/15/video-card-details.aspx

    2. If I use this query i have these problems:

       - Duplicated computers:

     BEBRM009   50126   Dell Inc.   Latitude D610   88ZMY1J   Intel(R) Pentium(R) M processor 1.73GHz   2088304   Mobile Intel(R) 915GM/GMS,910GML Express Chipset Family   
     BEBRM009   50126   Dell Inc.   Latitude D610   88ZMY1J   Intel(R) Pentium(R) M processor 1.73GHz   2088304   Mobile Intel(R) 915GM/GMS,910GML Express Chipset Family   128 MB 

      - In the All systems collection I have 5506 computers, and the results of this query are 4949 computers. (including duplicated)

    And this is my problem :(

    I think that the problem are in my computers...and his vga driver. When I used remote tools the standar driver is replaced with the configmr driver...and then the query failed..

    Thank you very much, Garth and Singh for your time!




    • Edited by Laref Tuesday, April 16, 2013 9:18 AM
    Tuesday, April 16, 2013 6:14 AM
  • Thursday, April 18, 2013 1:29 PM
    Moderator
  • Thanks you for your reply Garth!

    Now I have the completed report!

    The problem now is with my computers...the computers with the VGA driver in conflict show a empty field, but it´s ok! :)

     BEBRM016   50127   TOSHIBA   PORTEGE R930   7C0793H   Intel(R) Core(TM) i5-3210M CPU @ 2.50GHz   3309664   Intel(R) HD Graphics 4000   1024 MB 
     BEBRU013   50102   CLEVO Co.   L297P   FF994S4  Intel(R) Pentium(R) 4 CPU 2.80GHz   2079724     

     

    One last thing...I really appreciate your help and frankly it is the only way through which I will be able to finish my report.

    How could I include the information about the sound cards into my report?

    Thank you again.

    Thursday, April 18, 2013 3:09 PM
    • Marked as answer by Laref Wednesday, April 24, 2013 9:22 AM
    Thursday, April 18, 2013 6:51 PM
    Moderator
  • Thanks Garth!

    But now, similar issue:

     BEBRM010   99358   TOSHIBA   PORTEGE R930   ZC044438H   Intel(R) Core(TM) i5-3210M CPU @ 2.50GHz   3309664   Intel(R) HD Graphics 4000   1024 MB   Realtek High Definition Audio 
     BEBRM010   99358   TOSHIBA   PORTEGE R930   ZC044438H   Intel(R) Core(TM) i5-3210M CPU @ 2.50GHz   3309664   Intel(R) HD Graphics 4000   1024 MB   Sonido Intel(R) para pantallas 

    There are 6500 computers in this report? So, to finish i need to delete the 'Sonido intel(R) para pantallas'

    Thank you very much!


    • Edited by Laref Monday, April 22, 2013 2:29 PM
    Monday, April 22, 2013 2:23 PM
  • Add to the Where section the followign text.

    And Sound.Description0 != 'Sonido Intel(R) para pantallas'


    http://www.enhansoft.com/

    • Marked as answer by Laref Wednesday, April 24, 2013 9:22 AM
    Monday, April 22, 2013 5:10 PM
    Moderator
  • Thank you very much Garth!!! now everything is ok!!!

    :)

    Wednesday, April 24, 2013 9:22 AM