To Locate Slot Wise Physical Memory Configuration from Esxi 6.7/Windows Servers running on Dell Hardware

Few Queries Regarding  Physical Memory Configuration on Virtual infra running with  vSphere 6.7

 Is it justified to use  Maximum allowed Physical  Memory on any Hardware Like We have Dell M630 running with 512 GB RAM while it can be enhanced Up to 1.5TB (24 DIMM slots): 4GB/8GB/16GB/32GB/64GB DDR4 up to 2400MT/s

What should be best practice to follow here by increasing resources Like RAM/CPU or if to add more Servers  with std configuration ?

What if We need to extract Slot wise memory Detail ?

 When Using smbiosDump  running individually on Esxi using SSH but not to get the same from multiple Esxi?

Tried to setup some function using script given below..

https://psvmware.wordpress.com/tag/powercli-check-memory-dimms-for-esxi/

But when trying to run giving error like...
New-CimSession : The connection to the specified remote host was refused. Verify that the WS-Management service is
running on the remote host and configured to listen for requests on the correct port and HTTP URL
Need to fetch my existing /memory config /slot wise and best pretcie to use the Server with best available performance

Tried to locate the Hardware and Health tab form VC/Host Webclient [HTML5]..seems it is depreciated now in 6.7?

Please help to locate the required detail from multiple Host/Physical Boxes