Approved

This query is one you are recommended to read the full content of the post to use. It is not simply a copy and paste query, like others in the forum. It is valuable in the right situation

Examine for a specific driver vendor type and version

Given the recent news about Nvidia GPU driver kernel escalation bugs, I would like to know if it is possible to search for drivers with the following;

Use a variable to examine for a single driver like nvidia.

report the version of the driver.

I think this would be valuable as it would be much less "noisy" than a full driver list that could be hundreds of pages on a large network.  Unfortunately as stated in a previous post I am not a SQL guy and don't have the skills to put this together

Parents
  • Hi Gerald,

    Here you go! Just use $$name$$ variable and filter out the driver list as per your need.

    --VARIABLE  name    STRING
    
    SELECT
        device_name,
        device_id,
        service,
        image,
        service_key,
        version,
        inf,
        class,
        provider,
        manufacturer,
        driver_key,
        date,
        signed
    FROM drivers
    WHERE provider LIKE '$$name$$' OR manufacturer LIKE '$$name$$'
    ORDER BY device_name = "", device_name, device_id ASC
     

Comment
  • Hi Gerald,

    Here you go! Just use $$name$$ variable and filter out the driver list as per your need.

    --VARIABLE  name    STRING
    
    SELECT
        device_name,
        device_id,
        service,
        image,
        service_key,
        version,
        inf,
        class,
        provider,
        manufacturer,
        driver_key,
        date,
        signed
    FROM drivers
    WHERE provider LIKE '$$name$$' OR manufacturer LIKE '$$name$$'
    ORDER BY device_name = "", device_name, device_id ASC
     

Children
No Data