SQL Query to get all device drivers installed like (graphics,audio,chipset) details with version information

Question

Could you please help  me to get Sql query to get installed device delivers details like Hostname,make,Model ,driver name ,verion  ect

solved 0
Naga Raju 2021-01-30T00:58:55+05:30 2 Answers 1736 views Beginner
0

Answers ( 2 )

  2. Ankit Shukla
    0
    2021-01-30T13:58:44+05:30
    Reply

    You can use different imvetory classes to get the details , like for intel HD graphics , nvidia graphics , realtek audio driver these entry are found in add and remove programs.If you want for video driver you can use v_gs_video_controller class also to get the details.
    v_gs_pc_bios you can get bios details.

    check below article

    https://www.google.com/url?sa=t&source=web&rct=j&url=https://www.linkedin.com/pulse/sccm-driver-version-details-philip-cumiskey&ved=2ahUKEwj_1KyXnsPuAhVIhlwKHWGQCBAQFjAAegQIARAB&usg=AOvVaw0CmQr68jRxQUG6knbhu4XL

    Best answer
  4. Anoop C Nair
    0
    2021-01-30T07:51:27+05:30
    Reply

    I don’t have the query ready to use for this. However you can try checking sccm hardware default reports

    https://www.anoopcnair.com/configmgr-hardware-related-reports-sccm-default/

    Let me know if you don’t find the details
    Then we might need to take the query from take some extra steps like custom inventory etc

Leave an answer

Sorry, you do not have permission to answer to this question .