You could use a resolution of 1 day (resolution = 1d) and run the report for the last day (now-1d), which will give you a single value for each host if you're only interested in the current memory assignment for each of the hosts.
If you want the hostnames too instead of just the Dynatrace host ID, use the following:
Hi @andre_vdveen ,
Thanks could you please let me know whether values in bytes or kb.
Also the total memory in host and the value I got is mismatched.
Host1 = 384 GB RAM
Api result :
If I'm not mistaken the numbers are in bytes.
If you will dived the number you get by 1024 three times (1 for KB , 2 for MG, 3 for GB) you will get the number you are looking for, and in your case (((411957420068.33966 / 1024 ) / 1024) / 1024 ) = 383.66524508968 and if you will round it you will get the 384GB