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
Tags: CIM
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 -Credential $Credential -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-DefaultView -Property ComputerName, AutoPageFile
            }
            if ( $CIMsession ) { Remove-CimSession $CIMsession }
        }
    }
}