Get a list of all drivers from a SCCM driver package
If you are using SCCM 2012, you may have wondered how to get a clean list of all the drivers that are in specific driver package.
Here is how to get a list of all drivers from a SCCM driver package:
/****** Script to query all drivers from a DriverPackage using PackageID ******/ use CM_WK1 Declare @DriverPkgID varchar(8) SET @DriverPkgID = 'WK10013B' SELECT vSMS_DriverContainer.Name AS Driverpackage, vSMS_DriverContainer.PackageID, vSMS_DriverModel.ModelName AS [Driver Model Name], vSMS_DriverModel.ModelManufacture AS [Driver Model Manufacture], v_CI_DriversCIs.DriverINFFile, v_CI_DriversCIs.DriverClass, v_CI_DriversCIs.DriverBootCritical, v_CI_DriversCIs.DriverSigned, v_CI_DriversCIs.DriverDate, v_CI_DriversCIs.DriverVersion FROM vSMS_DriverContainer INNER JOIN vSMS_DriverModel ON vSMS_DriverContainer.CI_ID = vSMS_DriverModel.CI_ID INNER JOIN v_CI_DriversCIs ON vSMS_DriverModel.CI_ID = v_CI_DriversCIs.CI_ID Where vSMS_DriverContainer.PackageID = @DriverPkgID
Was this article helpful? Then please donate to keep The IT Community alive...
If you found this article helpful please share it, comment and help others by writing your own article.
Translate this page:
Articles found in the same category: