Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Endpoint Management Community Blog

SQL Query... Mass-storage drivers

Created: 08 Aug 2012 • Updated: 08 Aug 2012
ianatkin's picture
0 0 Votes
Login to vote

Just a little query to to detail how many computers have the Intel 7 Series SATA AHCI controller which has Device ID 1E03. These new controllers come on our shiny new Dell Latitude E6330, but I was curious to see if anyone else in our managed estate had this controller. 

select count(*), [System Manufacturer],[Computer Model] from AexInv_Aex_HW_PCI_Bus 

join Wrksta on AexInv_Aex_HW_PCI_Bus.wrkstaID = Wrksta.Wrkstaid

join Inv_Aex_HW_Serial_Number on Inv_Aex_HW_Serial_Number._ResourceGUID = Wrksta.GUID

where [PCI BUS Component] 

like '%DEV_1E03%'

group by [System Manufacturer],[Computer Model]