This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 5%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Hi Guys,
I have been trying for weeks to create a SCOM custom dashboard view to display current CPU%, RAM%, Network%, C drive %, D drive % in one single view. SCOM has the limitation to display only the "Top 20" resource utilization but in my case I have more than 60+ server and all of them needs to be displayed. I was suggested that this could be possible using a PowerShell dashboard and I have done too many research to find a script which could help me based on my requirement but unfortunately could not find any blogs or post which is relevant to my need. Could someone please help me out with my request?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 30%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
@Nizwan Sultan P N , Research but not find the sample to create a dashboard with PowerShell script to get resource utilization. For PowerShell script, I find some similar links for the reference:
https://www.reddit.com/r/PowerShell/comments/ayo3yo/looking_for_a_simple_script_to_get_cpu_usage_top/
https://www.powershellbros.com/get-memory-utilization-report-using-powershell/
Note: Non-Microsoft link just for the reference.
For your request, I notice this needs strong PowerShell script skills. To get more professional help, we suggest to open a case to help on this. Here is a link with the Phone number for the reference:
https://support.microsoft.com/en-us/topic/global-customer-service-phone-numbers-c0389ade-5640-e588-8b0e-28de8afeb3f2
Thanks for the understanding and have a nice day!
Thanks @Crystal-MSFT for your response. I understand this needs some strong PowerShell scripting and I was hoping that someone would have come across this scenario as a request to implement in their work. I am still clueless on how to proceed this further.
@everyone, If any one has such experience, I appreciate your help to share here. Thanks for your help in advance.
@Nizwan Sultan P N , let's wait to see if anyone has the similar experience can share here to help us. If still no response, we can open case to get more help.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 66%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hi,
Thank you for asking this. For a quick lab test, I've created a dashboard view with two grid columns and add the PowerShell Grid Widget for one of them. And the powershell is something like this.
$class = Get-SCOMClass -Name Microsoft.Windows.Computer
$computers = Get-SCOMClassInstance -Class $class
$i=1
foreach ($computer in $computers)
{
$cpu_usage = (Get-WmiObject -ComputerName $computer -Class win32_processor -ErrorAction silentlycontinue | Measure-Object -Property LoadPercentage -Average | Select-Object Average).Average.ToString()+"%"
$dataObject=$ScriptContext.CreateFromObject($computer,"Id=Id,HealthState=HealthState,DisplayName=DisplayName",$null)
$dataObject["Index"]=$i
$dataObject["CPU_Usage"]=$cpu_usage
$ScriptContext.ReturnCollection.Add($dataObject)
$i++
}
Note: Get-WmiObject need remote administration permission on target computer. We can set -ErrorAction Stop to see if any errors. If 0x800706BA error appears, check this article:
https://www.vspbreda.nl/nl/server-os/server-2008/error-get-wmiobject-the-rpc-server-is-unavailable-exception-from-hresult-0x800706ba/
Note: the above link is not from MS, just for your reference.
After that, the output is like this:
For more information about dashboard scrip widget, we may refer to:
https://social.technet.microsoft.com/wiki/contents/articles/24595.operations-manager-dashboard-script-widgets.aspx
Alex
If the response is helpful, please click "Accept Answer" and upvote it.
Hi Alex,
Thank you for the solution. Works perfect. I have further added wmi objects but I have an issue which I am unable to identify in the script.
$class = Get-SCOMClass -Name Microsoft.Windows.Computer
$computers = Get-SCOMClassInstance -Class $class
$i=1
foreach ($computer in $computers)
{
$cpu_usage = (Get-WmiObject -ComputerName $computer -Class win32_processor | Measure-Object -Property LoadPercentage -Average | Select-Object Average).Average.ToString()
$mem_usage = Get-WmiObject win32_operatingsystem -ComputerName $c | Foreach {"{0:N2}" -f ((($.TotalVisibleMemorySize - $.FreePhysicalMemory)*100)/ $.TotalVisibleMemorySize)}
$disk_usage_c = Get-WmiObject Win32_Volume -ComputerName $c -Filter "DriveLetter = 'C:'" | Foreach {"{0:N2}" -f (($.FreeSpace / $.Capacity)*100)}
$disk_usage_d = Get-WmiObject Win32_Volume -ComputerName $c -Filter "DriveLetter = 'D:'" | Foreach {"{0:N2}" -f (($.FreeSpace / $_.Capacity)*100)} $dataObject=$ScriptContext.CreateFromObject($computer,"Id=Id,HealthState=HealthState,DisplayName=DisplayName",$null)
$dataObject["Index"]=$i
$dataObject["CPU%"]=$cpu_usage
$dataObject["Memory%"]=$mem_usage
$dataObject["C:Drive"]=$disk_usage_c
$dataObject["D:Drive"]=$disk_usage_d
$ScriptContext.ReturnCollection.Add($dataObject)
$i++
}
The script loads all the resource data when only one server is listed but when multiple servers are listed then the Mem% & DiskFree% details does not fetch data.
Output with a single server:
Output with multiple servers:
Could you please help me if I am missing anything on the script to get it working. @AlexZhu-MSFT
Hi Guys,
Thanks for all your response. I got held up with something else and wasn't able to respond to your suggestions.
I tried to query the logical disk details using powershell script for sample on operations manager shell and was able to get the data but when using the same script on the SCOM dashboard it does not fetch any details. it keeps loading with no response.
@AlexZhu-MSFT : Hi Alex.. I found few post of yours which I could relate with my request and thought you might be able to help me on this ?