Thanks guys!

Exacly what I'm looking for... Here is how mine looks

SELECT physical_memory_in_bytes / 1073741824 as 'Physical OS Memory in GB'

FROM sys.dm_os_sys_info

Works a treat!