SCCM 2012 Powershell Scripts: SCCM Client DP-MP-SUP Port Query tool

A script which can help you to determine if the client machine is able to established connection to DP, MP and SUP on required ports.

A UI will be presented to user to select the site and do the port query.

Change the variable $regionsComboData and add your site names the format should be Sitename-SiteCode , as it is used later in the script .

This script uses the portquery utility to do the port query. It needs to be downloaded and kept in the same folder as the script.

https://www.microsoft.com/en-us/download/details.aspx?id=17148

Place the script inside a folder named logic, script will create the folder named Result and generate the csv file with port query results. Also it consolidate the log created by portqry tool and generate a single log file inside results folder.

Verbose output will be shown in Powershell console.

Screenshot of the UI.

To generate the CSV file which has the server details stored use the second script which is available at the end of this post, this csv file also should be placed along with the script.

#Write-Host "Setting variables" -ForegroundColor Yellow

$regionsComboData = "Site1-SI1","Site2-SI2", "Site3-SI3", "Site4-SI4"

$scriptFolder = split-path -parent $MyInvocation.MyCommand.Definition

#Write-Verbose "Script path: $scriptFolder"

$substringlen = $scriptFolder.LastIndexOf("\")

$resultFolder = "$($scriptFolder.Substring(0,$substringlen))\Result"

$consolidatedLog = "$($resultFolder)\PortQueryLog.log"

$portStatusFile = "$($resultFolder)\PortStatus.csv"

$ServerDetailsFile = "$($scriptFolder)\ServerDetails.csv"

#Write-Verbose "Log file: $consolidatedLog"

#Write-Verbose "Results file: $portStatusFile"

#Write-Verbose "Server Details file: $ServerDetailsFile"

#Write-Host " "

#region GUICode

#ERASE ALL THIS AND PUT XAML BELOW between the @" "@

$inputXML = @"

<Window x:Class="WpfApplication2.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:d="http://schemas.microsoft.com/expression/blend/2008"

xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"

xmlns:local="clr-namespace:WpfApplication2"

mc:Ignorable="d"

Title="PortChecker for SCCM Client" Height="386.386" Width="550.99">

<Grid>

<Grid.ColumnDefinitions>

</Grid.ColumnDefinitions>

<ListView.View>

</GridView>

</ListView.View>

</ListView>

</Grid>

</Window>

#Checkbox GUI code

$inputXML = $inputXML -replace 'mc:Ignorable="d"','' -replace "x:N",'N' -replace '^<Win.*', '<Window'

[void][System.Reflection.Assembly]::LoadWithPartialName('presentationframework')

[xml]$XAML = $inputXML

#Read XAML

$reader=(New-Object System.Xml.XmlNodeReader $xaml)

try{$Form=[Windows.Markup.XamlReader]::Load( $reader )}

catch{Write-Host "Unable to load Windows.Markup.XamlReader. Double-check syntax and ensure .net is installed."}

#===========================================================================

# Load XAML Objects In PowerShell

#===========================================================================

$xaml.SelectNodes("//*[@Name]") | %{Set-Variable -Name "WPF$($_.Name)" -Value $Form.FindName($_.Name)}

Function Get-FormVariables{

if ($global:ReadmeDisplay -ne $true){Write-host "If you need to reference this display again, run Get-FormVariables" -ForegroundColor Yellow;$global:ReadmeDisplay=$true}

write-host "Found the following interactable elements from our form" -ForegroundColor Cyan

get-variable WPF*

}

function Write-MessageToGUI($message)

{

$WPFmsgToUser.Text = $message

}

Get-FormVariables

#===========================================================================

# Actually make the objects work

#===========================================================================

#Sample entry of how to add data to a field

#$vmpicklistView.items.Add([pscustomobject]@{'VMName'=($_).Name;Status=$_.Status;Other="Yes"})

#===========================================================================

# Shows the form

#===========================================================================

#write-host "To show the form, run the following" -ForegroundColor Cyan

#$WPFFind.Add_Click({$WPFResult.Text = Get-BoundaryDetails $WPFHostName.Text})

#endregion GUI Code

Function initialize-Settings

{

if(!(Test-Path $resultFolder))

{

Write-Host "Result folder not found, creating the folder" -ForegroundColor Yellow

mkdir $resultFolder

}

if(!(Test-Path $ServerDetailsFile))

{

Write-Host "Unable to find the csv file with server details @ $ServerDetailsFile" -ForegroundColor Yellow

Exit 0

}

Write-Host "Checking if portqry tool is present in the directory" -ForegroundColor Yellow

if(!(Test-Path "$($scriptFolder)\PortQry.exe"))

{

#Get-ChildItem .\

Write-Host "Portquery.exe is not found, aborting" -ForegroundColor Yellow

Exit 0

}

Function Get-PortStatus($serverNameIP,$PortNo,$prtcl)

{

<#$serverNameIP = "C105JWWCMNSDP"

$prtcl = "TCP"

$portNo = 80

Write-Host "Querying....... Server: $serverNameIP, PortNo: $portNo , Protocol: $prtcl" -ForegroundColor Yellow

#Read-Host "test"

$logFile = "$($scriptFolder)\$($serverNameIP)_$($prtcl)_$($portNo)_portRes.log"

& $scriptFolder\PortQry.exe -n $serverNameIP -p $prtcl -e $portNo -l $logFile -q

Write-Host "Writing data to consolidated log file" -ForegroundColor Yellow

Get-Content $logFile | Out-File $consolidatedLog -Append -Encoding ascii

Write-Host "Removing log created by proqry tool $logFile" -ForegroundColor Yellow

Remove-Item $logFile

$portStatus = "UNKNOWN"

#Write-Verbose "Exitcode $LASTEXITCODE"

switch ($LASTEXITCODE)

{

0 {$portStatus = "OPEN"}

1 {$portStatus = "CLOSED"}

2 {$portStatus = "FILTERED"}

Default{$portStatus = "UNKNOWN" }

}

$portStatusObj = New-Object -TypeName psobject

Add-Member -InputObject $portStatusObj -MemberType NoteProperty -Name "ServerName" -Value $serverNameIP

Add-Member -InputObject $portStatusObj -MemberType NoteProperty -Name "Port" -Value $portNo

Add-Member -InputObject $portStatusObj -MemberType NoteProperty -Name "Protocol" -Value $prtcl

Add-Member -InputObject $portStatusObj -MemberType NoteProperty -Name "Status" -Value $portStatus

#Write-Verbose "Returning result"

Return $portStatusObj

}

#region portprofiles

$portProfiles = @()

#DP