select TOP 1 TO_TIMESTAMP(TO_VARCHAR("TIME", 'YYYY-MM-DD HH24:MI')) "TIME", HOST, MAX(CPU) "CPU_PCT", ROUND(MAX(MEMORY_USED)/1024/1024/1024, 1) "HANA_USED_MEMORY_GB", ROUND(MAX(MEMORY_RESIDENT)/1024/1024/1024, 1) "HANA_RESIDENT_MEMORY_GB", ROUND(MAX(MEMORY_ALLOCATION_LIMIT)/1024/1024/1024, 1) "HANA_ALLOCATION_LIMIT_GB", ROUND(MAX(MEMORY_TOTAL_RESIDENT)/1024/1024/1024, 1) "TOTAL_RESIDENT_MEMORY_GB", ROUND(MAX(MEMORY_SIZE)/1024/1024/1024, 1) "TOTAL_MEMORY_GB", ROUND(MAX(DISK_USED)/1024/1024/1024, 1) "DISK_USED_GB", ROUND(MAX(DISK_SIZE)/1024/1024/1024, 1) "DISK_SIZE_GB", MAX(NETWORK_IN) "NETWORK_IN_BYTE", MAX(NETWORK_OUT) "NETWORK_OUT_BYTE" from "M_LOAD_HISTORY_HOST" group by TO_TIMESTAMP(TO_VARCHAR("TIME", 'YYYY-MM-DD HH24:MI')), HOST order by TIME desc