Get-RAMInfo.ps1
|
<#PSScriptInfo
.VERSION 0.4 .GUID 8593d156-3ef4-42fe-b2e5-759348da7643 .AUTHOR Dejan Mladenovic & asheroto .COMPANYNAME .COPYRIGHT .TAGS Get RAM Info Information Memory Modules Specifications Specs Motherboard .LICENSEURI .PROJECTURI https://github.com/asheroto/Get-RAMInfo .ICONURI .EXTERNALMODULEDEPENDENCIES .REQUIREDSCRIPTS .EXTERNALSCRIPTDEPENDENCIES .RELEASENOTES [Version 0.1] - Initial Release [Version 0.2] - Fixed metadata [Version 0.3] - Fixed metadata [Version 0.4] - Removed non-working info in latest PowerShell version .PRIVATEDATA #> <# .SYNOPSIS Get RAM memory info for list of computers. .DESCRIPTION Gets RAM memory info for list of computers, one computer, or this computer. Example Usage: .\Get-RAMInfo.ps1 -Client SELF -Solution "Feb Report" | Format-Table More Examples: Get-Help .\Get-RAMInfo.ps1 -Examples CmdLet has two ParameterSets one for list of computers from file and another from list of strings as computer names. Errors will be saved in log folder PSLogs with name Error_Log.txt. Parameter errorlog controls logging of errors in log file. Get-RAMInfo.ps1 uses Get-CimInstance -Class CIM_PhysicalMemory PowerShell function to get RAM memory info. Result shows following columns: Server Name, Caption, CSDVersion, Version, OSArchitecture, Install Date, Last BootUp Time, SystemDrive, WindowsDirectory, FreePhysicalMemory, FreeSpaceInPagingFiles, FreeVirtualMemory, NumberOfProcesses, NumberOfUsers, SizeStoredInPagingFile, TotalVirtualMemorySize, TotalVisibleMemorySize, IP .PARAMETER computers List of computers that we want to get RAM memory info from. Parameter belongs to default Parameter Set = ServerNames. .PARAMETER filename Name of txt file with list of servers that we want to check RAM memory info. .txt file should be in 01servers folder. Parameter belongs to Parameter Set = FileName. .PARAMETER errorlog Switch parameter that sets to write to log or not to write to log. Error file is in PSLog folder with name Error_Log.txt. .PARAMETER Client Specify the client name here (anything is okay) OK - O client BK - B client etc. .PARAMETER Solution Specify the project/solution name here (anything is okay) FIN - Financial HR - Humane Resource etc. .EXAMPLE Get-RAMInfo.ps1 -client "OK" -solution "FIN" Description --------------------------------------- Test of default parameter with default value ( computers = 'localhost' ) in default ParameterSet = ServerName. .EXAMPLE Get-RAMInfo.ps1 -client "OK" -solution "FIN" -Verbose Description --------------------------------------- Test of Verbose parameter. NOTE: Notice how localhost default value of parameter computers replaces with name of server. .EXAMPLE 'ERROR' | Get-RAMInfo.ps1 -client "OK" -solution "FIN" -errorlog Description --------------------------------------- Test of errorlog parameter. There is no server with name ERROR so this call will fail and write to Error log since errorlog switch parameter is on. Look Error_Log.txt file in PSLogs folder. .EXAMPLE Get-RAMInfo.ps1 -computers 'APP100001' -client "OK" -solution "FIN" -errorlog Description --------------------------------------- Test of computers parameter with one value. Parameter accepts array of strings. .EXAMPLE Get-RAMInfo.ps1 -computers 'APP100001', 'APP100002' -client "OK" -solution "FIN" -errorlog -Verbose Description --------------------------------------- Test of computers parameter with array of strings. Parameter accepts array of strings. .EXAMPLE Get-RAMInfo.ps1 -hosts 'APP100001' -client "OK" -solution "FIN" -errorlog Description --------------------------------------- Test of computers paramater alias hosts. .EXAMPLE Get-RAMInfo.ps1 -computers (Get-Content( "$home\Documents\WindowsPowerShell\Modules\01servers\OKFINservers.txt" )) -client "OK" -solution "FIN" -errorlog -Verbose Description --------------------------------------- Test of computers parameter and values for parameter comes from .txt file that has list of servers. .EXAMPLE 'APP100001' | Get-RAMInfo.ps1 -client "OK" -solution "FIN" -errorlog Description --------------------------------------- Test of pipeline by value of computers parameter. .EXAMPLE 'APP100001', 'APP100002' | Get-RAMInfo.ps1 -client "OK" -solution "FIN" -errorlog -Verbose Description --------------------------------------- Test of pipeline by value with array of strings of computers parameter. .EXAMPLE 'APP100001', 'APP100002' | Select-Object @{label="computers";expression={$_}} | Get-RAMInfo.ps1 -client "OK" -solution "FIN" -errorlog Description --------------------------------------- Test of values from pipeline by property name (computers). .EXAMPLE Get-Content( "$home\Documents\WindowsPowerShell\Modules\01servers\OKFINservers.txt" ) | Get-RAMInfo.ps1 -client "OK" -solution "FIN" -errorlog -Verbose Description --------------------------------------- Test of pipeline by value that comes as content of .txt file with list of servers. .EXAMPLE Help Get-RAMInfo.ps1 -Full Description --------------------------------------- Test of Powershell help. .EXAMPLE Get-RAMInfo.ps1 -filename "OKFINservers.txt" -errorlog -client "OK" -solution "FIN" -Verbose Description --------------------------------------- This is test of ParameterSet = FileName and parameter filename. There is list of servers in .txt file. .EXAMPLE Get-RAMInfo.ps1 -file "OKFINserverss.txt" -errorlog -client "OK" -solution "FIN" -Verbose Description --------------------------------------- This is test of ParameterSet = FileName and parameter filename. This test will fail due to wrong name of the .txt file with warning message "WARNING: This file path does NOT exist:". .INPUTS System.String Computers parameter pipeline both by Value and by Property Name value and has default value of localhost. (Parameter Set = ComputerNames) Filename parameter does not pipeline and does not have default value. (Parameter Set = FileName) .OUTPUTS System.Management.Automation.PSCustomObject Get-RAMInfo.ps1 returns PSCustomObjects which has been converted from PowerShell function Get-CimInstance -Class CIM_PhysicalMemory Result shows following columns: Environment (PROD, Acceptance, Test, Course...), Logical name (Application, web, integration, FTP, Scan, Terminal Server...), Server name, Caption, CSDVersion, Version, OSArchitecture, Install Date, Last BootUp Time, SystemDrive, WindowsDirectory, FreePhysicalMemory, FreeSpaceInPagingFiles, FreeVirtualMemory, NumberOfProcesses, NumberOfUsers, SizeStoredInPagingFile, TotalVirtualMemorySize, TotalVisibleMemorySize .NOTES FunctionName : Get-RAMInfo.ps1 Created by : Dejan Mladenovic Date Coded : 10/31/2018 19:06:41 More info : https://improvescripting.com/ .LINK https://improvescripting.com/how-to-get-memory-ram-details-using-powershell/ Get-CimInstance -Class CIM_PhysicalMemory Get-CimInstance -Class Win32_PhysicalMemory #> [CmdletBinding(DefaultParametersetName = "ServerNames")] param ( [Parameter( ValueFromPipeline = $true, ValueFromPipelineByPropertyName = $true, ParameterSetName = "ServerNames", HelpMessage = "List of computer names separated by commas.")] [Alias('hosts')] [string[]]$computers = 'localhost', [Parameter( ParameterSetName = "FileName", HelpMessage = "Name of txt file with list of servers. Txt file should be in 01servers folder.")] [string]$filename, [Parameter( Mandatory = $false, HelpMessage = "Write to error log file or not.")] [switch]$errorlog, [Parameter(Mandatory = $true, HelpMessage = "Client for example OK = O client, BK = B client")] [string]$client, [Parameter(Mandatory = $true, HelpMessage = "Solution, for example FIN = Financial, HR = Human Resource")] [string]$solution ) BEGIN { if ( $PsCmdlet.ParameterSetName -eq "FileName") { if ( Test-Path -Path "$home\Documents\WindowsPowerShell\Modules\01servers\$filename" -PathType Leaf ) { Write-Verbose "Read content from file: $filename" $computers = Get-Content( "$home\Documents\WindowsPowerShell\Modules\01servers\$filename" ) } else { Write-Warning "This file path does NOT exist: $home\Documents\WindowsPowerShell\Modules\01servers\$filename" Write-Warning "Create file $filename in folder $home\Documents\WindowsPowerShell\Modules\01servers with list of server names." break; } } } PROCESS { foreach ($computer in $computers) { if ( $computer -eq 'localhost' ) { $computer = $env:COMPUTERNAME Write-Verbose "Replace localhost with real name of the server." } Invoke-Command -ComputerName $computer -ScriptBlock { $computerinfo = Get-ComputerInfo } $hostname = $computerinfo.pscomputername try { Write-Verbose "Start processing: $computer" Write-Verbose "Start CIM_PhysicalMemory processing..." $RAMs = $null $params = @{ 'ComputerName' = $computer; 'Class' = 'CIM_PhysicalMemory'; 'ErrorAction' = 'Stop' } $RAMs = Get-CimInstance @params | Select-Object BankLabel, @{Name = "RAM size(GB)"; Expression = { ("{0:N2}" -f ($_.Capacity / 1gb)) } }, DeviceLocator, MemoryType, Name Write-Verbose "Finish CIM_PhysicalMemory processing..." foreach ($RAM in $RAMs) { Write-Verbose "Start processing RAM: $RAM" $properties = @{ 'Server name' = $computer; 'RAM' = $RAM.Name; 'RAM size(GB)' = $RAM."RAM size(GB)"; 'Bank label' = $RAM.BankLabel; 'Device locator' = $RAM.DeviceLocator; 'Memory type' = $RAM.MemoryType; 'Collected' = (Get-Date -UFormat %Y.%m.%d' '%H:%M:%S) } $obj = New-Object -TypeName PSObject -Property $properties $obj.PSObject.TypeNames.Insert(0, 'Report.RAMInfo') Write-Output $obj Write-Verbose "Finish processing RAM: $RAM" } Write-Verbose "Finish processing: $computer - $env - $logicalname" } catch { Write-Warning "Computer failed: $computer - $env - $logicalname RAM failed: $RAM" Write-Warning "Error message: $_" if ( $errorlog ) { $errormsg = $_.ToString() $exception = $_.Exception $stacktrace = $_.ScriptStackTrace $failingline = $_.InvocationInfo.Line $positionmsg = $_.InvocationInfo.PositionMessage $pscommandpath = $_.InvocationInfo.PSCommandPath $failinglinenumber = $_.InvocationInfo.ScriptLineNumber $scriptname = $_.InvocationInfo.ScriptName $ErrorArguments = @{ 'hostname' = $computer; 'errormsg' = $errormsg; 'exception' = $exception; 'stacktrace' = $stacktrace; 'failingline' = $failingline; 'positionmsg' = $positionmsg; 'pscommandpath' = $pscommandpath; 'failinglinenumber' = $failinglinenumber; 'scriptname' = $scriptname } Write-Verbose "Start writing to Error log." Write-ErrorLog @ErrorArguments #Write-ErrorLog -hostname $computer -env $env -logicalname $logicalname -errormsg $errormsg -exception $exception -scriptname $scriptname -failinglinenumber $failinglinenumber -failingline $failingline -pscommandpath $pscommandpath -positionmsg $pscommandpath -stacktrace $stacktrace Write-Verbose "Finish writing to Error log." } } } } END { } #Get-RAMInfo.ps1 -filename "OKFINservers.txt" -errorlog -client "OK" -solution "FIN" -Verbose | Select-Object 'Server Name', 'RAM', 'RAM size(GB)', 'Bank label', 'Device locator', 'Memory type', 'Collected' | Out-GridView <# #Test ParameterSet = ServerName Get-RAMInfo.ps1 -client "OK" -solution "FIN" Get-RAMInfo.ps1 -client "OK" -solution "FIN" -errorlog Get-RAMInfo.ps1 -client "OK" -solution "FIN" -errorlog -Verbose Get-RAMInfo.ps1 -computers 'APP100001' -client "OK" -solution "FIN" -errorlog Get-RAMInfo.ps1 -computers 'APP100001', 'APP100002' -client "OK" -solution "FIN" -errorlog -Verbose Get-RAMInfo.ps1 -hosts 'APP100002' -client "OK" -solution "FIN" -errorlog Get-RAMInfo.ps1 -computers (Get-Content( "$home\Documents\WindowsPowerShell\Modules\01servers\OKFINservers.txt" )) -client "OK" -solution "FIN" -errorlog -Verbose #Pipeline examples 'APP100001' | Get-RAMInfo.ps1 -client "OK" -solution "FIN" -errorlog 'APP100001', 'APP100002' | Get-RAMInfo.ps1 -client "OK" -solution "FIN" -errorlog -Verbose 'APP100001', 'APP100002' | Select-Object @{label="computers";expression={$_}} | Get-RAMInfo.ps1 -client "OK" -solution "FIN" -errorlog Get-Content( "$home\Documents\WindowsPowerShell\Modules\01servers\OKFINservers.txt" ) | Get-RAMInfo.ps1 -client "OK" -solution "FIN" -errorlog -Verbose 'ERROR' | Get-RAMInfo.ps1 -client "OK" -solution "FIN" -errorlog #Test CmdLet help Help Get-RAMInfo.ps1 -Full #SaveToExcel Get-RAMInfo.ps1 -filename "OKFINservers.txt" -errorlog -client "OK" -solution "FIN" -Verbose | Select-Object 'Server Name', 'RAM', 'RAM size(GB)', 'Bank label', 'Device locator', 'Memory type', 'Collected' | Save-ToExcel -errorlog -ExcelFileName "Get-RAMInfo.ps1" -title "Get RAM memory info of servers in Financial solution for " -author "Dejan Mladenovic" -WorkSheetName "RAM memory Info" -client "OK" -solution "FIN" #SaveToExcel and send email Get-RAMInfo.ps1 -filename "OKFINservers.txt" -errorlog -client "OK" -solution "FIN" -Verbose | Select-Object 'Server Name', 'RAM', 'RAM size(GB)', 'Bank label', 'Device locator', 'Memory type', 'Collected' | Save-ToExcel -sendemail -errorlog -ExcelFileName "Get-RAMInfo.ps1" -title "Get RAM info of servers in Financial solution for " -author "Dejan Mladenovic" -WorkSheetName "RAM memory Info" -client "OK" -solution "FIN" #Benchmark #Time = 2 sec; Total Items = 34 Measure-BenchmarksCmdLet { Get-RAMInfo.ps1 -filename "OKFINservers.txt" -errorlog -client "OK" -solution "FIN" -Verbose } #Time = 2 sec; Total Items = 34 Measure-BenchmarksCmdLet { Get-RAMInfo.ps1 -filename "OKFINservers.txt" -errorlog -client "OK" -solution "FIN" } #Baseline create Get-RAMInfo.ps1 -filename "OKFINservers.txt" -errorlog -client "OK" -solution "FIN" -Verbose | Save-Baseline -errorlog -BaselineFileName "Get-RAMInfo.ps1" -client "OK" -solution "FIN" -Verbose #Baseline archive and create new Get-RAMInfo.ps1 -filename "OKFINservers.txt" -errorlog -client "OK" -solution "FIN" -Verbose | Save-Baseline -archive -errorlog -BaselineFileName "Get-RAMInfo.ps1" -client "OK" -solution "FIN" -Verbose #Test ParameterSet = FileName Get-RAMInfo.ps1 -filename "OKFINservers.txt" -errorlog -client "OK" -solution "FIN" -Verbose Get-RAMInfo.ps1 -filename "OKFINserverss.txt" -errorlog -client "OK" -solution "FIN" -Verbose #> |