functions/Get-DbaPageFileSetting.ps1
|
Function Get-DbaPageFileSetting { <# .SYNOPSIS Returns information about the network connection of the target computer including NetBIOS name, IP Address, domain name and fully qualified domain name (FQDN). .DESCRIPTION WMI class Win32_ComputerSystem tells us if Page File is managed automatically. If TRUE all other properties do not exist. If FALSE classes Win32_PageFile, Win32_PageFileSetting en Win32_PageFileUsage are examined. CIM is used, first via WinRM, and if not successful, via DCOM. This function needs to be executed as a user with local admin rights on the target computer(s). .PARAMETER ComputerName The Server that you're connecting to. This can be the name of a computer, a SMO object, an IP address or a SQL Instance. .PARAMETER Credential Credential object used to connect to the Computer as a different user .NOTES Author: Klaas Vandenberghe ( @PowerDBAKlaas ) dbatools PowerShell module (https://dbatools.io) Copyright (C) 2016 Chrissy LeMaire This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program. If not, see http://www.gnu.org/licenses/. .LINK https://dbatools.io/Get-DbaPageFileSetting .EXAMPLE Get-DbaPageFileSetting -ComputerName ServerA,ServerB Returns a custom object displaying ComputerName, AutoPageFile, FileName, Status, LastModified, LastAccessed, AllocatedBaseSize, InitialSize, MaximumSize, PeakUsage, CurrentUsage for ServerA and ServerB .EXAMPLE 'ServerA' | Get-DbaPageFileSetting Returns a custom object displaying ComputerName, AutoPageFile, FileName, Status, LastModified, LastAccessed, AllocatedBaseSize, InitialSize, MaximumSize, PeakUsage, CurrentUsage for ServerA #> [CmdletBinding()] param ( [Parameter(Mandatory = $false, Position = 0, ValueFromPipeline = $true, ValueFromPipelineByPropertyName = $true)] [Alias("cn", "host", "ServerInstance", "Server", "SqlServer")] [object]$ComputerName, [PSCredential] [System.Management.Automation.CredentialAttribute()]$Credential ) PROCESS { foreach ( $Computer in $ComputerName ) { $reply = Resolve-DbaNetworkName -ComputerName $Computer -erroraction silentlycontinue if ( !$reply.ComputerName ) # we can reach $computer { Write-Warning "$Computer is not available." continue } $computer = $reply.ComputerName Write-Verbose "Getting computer information from $Computer via CIM (WSMan)" $CompSys = Get-CimInstance -ComputerName $Computer -Query "SELECT * FROM win32_computersystem" -ErrorAction SilentlyContinue if ( $CompSys ) # we have computersystem class via WSMan { Write-Verbose "Successfully retrieved ComputerSystem information on $Computer via CIM (WSMan)" if ( $CompSys.PSobject.Properties.Name -contains "automaticmanagedpagefile" ) # pagefile exists on $computer { Write-Verbose "Successfully retrieved PageFile information on $Computer via CIM (WSMan)" if ( $CompSys.automaticmanagedpagefile -eq $False ) # pagefile is not automatically managed, so get settings via WSMan { $PF = Get-CimInstance -ComputerName $Computer -Query "SELECT * FROM win32_pagefile" # deprecated ! $PFU = Get-CimInstance -ComputerName $Computer -Query "SELECT * FROM win32_pagefileUsage" $PFS = Get-CimInstance -ComputerName $Computer -Query "SELECT * FROM win32_pagefileSetting" } } else # pagefile does not exist on $computer, warn and try next computer { Write-Warning "$computer Operating System too old. No Pagefile information available." continue } } else # we do not get computersystem class via WSMan, try via DCom { Write-Verbose "No WSMan connection to $Computer" Write-Verbose "Getting computer information from $Computer via CIM (DCOM)" $sessionoption = New-CimSessionOption -Protocol DCOM $CIMsession = New-CimSession -ComputerName $Computer -SessionOption $sessionoption -Credential $Credential -ErrorAction SilentlyContinue $CompSys = Get-CimInstance -CimSession $CIMsession -Query "SELECT * FROM win32_computersystem" -ErrorVariable $MyErr -ErrorAction SilentlyContinue if ( $CompSys ) # we have computersystem class via DCom { Write-Verbose "Successfully retrieved ComputerSystem information on $Computer via CIM (DCOM)" if ( $CompSys.PSobject.Properties.Name -contains "automaticmanagedpagefile" ) # pagefile exists on $computer { Write-Verbose "Successfully retrieved PageFile information on $Computer via CIM (DCOM)" if ( $CompSys.automaticmanagedpagefile -eq $False ) # pagefile is not automatically managed, so get settings via DCom CimSession { $PF = Get-CimInstance -CimSession $CIMsession -Query "SELECT * FROM win32_pagefile" # deprecated ! $PFU = Get-CimInstance -CimSession $CIMsession -Query "SELECT * FROM win32_pagefileUsage" $PFS = Get-CimInstance -CimSession $CIMsession -Query "SELECT * FROM win32_pagefileSetting" } } else # pagefile does not exist on $computer, warn and try next computer { Write-Warning "$computer Operating System too old. No Pagefile information available." continue } } else # we don't get computersystem, not wia WSMan nor via DCom, warn and try next computer { Write-Warning "No WSMan nor DCom connection to $Computer. If you're not local admin on $Computer, you need to run this command as a different user." continue } } if ( $CompSys.automaticmanagedpagefile -eq $False ) # pagefile is not automatic managed, so return settings { [PSCustomObject]@{ ComputerName = $Computer AutoPageFile = $CompSys.automaticmanagedpagefile FileName = $PF.name # deprecated ! Status = $PF.status # deprecated ! LastModified = $PF.LastModified LastAccessed = $PF.LastAccessed AllocatedBaseSize = $PFU.AllocatedBaseSize # in MB, between Initial and Maximum Size InitialSize = $PFS.InitialSize # in MB MaximumSize = $PFS.MaximumSize # in MB PeakUsage = $PFU.peakusage # in MB CurrentUsage = $PFU.currentusage # in MB } } else # pagefile is automatic managed, so there are no settings { [PSCustomObject]@{ ComputerName = $Computer AutoPageFile = $CompSys.automaticmanagedpagefile FileName = $null Status = $null LastModified = $null LastAccessed = $null AllocatedBaseSize = $null InitialSize = $null MaximumSize = $null PeakUsage = $null CurrentUsage = $null } | Select-DefaultField -Property ComputerName, AutoPageFile } if ( $CIMsession ) { Remove-CimSession $CIMsession } } } } |