This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

Script to fetch users consuming high memory for a particular process on remote windows servers

Question
0

Sign in to vote
I am trying to write a script that would provide me list of users who are consuming memory above threshold for an application process running on remote windows 2008 servers.

Output should be in below Format

Server_Name UserName MemoryConsumed

Please note that there could be more than one instances for a user with that process.

I tried using below commands, but still not getting the data as required.

Using get process, I was able to get all the processes on remote host consuming memory above threshold:

get-process -ComputerName $vm.name [ProcessName] | Where-Object {$_.WorkingSet -gt 2GB}

Using below command I was able to fetch data w.r.t. to each User.

Get-WmiObject Win32_Process -Filter "name='[ProcessName]'" | Select Name, @{Name="UserName";Expression={$_.GetOwner().User}} | Sort-Object UserName, Name

But I am unable to fetch the data in required format
- Edited by Deep_PS Wednesday, September 27, 2017 2:03 PM
Wednesday, September 27, 2017 1:51 PM

All replies

0

Sign in to vote

Please read this first: This forum is for scripting questions rather than script requests
Also find scripts here: http://gallery.technet.microsoft.com

Learn PowerShell: https://mva.microsoft.com/en-us/training-courses/getting-started-with-microsoft-powershell-8276
\_(ツ)_/

Wednesday, September 27, 2017 5:36 PM
0

Sign in to vote
Hey

You could go with solution proposed in below article:

https://social.technet.microsoft.com/Forums/windowsserver/en-US/45c541e0-fb49-4ac7-bcaf-738315a70863/getprocess-and-username?forum=winserverpowershell

I am pasting it below for You.

$owners = @{} gwmi win32_process |% {$owners[$_.handle] = $_.getowner().user} get-process | select processname,Id,@{l="Owner";e={$owners[$_.id.tostring()]}}

Final one would be like that below.

$owners = @{} gwmi win32_process |% {$owners[$_.handle] = $_.getowner().user} Get-Process -ComputerName $vm.name [ProcessName] | Where-Object {$_.WorkingSet -gt 2GB} | select processname,Id,@{l="Owner";e={$owners[$_.id.tostring()]}}

Cheers

Please remember to mark the replies as an answers if they help.
- Proposed as answer by MartinITPro Thursday, September 28, 2017 12:58 PM
- Edited by MartinITPro Thursday, September 28, 2017 1:00 PM adding final version
Thursday, September 28, 2017 12:58 PM