Show Drivers with Source Path

Version: SCCM 2012 SP1 CU2

This query will show drivers located in the CM12 console under Software Library -> Operating Systems -> Drivers. It will display driver names, source path, driver class, driver version, etc.

SELECT CIDM.ManufacturerName,CIDM.ModelName, CICI.ContentSourcePath, CIDCI.DriverDate, CIDCI.DriverClass, CIDCI.DriverVersion, CIDCI.DriverProvider 
FROM v_CI_DriverModels CIDM
join vCI_ConfigurationItems CICI on CIDM.CI_UniqueID=CICI.CI_UniqueID
join v_CI_DriversCIs CIDCI on CIDM.CI_UniqueID=CIDCI.CI_UniqueID
Order by CIDM.ManufacturerName,CIDM.ModelName

Sample Output:

Show Drivers with Source Path

Show Drivers with Source Path