<div>
@patron<br />
<br />
I am from Linux oriented<br />
COPIED sample code using batch file:<br />

<pre><code class="code-1 nolinks" id="code-20-43059598-1"><span>@ECHO OFF                                                                              </span>
<span>REM Assume that vm executable name being vmware-vmx.exe</span>
<span>FOR /F %%T IN ('C:\Windows\System32\wbem\WMIC.exe process where ^( Name ^= &quot;vmware-vmx.exe&quot; ^) get ProcessId ^| more +1 ') DO (</span>
<span>SET /A CURPID=%%T) &amp;GOTO DISP_PID</span>
<span>:DISP_PID</span>
<span>C:\Windows\System32\wbem\WMIC.exe process where (Name like 'vmware-vmx.exe') get caption, name, commandline, ProcessId</span>
<span>ECHO CURPID value: %CURPID%</span>
</code></pre>
</div>


<div>
I tried the following at localhost:<br />
<br />
SET OUTPUTFILE=%USERPROFILE%\%<wbr />date:~0,3%<wbr />%date:~4,2<wbr />%%date:~7,<wbr />3%%date:~1<wbr />1,4%%TIME:<wbr />~0,2%%TIME<wbr />:~3,2%%TIM<wbr />E:~6,2%<br />
C:\Windows\System32\wbem\W<wbr />MIC.exe /OUTPUT:%OUTPUTFILE% process where (Name like 'vmware-vmx.exe') get *<br />
<br />
OUTPUT FILE having all required values.
</div>


Technical consultant 

patron

<div>
We can obtain %OUTPUTFILE% each day and group them to required .csv/.html files.<br />
&gt;&gt;&nbsp;from Linux oriented<br />
We can easily achieve that using:<br />
a.<br />
powershell (if known)<br />
b.<br />
cygwin at windows =&gt; to execute linux oriented commands (cat.exe/grep.exe/sed.exe/<wbr />gawk.exe/.<wbr />..)
</div>


<div>
Thanks&nbsp;<a href="https://www.experts-exchange.com/members/murugesandins.html" rel="ugc">MURUGESAN</a>&nbsp; , but am looking for solution can be used on windows for my vmware infra ll be great if there is something in &nbsp;powershell format
</div>


<div>
&gt;&gt; something in &nbsp;powershell format<br />
since I am not from powershell/windows<br />
<br />
&gt;&gt;&nbsp;I am from Linux oriented<br />
Written &nbsp;above statement for updated comments from experts-exchange certified experts at powershell.<br />
<br />
%SystemRoot%\system32\Wind<wbr />owsPowerSh<wbr />ell\v1.0\p<wbr />owershell.<wbr />exe (like Linux terminal)<br />
OR<br />
%WINDIR%\sysWOW64\WindowsP<wbr />owerShell\<wbr />v1.0\Power<wbr />Shell_ISE.<wbr />exe =&gt; *.ps1 (like *.sh at Linux oriented)<br />
<br />
Hence wait for the same.
</div>


<div>
Thank you for understanding my comment.<br />
Based on search:<br />
<br />
<a href="https://docs.microsoft.com/en-us/windows/win32/api/psapi/ns-psapi-process_memory_counters" rel="ugc">https://docs.microsoft.com/en-us/windows/win32/api/psapi/ns-psapi-process_memory_counters</a><br />
<br />
PeakVirtualSize &nbsp; &nbsp;=&gt; maximum amount of memory<br />
PeakWorkingSetSize =&gt; The peak working set size, in bytes.<br />
VirtualSize &nbsp; &nbsp; &nbsp; &nbsp;=&gt; Virtual size is the number of pages that the process has allocated, those pages not currently in the working set (physically loaded in RAM)<br />
VirtualSize &nbsp; &nbsp; &nbsp; &nbsp;=&gt; The working set of a program is a collection of those pages in its virtual address space that have been recently referenced. ... As the working set size increases, memory demand increases. A process has an associated minimum working set size and maximum working set size
</div>


<div>
veeam one community edition is a great reporting tool.
</div>


<div>
Thanks David Johnson, CD ,Please help if this can be achieved using script
</div>


<div>
@patron<br />
<br />
I need to know whether providing shell script using cygwin ?<br />
However disadvantage using cygwin:<br />
1)<br />
vi delete.txt<br />
save and quit.<br />
Right click properties of that file<br />
Security<br />
following users are added <br />
NULL SID<br />
Everyone<br />
None<br />
of course we can remove those garbage collection using a function<br />

