Query for memory slot types


I was working with a customer to figure out how many different variations of computer memory card slots they had in the environment.  Turns out there are many (DIMM A, DIMM_A, Slot 1, Slot_1, Top Slot, Bottom Slot, etc). The query is a very specific use case but putting it here in case it helps you out.  If nothing else it's a sample on how to do counts. 

SELECT DISTINCT COUNT(DeviceLocator0) DeviceLocator0
FROM            v_GS_PHYSICAL_MEMORY
GROUP BY DeviceLocator0


Comments (0)

Skip to main content