Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. 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]