That is perfect Elias, thank you. I knew it was a CI, I just couldn't find the proper view.
Eswar I have been meaning to export those views for a reference but never got around to it. Thanks! Daniel Ratliff From: [email protected] [mailto:[email protected]] On Behalf Of Elias Leal Sent: Wednesday, November 06, 2013 2:21 AM To: [email protected] Subject: Re: [mssms] SQL query to get driver (not driver package) content source path? Is this what you need? 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 I believe this will get you the info you see when you look directly under Software Library -> Operating Systems -> Drivers Elias On Mon, Nov 4, 2013 at 12:51 PM, Daniel Ratliff <[email protected]<mailto:[email protected]>> wrote: I hope I am just completely missing it here, but is there a SQL view in ConfigMgr 2012 (SP1 CU2 specificially) to list the driver source path? I have an old query I used for ConfigMgr 2007 but the view no longer exists. The closest thing I can find it v_package and v_driverpackage but that is only for the driver packages, not the drivers themselves. Daniel Ratliff The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
