Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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