<pre><code class="code-10 nolinks" id="code-20-43060022-1"><span>touch ()</span>
<span>{</span>
<span>    /usr/bin/touch &quot;$@&quot;;</span>
<span>    /cygdrive/c/Windows/System32/icacls.exe &quot;$@&quot; /remove &quot;NULL SID&quot; /T;</span>
<span>    /cygdrive/c/Windows/System32/icacls.exe &quot;$@&quot; /remove &quot;Everyone&quot; /T;</span>
<span>    /cygdrive/c/Windows/System32/icacls.exe &quot;$@&quot; /remove &quot;None&quot; /T;</span>
<span>    /cygdrive/c/Windows/System32/icacls.exe &quot;$@&quot; /inheritance:d;</span>
<span>    /cygdrive/c/Windows/System32/cacls.exe &quot;$@&quot; /e /g $LOGNAME:C;</span>
<span>    /cygdrive/c/Windows/System32/icacls.exe &quot;$@&quot; /reset /t /l /c;</span>
<span>    Ret=$?;</span>
<span>    return $Ret</span>
<span>}</span>
</code></pre>
<br />
Hence need to know your comment?<br />
whether providing shell script using cygwin ?<br />
<a href="http://www.cygwin.com/setup-x86_64.exe" rel="ugc">http://www.cygwin.com/setup-x86_64.exe</a><br />
<br />
Create directory(<u><b>murugesandins</b></u> =&gt; <u><b>your user name</b></u>)<br />
C:\Users\murugesandins\cyg<wbr />win<br />
C:\Users\murugesandins\cyg<wbr />win\Downlo<wbr />ads<br />
setup-x86_64.exe --no-admin to install cygwin<br />
<br />
After finishing cygwin installation<br />
windows r =&gt; rundll32.exe sysdm.cpl,EditEnvironmentV<wbr />ariables<br />
include following directory at PATH environment variable:<br />
C:\Users\murugesandins\cyg<wbr />win\bin<br />
C:\Users\murugesandins\cyg<wbr />win\sbin<br />
<br />
<b><u>However remember the exception from cygwin.</u></b><br />
I also used to execute cmd.exe as administrator<br />
<br />
C:\Windows\System32\takeow<wbr />n.exe /f &quot;RequiredFullPathOfCygwinD<wbr />irectory&quot; /r
</div>


<div>
Also remember to get approved statement from supervisor for installing the same.<br />
If you get roll off /resign/... remove cygwin from that system and inform the same to supervisor.
</div>


<div>
Thanks MURUGESAN , am looking for power shell script to automate the reporting here,i need to run it from my windows machine.
</div>


<div>
ok. Got it. wait for related comment from others.
</div>


<div>
Probably you may receive comment from oBdA :)<br />
just my guess :)
</div>


<div>
Looking for script to fetch VMs CPU,RAM,Disk and Network Usage/Performance report for last 30 days where we can locate peak usage timestamp<br />
Please help if there is solution/script/free tool to provide the same in excel or html or if we can automate the same on monthly basis<br />
<br />
Looking for Powershell Script to get valid result/report
</div>


IT Professional

Albert Widjaja

<div>
That is great ..ll surely help on my needs<br />
<br />
Many Thanks to <b>Senior IT System Enginee</b>r<br />
<br />
Let me try if i can get the same in email.<br />
<br />
Great help!!
</div>


<div>
<div class="content wysiwyg-content">
Looking for script to fetch VMs CPU,RAM,Disk and Network Usage/Performance report for last 30 days where we can locate peak usage timestamp<br />
Please help if there is solution/script/freetool to provide the same in excel or html or if we can automate the same on monthly basis<br />
<br />
Thanks!
</div>
</div>


Looking for script to fetch VMs CPU,RAM,Disk and Network Usage/Performance report for last 30 days where we can locate peak usage timestamp
Please help if there is solution/script/freetool to provide the same in excel or html or if we can automate the same on monthly basis

Thanks!

To Extract VM Performance Report

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Virtualization is the act of creating a virtual (rather than actual) version of something, including (but not limited to) a virtual computer hardware platform, operating system (OS), storage device, or computer network resources. Virtualization is usually the creation of a system that executes separate from the underlying hardware resources, or the creation of an entire desktop for systems located elsewhere, similar to thin clients.

Virtualization

HTML (HyperText Markup Language) is the main markup language for creating web pages and other information to be displayed in a web browser, providing both the structure and content for what is sent from a web server through the use of tags. The current implementation of the HTML specification is HTML5.

HTML

VMware, a software company founded in 1998,  was one of the first commercially successful companies to offer x86 virtualization. The storage company EMC purchased VMware in 1994. Dell Technologies acquired EMC in 2016. VMware’s parent company is now Dell Technologies.

VMware has many software products that run on desktops, Microsoft Windows, Linux, and macOS, which allows the virtualizing of the x86 architecture.  Its enterprise software hypervisor for servers, VMware vSphere Hypervisor (ESXi), is a bare-metal hypervisor that runs directly on the server hardware and does not require an additional underlying operating system.

VMware

A scripting language is a programming language that supports scripts, programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator. Scripting languages are often interpreted (rather than compiled). Primitives are usually the elementary tasks or API calls, and the language allows them to be combined into more complex programs. Environments that can be automated through scripting include software applications, web pages within a web browser, the shells of operating systems (OS), embedded systems, as well as numerous games. A scripting language can be viewed as a domain-specific language for a particular environment; in the case of scripting an application, this is also known as an extension language.