Get Archives - Tatux.co.uk

Get-NTVMWareStorageCacheStats

June 5, 2017June 5, 2017 by Nigel Tatschner

<#
	.SYNOPSIS
		Gets the storage cache stats for every cache node in each supplied host
	
	.DESCRIPTION
		A wrapper for 'Get-ESXCli' cmdlet to return statistics for the storage cache on the supplied hosts,
		the 'Get-ESXCli' cmdlet is itself a wrapper for the ESX command line utility allowing a deeper functionality that currently is not available through PowerCLI.
		It goes without saying you need either import the PowerCLI cmdlets or open the PowerCLI shell.
		You also need to connect to the vCenter the hosts are attached to.
	
	.PARAMETER VMHost
		The ESXi Hostname you'd like to connect to, you can pipe to this commend from something like Get-VMHost.
		This property also supports an array of hosts, supply like this "-VMHost Host1, Host2, Host3" etc
	
	.EXAMPLE
		PS C:\> Get-NTVMWareStorageCacheStats -VMHost $value1
	
	.EXAMPLE
		PS C:\> Get-NTVMWareStorageCacheStats -VMHost Host1, Host2, Host3, Host4
	
	.NOTES
		Created by Nigel Tatschner, please use this freely but please maintain the reference here
	
	.LINK
		www.tatux.co.uk
#>
function Get-NTVMWareStorageCacheStats
{
	[CmdletBinding(SupportsPaging = $false)]
	[OutputType([pscustomobject])]
	param
	(
		[Parameter(Mandatory = $true,
				   ValueFromPipeline = $true,
				   ValueFromPipelineByPropertyName = $true,
				   Position = 0,
				   HelpMessage = 'Enter the ESXi Hostname')]
		[Alias('name')]
		[System.String[]]$VMHost
	)
	
	Begin
	{
		
	}
	Process
	{
		$Props = [ordered]@{
			'Host'							   = '';
			'CacheName'						  = '';
			'Cacheusagerateasapercentage'	    = '';
			'Meannumberofcacheblocksinuse'	   = '';
			'TotalfailedSSDIOs'				  = '';
			'TotalfaileddiskIOs'				 = '';
			'Cachehitrateasapercentage'		  = '';
			'MaxobservedIOlatencyinmicroseconds' = '';
			'MaxobservedIOPS'				    = '';
			'MaxobservednumberofKBperIO'		 = '';
			'MeanIOlatencyinmicroseconds'	    = '';
			'MeanIOPS'						   = '';
			'MeancacheIOlatencyinmicroseconds'   = '';
			'MeandiskIOlatencyinmicroseconds'    = '';
			'MeannumberofKBperIO'			    = '';
			'TotalIOs'						   = '';
			'TotalcacheIOs'					  = '';
			'TotaldiskIOs'					   = '';
			'LastIOoperationtimeinmicroseconds'  = '';
			'MeanblocksperIOoperation'		   = '';
			'NumberofIOblocksinlastoperation'    = ''
		}
		
		foreach ($a in $VMHost)
		{
			try
			{
				$ESXCLI = Get-EsxCli -VMHost $a -V2 -ErrorAction 'Stop'
				$CacheList = $ESXCLI.storage.vflash.cache.list.invoke()
				foreach ($b in $CacheList.Name)
				{
					$args = $ESXCLI.storage.vflash.cache.stats.get.createargs()
					$args.cachename = $b
					$Output = $ESXCLI.storage.vflash.cache.stats.get.invoke($args)
					$Obj = New-Object System.Management.Automation.PSObject -Property $Props
					$Obj.Host = $a
					$Obj.CacheName = $b
					$obj.Cacheusagerateasapercentage = $Output.Cacheusagerateasapercentage
					$obj.Meannumberofcacheblocksinuse = $Output.Meannumberofcacheblocksinuse
					$obj.TotalfailedSSDIOs = $Output.TotalfailedSSDIOs
					$obj.TotalfaileddiskIOs = $Output.TotalfaileddiskIOs
					$obj.Cachehitrateasapercentage = $Output.read.Cachehitrateasapercentage
					$obj.MaxobservedIOlatencyinmicroseconds = $Output.read.MaxobservedIOlatencyinmicroseconds
					$obj.MaxobservedIOPS = $Output.read.MaxobservedIOlatencyinmicroseconds
					$obj.MaxobservednumberofKBperIO = $Output.read.MaxobservednumberofKBperIO
					$obj.MeanIOlatencyinmicroseconds = $Output.read.MeanIOlatencyinmicroseconds
					$obj.MeanIOPS = $Output.read.MeanIOPS
					$obj.MeancacheIOlatencyinmicroseconds = $Output.read.MeancacheIOlatencyinmicroseconds
					$obj.MeandiskIOlatencyinmicroseconds = $Output.read.MeandiskIOlatencyinmicroseconds
					$obj.MeannumberofKBperIO = $Output.read.MeannumberofKBperIO
					$obj.TotalIOs = $Output.read.TotalIOs
					$obj.TotalcacheIOs = $Output.read.TotalcacheIOs
					$obj.TotaldiskIOs = $Output.read.TotaldiskIOs
					$obj.LastIOoperationtimeinmicroseconds = $Output.evict.LastIOoperationtimeinmicroseconds
					$obj.MeanblocksperIOoperation = $Output.evict.MeanblocksperIOoperation
					$obj.NumberofIOblocksinlastoperation = $Output.evict.NumberofIOblocksinlastoperation
					$Obj
				}
			}
			Catch
			{
				Write-Error -Message "Could not connect to host $($a), make sure you're connected to the correct vcenter"
			}
		}
	}
	End
	{
		
	}
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

.SYNOPSIS

Gets the storage cache stats for every cache node in each supplied host

.DESCRIPTION

A wrapper for 'Get-ESXCli' cmdlet to return statistics for the storage cache on the supplied hosts,

the 'Get-ESXCli' cmdlet is itself a wrapper for the ESX command line utility allowing a deeper functionality that currently is not available through PowerCLI.

It goes without saying you need either import the PowerCLI cmdlets or open the PowerCLI shell.

You also need to connect to the vCenter the hosts are attached to.

.PARAMETER VMHost

The ESXi Hostname you'd like to connect to, you can pipe to this commend from something like Get-VMHost.

This property also supports an array of hosts, supply like this "-VMHost Host1, Host2, Host3" etc

.EXAMPLE

PS C:\> Get-NTVMWareStorageCacheStats -VMHost $value1

.EXAMPLE

PS C:\> Get-NTVMWareStorageCacheStats -VMHost Host1, Host2, Host3, Host4

.NOTES

Created by Nigel Tatschner, please use this freely but please maintain the reference here

.LINK

www.tatux.co.uk

function Get-NTVMWareStorageCacheStats

{

[CmdletBinding(SupportsPaging = $false)]

[OutputType([pscustomobject])]

param

(

[Parameter(Mandatory = $true,

ValueFromPipeline = $true,

ValueFromPipelineByPropertyName = $true,

Position = 0,

HelpMessage = 'Enter the ESXi Hostname')]

[Alias('name')]

[System.String[]]$VMHost

)

Begin

{

}

Process

{

$Props = [ordered]@{

'Host' = '';

'CacheName' = '';

'Cacheusagerateasapercentage' = '';

'Meannumberofcacheblocksinuse' = '';

'TotalfailedSSDIOs' = '';

'TotalfaileddiskIOs' = '';

'Cachehitrateasapercentage' = '';

'MaxobservedIOlatencyinmicroseconds' = '';

'MaxobservedIOPS' = '';

'MaxobservednumberofKBperIO' = '';

'MeanIOlatencyinmicroseconds' = '';

'MeanIOPS' = '';

'MeancacheIOlatencyinmicroseconds' = '';

'MeandiskIOlatencyinmicroseconds' = '';

'MeannumberofKBperIO' = '';

'TotalIOs' = '';

'TotalcacheIOs' = '';

'TotaldiskIOs' = '';

'LastIOoperationtimeinmicroseconds' = '';

'MeanblocksperIOoperation' = '';

'NumberofIOblocksinlastoperation' = ''

}

foreach ($a in $VMHost)

{

try

{

$ESXCLI = Get-EsxCli -VMHost $a -V2 -ErrorAction 'Stop'

$CacheList = $ESXCLI.storage.vflash.cache.list.invoke()

foreach ($b in $CacheList.Name)

{

$args = $ESXCLI.storage.vflash.cache.stats.get.createargs()

$args.cachename = $b

$Output = $ESXCLI.storage.vflash.cache.stats.get.invoke($args)

$Obj = New-Object System.Management.Automation.PSObject -Property $Props

$Obj.Host = $a

$Obj.CacheName = $b

$obj.Cacheusagerateasapercentage = $Output.Cacheusagerateasapercentage

$obj.Meannumberofcacheblocksinuse = $Output.Meannumberofcacheblocksinuse

$obj.TotalfailedSSDIOs = $Output.TotalfailedSSDIOs

$obj.TotalfaileddiskIOs = $Output.TotalfaileddiskIOs

$obj.Cachehitrateasapercentage = $Output.read.Cachehitrateasapercentage

$obj.MaxobservedIOlatencyinmicroseconds = $Output.read.MaxobservedIOlatencyinmicroseconds

$obj.MaxobservedIOPS = $Output.read.MaxobservedIOlatencyinmicroseconds

$obj.MaxobservednumberofKBperIO = $Output.read.MaxobservednumberofKBperIO

$obj.MeanIOlatencyinmicroseconds = $Output.read.MeanIOlatencyinmicroseconds

$obj.MeanIOPS = $Output.read.MeanIOPS

$obj.MeancacheIOlatencyinmicroseconds = $Output.read.MeancacheIOlatencyinmicroseconds

$obj.MeandiskIOlatencyinmicroseconds = $Output.read.MeandiskIOlatencyinmicroseconds

$obj.MeannumberofKBperIO = $Output.read.MeannumberofKBperIO

$obj.TotalIOs = $Output.read.TotalIOs

$obj.TotalcacheIOs = $Output.read.TotalcacheIOs

$obj.TotaldiskIOs = $Output.read.TotaldiskIOs

$obj.LastIOoperationtimeinmicroseconds = $Output.evict.LastIOoperationtimeinmicroseconds

$obj.MeanblocksperIOoperation = $Output.evict.MeanblocksperIOoperation

$obj.NumberofIOblocksinlastoperation = $Output.evict.NumberofIOblocksinlastoperation

$Obj

}

Catch

{

Write-Error -Message "Could not connect to host $($a), make sure you're connected to the correct vcenter"

}

End

{

}

Get-NTServerDetails

June 8, 2016August 19, 2015 by Nigel Tatschner

<#
	.SYNOPSIS
		To gather and instantiate the servers details
	
	.DESCRIPTION
		Capsulizing WMI queries to gather and propagate new objects for output for queried servers
	
	.PARAMETER ComputerName
		Computer Name of the Server you would like to connect to.
	
	.EXAMPLE
				PS C:\> Get-NTServerDetails -ComputerName 'Value1'
	
	.NOTES
		Created by Nigel Tatschner 2015.
#>
function Get-NTServerDetails
{
	[CmdletBinding()]
	[OutputType([Object])]
	param
	(
		[Parameter(Mandatory = $true,
				   ValueFromPipeline = $true,
				   ValueFromPipelineByPropertyName = $true,
				   HelpMessage = 'Enter the Name of the Server you would like to connect to.')]
		[Alias('ServerName')]
		[string]$ComputerName
	)
	
	Begin
	{
		try
		{
			Write-Verbose "Testing Connection to Server $ComputerName"
			Test-Connection -ComputerName $ComputerName -ErrorAction Stop | Out-Null
			Write-Verbose "Connection to $($ComputerName) was susccessfull, moving on to wmi queries"
		}
		Catch
		{
			Write-Verbose "Could not connect to $ComputerName"
			Write-Error -Message "Could not connect to $($ComputerName)" -Category ConnectionError -RecommendedAction 'Check if the computer name is correct and it is on.'
			Continue
		}

	}
	Process
	{
		try
		{
			Write-Verbose 'Getting Computer System details'
			$ComputerSystemDetails = Get-WmiObject -ComputerName $ComputerName -Class Win32_ComputerSystem -ErrorAction Stop
			Write-Verbose 'Computer System Details Gathered.'
		}
		catch [System.UnauthorizedAccessException]
		{
			Write-Verbose "Could not connect to $($ComputerName) via WMI - Access Denied"
			Write-Error -Message "Access Denied - Could not access computer system details from $ComputerName via WMI" -Category AuthenticationError -RecommendedAction 'Check if the user has access.'
			return
		}
		catch [Exception]
		{
			if ($_.Exception.GetType().Name -eq "COMException")
			{
				Write-Verbose "Could not connect to $($ComputerName) via WMI - Connectivity Issues"
				Write-Error -Message "Connectivity Issues - Could not access computer system details from $($ComputerName) via WMI" -Category ConnectionError -RecommendedAction 'Check if the computer name is correct and the firewall is off.'
				return
			}
			else
			{
				Write-Verbose "Could not connect to $($ComputerName) via WMI - Unknown Error"
				Write-Error -Message "Unknown Error - Could not access computer system details from $($ComputerName) via WMI" -Category NotSpecified
				return
			}
		}
		Try
		{
			Write-Verbose "Getting Operating System details"
			$OperatingSystemDetails = Get-WmiObject -ComputerName $ComputerName -Class Win32_OperatingSystem -ErrorAction Stop
			Write-Verbose "Operating System Details Gathered."
		}
		catch
		{
			Write-Verbose "Could not get operating system details from $ComputerName via WMI"
			Write-Error -Message "Could not get operating system details from $($ComputerName) via WMI" -Category ConnectionError -RecommendedAction 'Check if the user has access and the firewall is off.'
		}
		Try
		{
			Write-Verbose "Getting Network Details"
			$NetworkConfigurationDetails = Get-WmiObject -ComputerName $ComputerName -Class Win32_NetworkAdapterConfiguration -ErrorAction Stop
			Write-Verbose "Network Details Gathered"
		}
		Catch
		{
			Write-Verbose "Could not get network details from $ComputerName via WMI"
			Write-Error -Message "Could not get network details from $($ComputerName) via WMI" -Category ConnectionError -RecommendedAction 'Check if the user has access and the firewall is off.'
		}
		
		switch ($OperatingSystemDetails.OSLanguage) {
			1 { $OSLanguage = 'Arabic' }
			4 { $OSLanguage = 'Chinese – China' }
			9 { $OSLanguage = 'English' }
			1025 { $OSLanguage = 'Arabic – Saudi Arabia' }
			1026 { $OSLanguage = 'Bulgarian' }
			1027 { $OSLanguage = 'Catalan' }
			1028 { $OSLanguage = 'Chinese  – Taiwan' }
			1029 { $OSLanguage = 'Czech' }
			1030 { $OSLanguage = 'Danish' }
			1031 { $OSLanguage = 'German – Germany' }
			1032 { $OSLanguage = 'Greek' }
			1033 { $OSLanguage = 'English – United States' }
			1034 { $OSLanguage = 'Spanish – Traditional Sort' }
			1035 { $OSLanguage = 'Finnish' }
			1036 { $OSLanguage = 'French – France' }
			1037 { $OSLanguage = 'Hebrew' }
			1038 { $OSLanguage = 'Hungarian' }
			1039 { $OSLanguage = 'Icelandic' }
			1040 { $OSLanguage = 'Italian – Italy' }
			1041 { $OSLanguage = 'Japanese' }
			1042 { $OSLanguage = 'Korean' }
			1043 { $OSLanguage = 'Dutch – Netherlands' }
			1044 { $OSLanguage = 'Norwegian – Bokmal' }
			1045 { $OSLanguage = 'Polish' }
			1046 { $OSLanguage = 'Portuguese – Brazil' }
			1047 { $OSLanguage = 'Rhaeto-Romanic' }
			1048 { $OSLanguage = 'Romanian' }
			1049 { $OSLanguage = 'Russian' }
			1050 { $OSLanguage = 'Croatian' }
			1051 { $OSLanguage = 'Slovak' }
			1052 { $OSLanguage = 'Albanian' }
			1053 { $OSLanguage = 'Swedish' }
			1054 { $OSLanguage = 'Thai' }
			1055 { $OSLanguage = 'Turkish' }
			1056 { $OSLanguage = 'Urdu' }
			1057 { $OSLanguage = 'Indonesian' }
			1058 { $OSLanguage = 'Ukrainian' }
			1059 { $OSLanguage = 'Belarusian' }
			1060 { $OSLanguage = 'Slovenian' }
			1061 { $OSLanguage = 'Estonian' }
			1062 { $OSLanguage = 'Latvian' }
			1063 { $OSLanguage = 'Lithuanian' }
			1065 { $OSLanguage = 'Persian' }
			1066 { $OSLanguage = 'Vietnamese' }
			1069 { $OSLanguage = 'Basque ' }
			1070 { $OSLanguage = 'Serbian' }
			1071 { $OSLanguage = 'Macedonian ' }
			1072 { $OSLanguage = 'Sutu' }
			1073 { $OSLanguage = 'Tsonga' }
			1074 { $OSLanguage = 'Tswana' }
			1076 { $OSLanguage = 'Xhosa' }
			1077 { $OSLanguage = 'Zulu' }
			1078 { $OSLanguage = 'Afrikaans' }
			1080 { $OSLanguage = 'Faeroese' }
			1081 { $OSLanguage = 'Hindi' }
			1082 { $OSLanguage = 'Maltese' }
			1084 { $OSLanguage = 'Scottish Gaelic ' }
			1085 { $OSLanguage = 'Yiddish' }
			1086 { $OSLanguage = 'Malay – Malaysia' }
			2049 { $OSLanguage = 'Arabic – Iraq' }
			2052 { $OSLanguage = 'Chinese  – PRC' }
			2055 { $OSLanguage = 'German – Switzerland' }
			2057 { $OSLanguage = 'English – United Kingdom' }
			2058 { $OSLanguage = 'Spanish – Mexico' }
			2060 { $OSLanguage = 'French – Belgium' }
			2064 { $OSLanguage = 'Italian – Switzerland' }
			2067 { $OSLanguage = 'Dutch – Belgium' }
			2068 { $OSLanguage = 'Norwegian – Nynorsk' }
			2070 { $OSLanguage = 'Portuguese – Portugal' }
			2072 { $OSLanguage = 'Romanian – Moldova' }
			2073 { $OSLanguage = 'Russian – Moldova' }
			2074 { $OSLanguage = 'Serbian – Latin' }
			2077 { $OSLanguage = 'Swedish – Finland' }
			3073 { $OSLanguage = 'Arabic – Egypt' }
			3076 { $OSLanguage = 'Chinese  – Hong Kong SAR' }
			3079 { $OSLanguage = 'German – Austria' }
			3081 { $OSLanguage = 'English – Australia' }
			3082 { $OSLanguage = 'Spanish – International Sort' }
			3084 { $OSLanguage = 'French – Canada' }
			3098 { $OSLanguage = 'Serbian – Cyrillic' }
			4097 { $OSLanguage = 'Arabic – Libya' }
			4100 { $OSLanguage = 'Chinese  – Singapore' }
			4103 { $OSLanguage = 'German – Luxembourg' }
			4105 { $OSLanguage = 'English – Canada' }
			4106 { $OSLanguage = 'Spanish – Guatemala' }
			4108 { $OSLanguage = 'French – Switzerland' }
			5121 { $OSLanguage = 'Arabic – Algeria' }
			5127 { $OSLanguage = 'German – Liechtenstein' }
			5129 { $OSLanguage = 'English – New Zealand' }
			5130 { $OSLanguage = 'Spanish – Costa Rica' }
			5132 { $OSLanguage = 'French – Luxembourg' }
			6145 { $OSLanguage = 'Arabic – Morocco' }
			6153 { $OSLanguage = 'English – Ireland' }
			6154 { $OSLanguage = 'Spanish – Panama' }
			7169 { $OSLanguage = 'Arabic – Tunisia' }
			7177 { $OSLanguage = 'English – South Africa' }
			7178 { $OSLanguage = 'Spanish – Dominican Republic' }
			8193 { $OSLanguage = 'Arabic – Oman' }
			8201 { $OSLanguage = 'English – Jamaica' }
			8202 { $OSLanguage = 'Spanish – Venezuela' }
			9217 { $OSLanguage = 'Arabic – Yemen' }
			9226 { $OSLanguage = 'Spanish – Colombia' }
			10241 { $OSLanguage = 'Arabic – Syria' }
			10249 { $OSLanguage = 'English – Belize' }
			10250 { $OSLanguage = 'Spanish – Peru' }
			11265 { $OSLanguage = 'Arabic – Jordan' }
			11273 { $OSLanguage = 'English – Trinidad' }
			11274 { $OSLanguage = 'Spanish – Argentina' }
			12289 { $OSLanguage = 'Arabic – Lebanon' }
			12298 { $OSLanguage = 'Spanish – Ecuador' }
			13313 { $OSLanguage = 'Arabic – Kuwait' }
			13322 { $OSLanguage = 'Spanish – Chile' }
			14337 { $OSLanguage = 'Arabic – U.A.E.' }
			14346 { $OSLanguage = 'Spanish – Uruguay' }
			15361 { $OSLanguage = 'Arabic – Bahrain' }
			15370 { $OSLanguage = 'Spanish – Paraguay' }
			16385 { $OSLanguage = 'Arabic – Qatar' }
			16394 { $OSLanguage = 'Spanish – Bolivia' }
			17418 { $OSLanguage = 'Spanish – El Salvador' }
			18442 { $OSLanguage = 'Spanish – Honduras' }
			19466 { $OSLanguage = 'Spanish – Nicaragua' }
			20490 { $OSLanguage = 'Spanish – Puerto Rico' }
			
			default { $OSLanguage = 'Unknown'}
		}
		$BootTime = $([Management.ManagementDateTimeConverter]::ToDateTime($OperatingSystemDetails.LastBootUpTime))
		$CurrentTime = $([Management.ManagementDateTimeConverter]::ToDateTime($OperatingSystemDetails.LocalDateTime))
		$Uptime = New-TimeSpan -Start $BootTime -End $CurrentTime
		
		Clear-Variable -Name AdaptersWithIPs -ErrorAction SilentlyContinue | Out-Null
		Clear-Variable -Name AdaptersSpeed -ErrorAction SilentlyContinue | Out-Null
		$AdaptersWithIPs = @()
		foreach ($a in $NetworkConfigurationDetails)
		{
			if (
			$a.IPAddress -gt "" -or $a.IPAddress.count -gt 1)
			{
				$AdaptersWithIPs += $a
			}
		}
		$AdapterDescription = [string]::join(“ ; ”, ($AdaptersWithIPs.Description))
		$IPAddresses = [string]::join(“ ; ”, ($AdaptersWithIPs.IPAddress))
		$DefaultGateway = [string]::join(“ ; ”, ($AdaptersWithIPs.DefaultIPGateway))
		$DNSSearchOrder = [string]::join(“ ; ”, ($AdaptersWithIPs.DNSServerSearchOrder))
		$MACAddresses = [string]::join(“ ; ”, ($AdaptersWithIPs.MACAddress))
		$DHCPEnabled = [string]::join(“ ; ”, ($AdaptersWithIPs.DHCPEnabled))
		
		$Obj = New-Object -TypeName System.Management.Automation.PSObject
		$Obj | Add-Member -Type NoteProperty -Name 'InputHostName' -Value $ComputerName
		$Obj | Add-Member -Type NoteProperty -Name 'Hostname' -Value $($ComputerSystemDetails.DNSHostName)
		$Obj | Add-Member -Type NoteProperty -Name 'OSName' -Value $($OperatingSystemDetails.Name -split '\|')[0]
		$Obj | Add-Member -Type NoteProperty -Name 'OSBuildNumber' -Value $($OperatingSystemDetails.BuildNumber)
		$Obj | Add-Member -Type NoteProperty -Name 'OSLanguage' -Value $OSLanguage
		$Obj | Add-Member -Type NoteProperty -Name 'LastBootTime' -Value $BootTime
		$Obj | Add-Member -Type NoteProperty -Name 'TotalUptime' -Value $("{0} D {1} H {2} M {3} S" -f $Uptime.Days, $Uptime.Hours, $Uptime.Minutes, $Uptime.Seconds)
		$Obj | Add-Member -Type NoteProperty -Name 'LoggedOnUser' -Value $($ComputerSystemDetails.Username)
		$Obj | Add-Member -Type NoteProperty -Name 'NetworkAdapter' -Value $AdapterDescription
		$Obj | Add-Member -Type NoteProperty -Name 'IPAddresses' -Value $IPAddresses
		$Obj | Add-Member -Type NoteProperty -Name 'DefaultGateways' -Value $DefaultGateway
		$Obj | Add-Member -Type NoteProperty -Name 'DNSSearchOrder' -Value $DNSSearchOrder
		$Obj | Add-Member -Type NoteProperty -Name 'MACAddresses' -Value $MACAddresses
		$Obj | Add-Member -Type NoteProperty -Name 'DHCPEnabled' -Value $DHCPEnabled

		Write-Output $Obj
	}
	End
	{
		
	}
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

.SYNOPSIS

To gather and instantiate the servers details

.DESCRIPTION

Capsulizing WMI queries to gather and propagate new objects for output for queried servers

.PARAMETER ComputerName

Computer Name of the Server you would like to connect to.

.EXAMPLE

PS C:\> Get-NTServerDetails -ComputerName 'Value1'

.NOTES

Created by Nigel Tatschner 2015.

function Get-NTServerDetails

{

[CmdletBinding()]

[OutputType([Object])]

param

(

[Parameter(Mandatory = $true,

ValueFromPipeline = $true,

ValueFromPipelineByPropertyName = $true,

HelpMessage = 'Enter the Name of the Server you would like to connect to.')]

[Alias('ServerName')]

[string]$ComputerName

)

Begin

{

try

{

Write-Verbose "Testing Connection to Server $ComputerName"

Test-Connection -ComputerName $ComputerName -ErrorAction Stop | Out-Null

Write-Verbose "Connection to $($ComputerName) was susccessfull, moving on to wmi queries"

}

Catch

{

Write-Verbose "Could not connect to $ComputerName"

Write-Error -Message "Could not connect to $($ComputerName)" -Category ConnectionError -RecommendedAction 'Check if the computer name is correct and it is on.'

Continue

}

Process

{

try

{

Write-Verbose 'Getting Computer System details'

$ComputerSystemDetails = Get-WmiObject -ComputerName $ComputerName -Class Win32_ComputerSystem -ErrorAction Stop

Write-Verbose 'Computer System Details Gathered.'

}

catch [System.UnauthorizedAccessException]

{

Write-Verbose "Could not connect to $($ComputerName) via WMI - Access Denied"

Write-Error -Message "Access Denied - Could not access computer system details from $ComputerName via WMI" -Category AuthenticationError -RecommendedAction 'Check if the user has access.'

return

}

catch [Exception]

{

if ($_.Exception.GetType().Name -eq "COMException")

{

Write-Verbose "Could not connect to $($ComputerName) via WMI - Connectivity Issues"

Write-Error -Message "Connectivity Issues - Could not access computer system details from $($ComputerName) via WMI" -Category ConnectionError -RecommendedAction 'Check if the computer name is correct and the firewall is off.'

return

}

else

{

Write-Verbose "Could not connect to $($ComputerName) via WMI - Unknown Error"

Write-Error -Message "Unknown Error - Could not access computer system details from $($ComputerName) via WMI" -Category NotSpecified

return

}

Try

{

Write-Verbose "Getting Operating System details"

$OperatingSystemDetails = Get-WmiObject -ComputerName $ComputerName -Class Win32_OperatingSystem -ErrorAction Stop

Write-Verbose "Operating System Details Gathered."

}

catch

{

Write-Verbose "Could not get operating system details from $ComputerName via WMI"

Write-Error -Message "Could not get operating system details from $($ComputerName) via WMI" -Category ConnectionError -RecommendedAction 'Check if the user has access and the firewall is off.'

}

Try

{

Write-Verbose "Getting Network Details"

$NetworkConfigurationDetails = Get-WmiObject -ComputerName $ComputerName -Class Win32_NetworkAdapterConfiguration -ErrorAction Stop

Write-Verbose "Network Details Gathered"

}

Catch

{

Write-Verbose "Could not get network details from $ComputerName via WMI"

Write-Error -Message "Could not get network details from $($ComputerName) via WMI" -Category ConnectionError -RecommendedAction 'Check if the user has access and the firewall is off.'

}

switch ($OperatingSystemDetails.OSLanguage) {

1 { $OSLanguage = 'Arabic' }

4 { $OSLanguage = 'Chinese – China' }

9 { $OSLanguage = 'English' }

1025 { $OSLanguage = 'Arabic – Saudi Arabia' }

1026 { $OSLanguage = 'Bulgarian' }

1027 { $OSLanguage = 'Catalan' }

1028 { $OSLanguage = 'Chinese – Taiwan' }

1029 { $OSLanguage = 'Czech' }

1030 { $OSLanguage = 'Danish' }

1031 { $OSLanguage = 'German – Germany' }

1032 { $OSLanguage = 'Greek' }

1033 { $OSLanguage = 'English – United States' }

1034 { $OSLanguage = 'Spanish – Traditional Sort' }

1035 { $OSLanguage = 'Finnish' }

1036 { $OSLanguage = 'French – France' }

1037 { $OSLanguage = 'Hebrew' }

1038 { $OSLanguage = 'Hungarian' }

1039 { $OSLanguage = 'Icelandic' }

1040 { $OSLanguage = 'Italian – Italy' }

1041 { $OSLanguage = 'Japanese' }

1042 { $OSLanguage = 'Korean' }

1043 { $OSLanguage = 'Dutch – Netherlands' }

1044 { $OSLanguage = 'Norwegian – Bokmal' }

1045 { $OSLanguage = 'Polish' }

1046 { $OSLanguage = 'Portuguese – Brazil' }

1047 { $OSLanguage = 'Rhaeto-Romanic' }

1048 { $OSLanguage = 'Romanian' }

1049 { $OSLanguage = 'Russian' }

1050 { $OSLanguage = 'Croatian' }

1051 { $OSLanguage = 'Slovak' }

1052 { $OSLanguage = 'Albanian' }

1053 { $OSLanguage = 'Swedish' }

1054 { $OSLanguage = 'Thai' }

1055 { $OSLanguage = 'Turkish' }

1056 { $OSLanguage = 'Urdu' }

1057 { $OSLanguage = 'Indonesian' }

1058 { $OSLanguage = 'Ukrainian' }

1059 { $OSLanguage = 'Belarusian' }

1060 { $OSLanguage = 'Slovenian' }

1061 { $OSLanguage = 'Estonian' }

1062 { $OSLanguage = 'Latvian' }

1063 { $OSLanguage = 'Lithuanian' }

1065 { $OSLanguage = 'Persian' }

1066 { $OSLanguage = 'Vietnamese' }

1069 { $OSLanguage = 'Basque ' }

1070 { $OSLanguage = 'Serbian' }

1071 { $OSLanguage = 'Macedonian ' }

1072 { $OSLanguage = 'Sutu' }

1073 { $OSLanguage = 'Tsonga' }

1074 { $OSLanguage = 'Tswana' }

1076 { $OSLanguage = 'Xhosa' }

1077 { $OSLanguage = 'Zulu' }

1078 { $OSLanguage = 'Afrikaans' }

1080 { $OSLanguage = 'Faeroese' }

1081 { $OSLanguage = 'Hindi' }

1082 { $OSLanguage = 'Maltese' }

1084 { $OSLanguage = 'Scottish Gaelic ' }

1085 { $OSLanguage = 'Yiddish' }

1086 { $OSLanguage = 'Malay – Malaysia' }

2049 { $OSLanguage = 'Arabic – Iraq' }

2052 { $OSLanguage = 'Chinese – PRC' }

2055 { $OSLanguage = 'German – Switzerland' }

2057 { $OSLanguage = 'English – United Kingdom' }

2058 { $OSLanguage = 'Spanish – Mexico' }

2060 { $OSLanguage = 'French – Belgium' }

2064 { $OSLanguage = 'Italian – Switzerland' }

2067 { $OSLanguage = 'Dutch – Belgium' }

2068 { $OSLanguage = 'Norwegian – Nynorsk' }

2070 { $OSLanguage = 'Portuguese – Portugal' }

2072 { $OSLanguage = 'Romanian – Moldova' }

2073 { $OSLanguage = 'Russian – Moldova' }

2074 { $OSLanguage = 'Serbian – Latin' }

2077 { $OSLanguage = 'Swedish – Finland' }

3073 { $OSLanguage = 'Arabic – Egypt' }

3076 { $OSLanguage = 'Chinese – Hong Kong SAR' }

3079 { $OSLanguage = 'German – Austria' }

3081 { $OSLanguage = 'English – Australia' }

3082 { $OSLanguage = 'Spanish – International Sort' }

3084 { $OSLanguage = 'French – Canada' }

3098 { $OSLanguage = 'Serbian – Cyrillic' }

4097 { $OSLanguage = 'Arabic – Libya' }

4100 { $OSLanguage = 'Chinese – Singapore' }

4103 { $OSLanguage = 'German – Luxembourg' }

4105 { $OSLanguage = 'English – Canada' }

4106 { $OSLanguage = 'Spanish – Guatemala' }

4108 { $OSLanguage = 'French – Switzerland' }

5121 { $OSLanguage = 'Arabic – Algeria' }

5127 { $OSLanguage = 'German – Liechtenstein' }

5129 { $OSLanguage = 'English – New Zealand' }

5130 { $OSLanguage = 'Spanish – Costa Rica' }

5132 { $OSLanguage = 'French – Luxembourg' }

6145 { $OSLanguage = 'Arabic – Morocco' }

6153 { $OSLanguage = 'English – Ireland' }

6154 { $OSLanguage = 'Spanish – Panama' }

7169 { $OSLanguage = 'Arabic – Tunisia' }

7177 { $OSLanguage = 'English – South Africa' }

7178 { $OSLanguage = 'Spanish – Dominican Republic' }

8193 { $OSLanguage = 'Arabic – Oman' }

8201 { $OSLanguage = 'English – Jamaica' }

8202 { $OSLanguage = 'Spanish – Venezuela' }

9217 { $OSLanguage = 'Arabic – Yemen' }

9226 { $OSLanguage = 'Spanish – Colombia' }

10241 { $OSLanguage = 'Arabic – Syria' }

10249 { $OSLanguage = 'English – Belize' }

10250 { $OSLanguage = 'Spanish – Peru' }

11265 { $OSLanguage = 'Arabic – Jordan' }

11273 { $OSLanguage = 'English – Trinidad' }

11274 { $OSLanguage = 'Spanish – Argentina' }

12289 { $OSLanguage = 'Arabic – Lebanon' }

12298 { $OSLanguage = 'Spanish – Ecuador' }

13313 { $OSLanguage = 'Arabic – Kuwait' }

13322 { $OSLanguage = 'Spanish – Chile' }

14337 { $OSLanguage = 'Arabic – U.A.E.' }

14346 { $OSLanguage = 'Spanish – Uruguay' }

15361 { $OSLanguage = 'Arabic – Bahrain' }

15370 { $OSLanguage = 'Spanish – Paraguay' }

16385 { $OSLanguage = 'Arabic – Qatar' }

16394 { $OSLanguage = 'Spanish – Bolivia' }

17418 { $OSLanguage = 'Spanish – El Salvador' }

18442 { $OSLanguage = 'Spanish – Honduras' }

19466 { $OSLanguage = 'Spanish – Nicaragua' }

20490 { $OSLanguage = 'Spanish – Puerto Rico' }

default { $OSLanguage = 'Unknown'}

}

$BootTime = $([Management.ManagementDateTimeConverter]::ToDateTime($OperatingSystemDetails.LastBootUpTime))

$CurrentTime = $([Management.ManagementDateTimeConverter]::ToDateTime($OperatingSystemDetails.LocalDateTime))

$Uptime = New-TimeSpan -Start $BootTime -End $CurrentTime

Clear-Variable -Name AdaptersWithIPs -ErrorAction SilentlyContinue | Out-Null

Clear-Variable -Name AdaptersSpeed -ErrorAction SilentlyContinue | Out-Null

$AdaptersWithIPs = @()

foreach ($a in $NetworkConfigurationDetails)

{

if (

$a.IPAddress -gt "" -or $a.IPAddress.count -gt 1)

{

$AdaptersWithIPs += $a

}

$AdapterDescription = [string]::join(“ ; ”, ($AdaptersWithIPs.Description))

$IPAddresses = [string]::join(“ ; ”, ($AdaptersWithIPs.IPAddress))

$DefaultGateway = [string]::join(“ ; ”, ($AdaptersWithIPs.DefaultIPGateway))

$DNSSearchOrder = [string]::join(“ ; ”, ($AdaptersWithIPs.DNSServerSearchOrder))

$MACAddresses = [string]::join(“ ; ”, ($AdaptersWithIPs.MACAddress))

$DHCPEnabled = [string]::join(“ ; ”, ($AdaptersWithIPs.DHCPEnabled))

$Obj = New-Object -TypeName System.Management.Automation.PSObject

$Obj | Add-Member -Type NoteProperty -Name 'InputHostName' -Value $ComputerName

$Obj | Add-Member -Type NoteProperty -Name 'Hostname' -Value $($ComputerSystemDetails.DNSHostName)

$Obj | Add-Member -Type NoteProperty -Name 'OSName' -Value $($OperatingSystemDetails.Name -split '\|')[0]

$Obj | Add-Member -Type NoteProperty -Name 'OSBuildNumber' -Value $($OperatingSystemDetails.BuildNumber)

$Obj | Add-Member -Type NoteProperty -Name 'OSLanguage' -Value $OSLanguage

$Obj | Add-Member -Type NoteProperty -Name 'LastBootTime' -Value $BootTime

$Obj | Add-Member -Type NoteProperty -Name 'TotalUptime' -Value $("{0} D {1} H {2} M {3} S" -f $Uptime.Days, $Uptime.Hours, $Uptime.Minutes, $Uptime.Seconds)

$Obj | Add-Member -Type NoteProperty -Name 'LoggedOnUser' -Value $($ComputerSystemDetails.Username)

$Obj | Add-Member -Type NoteProperty -Name 'NetworkAdapter' -Value $AdapterDescription

$Obj | Add-Member -Type NoteProperty -Name 'IPAddresses' -Value $IPAddresses

$Obj | Add-Member -Type NoteProperty -Name 'DefaultGateways' -Value $DefaultGateway

$Obj | Add-Member -Type NoteProperty -Name 'DNSSearchOrder' -Value $DNSSearchOrder

$Obj | Add-Member -Type NoteProperty -Name 'MACAddresses' -Value $MACAddresses

$Obj | Add-Member -Type NoteProperty -Name 'DHCPEnabled' -Value $DHCPEnabled

Write-Output $Obj

}

End

{

}

Get-NTUpTime

June 8, 2016March 22, 2015 by Nigel Tatschner

This was an early module i wrote to get the up time of a given machine. It simply returns a string with the up time of the queried machine.

	<#
		.SYNOPSIS
			Gets the uptime of a machine

		.DESCRIPTION
			Uses Wmi class Win32_OperatingSystem to calulate the uptime of the target machine.

		.PARAMETER  ComputerName
			The Computer Name that you would like to query.

		.PARAMETER  Credentials
			Credentials for connectiong to the machine.

		.EXAMPLE
			The following commands gets the upline of the local machine and outputs it to screen in a raw format.
			PS C:\> Get-NTUptime

		.EXAMPLE
			This command returns the uptime of the machine NYC-DC01
			PS C:\> Get-NTUptime -ComputerName NYC-DC01
			
		.INPUTS
			System.String,System.Security

		.OUTPUTS
			System.TimeSpan

		.NOTES
			Calculates uptime for a given machine.

		.LINK
			http://tatux.co.uk/2015/03/22/get-ntuptime/

	#>

function Get-NTUptime
{
	[CmdletBinding()]
	param
	(
		[Parameter(ValueFromPipeline = $true,
				   ValueFromPipelineByPropertyName = $true)]
		[String[]]$ComputerName = "Localhost",
		[Parameter(ValueFromPipeline = $true,
				   ValueFromPipelineByPropertyName = $true)]
		[Switch]$Credentials = $false,
		[Parameter(ValueFromPipeline = $true,
				   ValueFromPipelineByPropertyName = $true)]
		[Switch]$Logging = $false
	)
	
	BEGIN
	{
		$NTErrorLog = "C:\NTErrorLogs\Get-NTUptime.txt"
		$Path_Test = Test-Path -Path $NTErrorLog
		$Encoding = "ASCII"
		
		if ($Logging)
		{
			if (!($Path_Test)) { New-Item -Path (Split-Path $NTErrorLog -Parent) -ItemType Container -ErrorAction SilentlyContinue; New-Item -Path (Split-Path $NTErrorLog -Parent) -Name (Split-Path $NTErrorLog -Leaf) -ItemType file -Value "Unreachable machines: `n" | Out-Null }
			else { Get-Content -Path $NTErrorLog -Force | Out-File -FilePath ("$NTErrorLog" + '_') -Append -Force -Encoding $Encoding; Clear-Content $NTErrorLog -Force | Out-Null }
		}
		
		if ($Credentials) { $credstore = Get-Credential }
	}
	PROCESS
	{
		
		Foreach ($Computer in $ComputerName)
		{
			
			Try
			{
				
				$Computer_Active = $true
				$TestConnection = Test-Connection -Count 1 -ComputerName $Computer -ea Stop
				
			}
			Catch
			{
				
				Write-Warning -Message "$computer was not reachable Logging to $NTErrorLog"
				if ($Logging) { $Computer | Out-File -FilePath $NTErrorLog -Append -Encoding $Encoding -Force }
				$Computer_Active = $false
				
			}
			
			if ($Computer_Active)
			{
				
				If (!($Credentials))
				{
					$os = Get-WmiObject -class Win32_OperatingSystem -ComputerName $Computer
					$CurrentTime = ([Management.ManagementDateTimeConverter]::ToDateTime($os.LocaldateTime))
					$CurrentUptime = ([Management.ManagementDateTimeConverter]::ToDateTime($os.LastBootUpTime))
					
					$calc = New-TimeSpan -Start $CurrentUptime -end $CurrentTime
					
					$uptime = "The System Has been up for {0} Days, {1} Hours, {2} Minutes and {3} Seconds" -f $Calc.Days, $Calc.Hours, $Calc.Minutes, $Calc.Seconds
					
					Write-Output -InputObject $uptime
				}
				Else
				{
					$os = Get-WmiObject -class Win32_OperatingSystem -ComputerName $Computer -Credential $credstore
					$CurrentTime = ([Management.ManagementDateTimeConverter]::ToDateTime($os.LocaldateTime))
					$CurrentUptime = ([Management.ManagementDateTimeConverter]::ToDateTime($os.LastBootUpTime))
					
					$calc = New-TimeSpan -Start $CurrentUptime -end $CurrentTime
					
					$uptime = "The System Has been up for {0} Days, {1} Hours, {2} Minutes and {3} Seconds" -f $Calc.Days, $Calc.Hours, $Calc.Minutes, $Calc.Seconds
					
					return $uptime
					
				}
			}
		}
		
	}
	END { }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

.SYNOPSIS

Gets the uptime of a machine

.DESCRIPTION

Uses Wmi class Win32_OperatingSystem to calulate the uptime of the target machine.

.PARAMETER ComputerName

The Computer Name that you would like to query.

.PARAMETER Credentials

Credentials for connectiong to the machine.

.EXAMPLE

The following commands gets the upline of the local machine and outputs it to screen in a raw format.

PS C:\> Get-NTUptime

.EXAMPLE

This command returns the uptime of the machine NYC-DC01

PS C:\> Get-NTUptime -ComputerName NYC-DC01

.INPUTS

System.String,System.Security

.OUTPUTS

System.TimeSpan

.NOTES

Calculates uptime for a given machine.

.LINK

http://tatux.co.uk/2015/03/22/get-ntuptime/

function Get-NTUptime

{

[CmdletBinding()]

param

(

[Parameter(ValueFromPipeline = $true,

ValueFromPipelineByPropertyName = $true)]

[String[]]$ComputerName = "Localhost",

[Parameter(ValueFromPipeline = $true,

ValueFromPipelineByPropertyName = $true)]

[Switch]$Credentials = $false,

[Parameter(ValueFromPipeline = $true,

ValueFromPipelineByPropertyName = $true)]

[Switch]$Logging = $false

)

BEGIN

{

$NTErrorLog = "C:\NTErrorLogs\Get-NTUptime.txt"

$Path_Test = Test-Path -Path $NTErrorLog

$Encoding = "ASCII"

if ($Logging)

{

if (!($Path_Test)) { New-Item -Path (Split-Path $NTErrorLog -Parent) -ItemType Container -ErrorAction SilentlyContinue; New-Item -Path (Split-Path $NTErrorLog -Parent) -Name (Split-Path $NTErrorLog -Leaf) -ItemType file -Value "Unreachable machines: `n" | Out-Null }

else { Get-Content -Path $NTErrorLog -Force | Out-File -FilePath ("$NTErrorLog" + '_') -Append -Force -Encoding $Encoding; Clear-Content $NTErrorLog -Force | Out-Null }

}

if ($Credentials) { $credstore = Get-Credential }

}

PROCESS

{

Foreach ($Computer in $ComputerName)

{

Try

{

$Computer_Active = $true

$TestConnection = Test-Connection -Count 1 -ComputerName $Computer -ea Stop

}

Catch

{

Write-Warning -Message "$computer was not reachable Logging to $NTErrorLog"

if ($Logging) { $Computer | Out-File -FilePath $NTErrorLog -Append -Encoding $Encoding -Force }

$Computer_Active = $false

}

if ($Computer_Active)

{

If (!($Credentials))

{

$os = Get-WmiObject -class Win32_OperatingSystem -ComputerName $Computer

$CurrentTime = ([Management.ManagementDateTimeConverter]::ToDateTime($os.LocaldateTime))

$CurrentUptime = ([Management.ManagementDateTimeConverter]::ToDateTime($os.LastBootUpTime))

$calc = New-TimeSpan -Start $CurrentUptime -end $CurrentTime

$uptime = "The System Has been up for {0} Days, {1} Hours, {2} Minutes and {3} Seconds" -f $Calc.Days, $Calc.Hours, $Calc.Minutes, $Calc.Seconds

Write-Output -InputObject $uptime

}

Else

{

$os = Get-WmiObject -class Win32_OperatingSystem -ComputerName $Computer -Credential $credstore

$CurrentTime = ([Management.ManagementDateTimeConverter]::ToDateTime($os.LocaldateTime))

$CurrentUptime = ([Management.ManagementDateTimeConverter]::ToDateTime($os.LastBootUpTime))

$calc = New-TimeSpan -Start $CurrentUptime -end $CurrentTime

$uptime = "The System Has been up for {0} Days, {1} Hours, {2} Minutes and {3} Seconds" -f $Calc.Days, $Calc.Hours, $Calc.Minutes, $Calc.Seconds

return $uptime

}

END { }

}

Get-NTSoftware

June 8, 2016March 20, 2015 by Nigel Tatschner

<#
	.SYNOPSIS
		Querie WMI for MSI installed applications.
		
	.DESCRIPTION
		Queries WMI for applications installed by MSI by calling the Win32_Product class,
		all parameters are optional and the -Computer Parameter and be piped to by name only and have multiple entries.

	.PARAMETER  Computername
		Specifies the computer to query, can be an array of computers and can be name piped to.
		Default is localhost.

	.PARAMETER  Software
		Used to search for specific software, e.g *java* or "Java Auto Updater". Wrap strings with Double quotations (").
		Default is "*" wildcard meaning all items.
		
	.PARAMETER  Uninstall
		Uninstalls all found software using the Uninstall() Method.
		
	.PARAMETER  Credentials
		This Switch specifies credentials for remote machines. 
		Just using -Credentials will prompt you to enter your credentials when executing the command.
	
	.PARAMETER Showprogress
		
		Shows the progress on a per machine basis(works better if you have a few machines to check on).
		Default is off.
	
	.EXAMPLE
		This will query the local machine for anything installed like "Java" and return it to screen.
		PS C:\> Get-NTSoftware -Software "*java*"
		
		This will export all Software installed in the local machine to a file called File.csv With only the Name and installed date selected.
		PS C:\> Get-NTSoftware | Select-Object -Property name,InstallDate | Export-Csv -Path C:\MyPath\File.csv -NoTypeInformation
		
		This Searches for software on the computers in the file C:\ListofComputers.txt that match "*Java*" and return it to screen.
		PS C:\> Get-NTSoftware -Software "*java*" -Computername (Get-Content -Path C:\ListofComputers.txt)

	.EXAMPLE
		This will ask you for your credentials and query the machine BAD-USER and BAD-USER2 for any software that matches the term "*itunes*" and returns it to screen with a progress bar.
		PS C:\> Get-NTSoftware -Credentials -Computername BAD-USER,BAD-USER2 -Software "*iTunes*" -showprogress
		
		This will to the same as the command above but then uninstall the software and display a return code
		(0 usually means it was successful, 1603 usually means no permissions)
		PS C:\> Get-NTSoftware -Credentials -Computername BAD-USER,BAD-USER2 -Software "*iTunes*" -Uninstall

	.NOTES
		Please note that the Win32_Product is quite inefficient as it uses windows installer to query every application installed to gather
		the information and dose a "reconfiguration" in the process, this is bad if you have disabled a service for a msi installed app because in the process it
		dose a repair on the app and if there are any issues it will fix them first and then move on and this means reactivating disabled services etc.
	
	.LINK
		http://tatux.co.uk/2015/03/20/get-ntsoftware/
#>

function Get-NTSoftware {
	
	[CmdletBinding()] 
		
		param(
			
			[Parameter(ValueFromPipelineByPropertyName=$True,ValueFromPipeline=$True)]
			[System.String[]]$Computername = "localhost",
			
			$Software = "*",
			
			[Switch]$Uninstall = $false,
			
			[Switch]$Credentials = $false,
			
			[Switch]$Showprogress = $false
		)
		
	BEGIN { 
	
		$NTErrorLog = "C:\NTErrorLogs\Get-NTSoftware.txt"
		$Path_Test = Test-Path -Path $NTErrorLog
		$Encoding = "ASCII"
				
		if (!($Path_Test)) {New-Item -Path (Split-Path $NTErrorLog -Parent) -ItemType Container -ErrorAction SilentlyContinue ; New-Item -Path (Split-Path $NTErrorLog -Parent) -Name (Split-Path $NTErrorLog -Leaf) -ItemType file -Value "Unreachable machines: `n" | Out-Null}
		else {Get-Content -Path $NTErrorLog -Force | Out-File -FilePath ("$NTErrorLog" + '_') -Append -Force -Encoding $Encoding ; Clear-Content $NTErrorLog -Force | Out-Null}
				
		if ($Credentials) { $credstore = Get-Credential }
	
		$Count = (100 / ($Computername).Count -as [Decimal])
		[Decimal]$Complete = "0"
		
		
		}
			
	PROCESS{
		
		Foreach ($Computer in $Computername) {
		
		try {
			
			$Computer_Active = $true
			$TestConnection = Test-Connection -Count 1 -ComputerName $Computer -ea Stop
				
		} catch {
			
			Write-Warning -Message "$computer was not reachable Logging to $NTErrorLog"
			$Computer | Out-File -FilePath $NTErrorLog -Append -Encoding $Encoding -Force
			$Computer_Active = $false
			
		}
			if ($Computer_Active) {
				if ($Showprogress) {Write-Progress -Activity "Looking for $Software on $Computer" -CurrentOperation "Connecting to WMI on $Computer" -PercentComplete $Complete}
				
				if ($Credentials) { $Var1 = Get-WmiObject -Credential $credstore -Class Win32_Product -ComputerName $Computer | Where-Object {$_.name -Like "$Software"} }
				else { $Var1 = Get-WmiObject -Class Win32_Product -ComputerName $Computer | Where-Object {$_.name -Like "$Software"} }
				
				Write-Output -InputObject $Var1
										
				if ($Uninstall) { $Var1.Uninstall()  }
				
				$Complete +=$Count
								
				}
				
			if ($Showprogress) {Write-Progress -Activity "Finished with $Computer" -CurrentOperation "Done" -PercentComplete $Complete}	
		}
		
		
		if ($Showprogress) {Write-Progress -Activity "Done" -Completed}
		
	}
	END{}
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

.SYNOPSIS

Querie WMI for MSI installed applications.

.DESCRIPTION

Queries WMI for applications installed by MSI by calling the Win32_Product class,

all parameters are optional and the -Computer Parameter and be piped to by name only and have multiple entries.

.PARAMETER Computername

Specifies the computer to query, can be an array of computers and can be name piped to.

Default is localhost.

.PARAMETER Software

Used to search for specific software, e.g *java* or "Java Auto Updater". Wrap strings with Double quotations (").

Default is "*" wildcard meaning all items.

.PARAMETER Uninstall

Uninstalls all found software using the Uninstall() Method.

.PARAMETER Credentials

This Switch specifies credentials for remote machines.

Just using -Credentials will prompt you to enter your credentials when executing the command.

.PARAMETER Showprogress

Shows the progress on a per machine basis(works better if you have a few machines to check on).

Default is off.

.EXAMPLE

This will query the local machine for anything installed like "Java" and return it to screen.

PS C:\> Get-NTSoftware -Software "*java*"

This will export all Software installed in the local machine to a file called File.csv With only the Name and installed date selected.

PS C:\> Get-NTSoftware | Select-Object -Property name,InstallDate | Export-Csv -Path C:\MyPath\File.csv -NoTypeInformation

This Searches for software on the computers in the file C:\ListofComputers.txt that match "*Java*" and return it to screen.

PS C:\> Get-NTSoftware -Software "*java*" -Computername (Get-Content -Path C:\ListofComputers.txt)

.EXAMPLE

This will ask you for your credentials and query the machine BAD-USER and BAD-USER2 for any software that matches the term "*itunes*" and returns it to screen with a progress bar.

PS C:\> Get-NTSoftware -Credentials -Computername BAD-USER,BAD-USER2 -Software "*iTunes*" -showprogress

This will to the same as the command above but then uninstall the software and display a return code

(0 usually means it was successful, 1603 usually means no permissions)

PS C:\> Get-NTSoftware -Credentials -Computername BAD-USER,BAD-USER2 -Software "*iTunes*" -Uninstall

.NOTES

Please note that the Win32_Product is quite inefficient as it uses windows installer to query every application installed to gather

the information and dose a "reconfiguration" in the process, this is bad if you have disabled a service for a msi installed app because in the process it

dose a repair on the app and if there are any issues it will fix them first and then move on and this means reactivating disabled services etc.

.LINK

http://tatux.co.uk/2015/03/20/get-ntsoftware/

function Get-NTSoftware {

[CmdletBinding()]

param(

[Parameter(ValueFromPipelineByPropertyName=$True,ValueFromPipeline=$True)]

[System.String[]]$Computername = "localhost",

$Software = "*",

[Switch]$Uninstall = $false,

[Switch]$Credentials = $false,

[Switch]$Showprogress = $false

)

BEGIN {

$NTErrorLog = "C:\NTErrorLogs\Get-NTSoftware.txt"

$Path_Test = Test-Path -Path $NTErrorLog

$Encoding = "ASCII"

if (!($Path_Test)) {New-Item -Path (Split-Path $NTErrorLog -Parent) -ItemType Container -ErrorAction SilentlyContinue ; New-Item -Path (Split-Path $NTErrorLog -Parent) -Name (Split-Path $NTErrorLog -Leaf) -ItemType file -Value "Unreachable machines: `n" | Out-Null}

else {Get-Content -Path $NTErrorLog -Force | Out-File -FilePath ("$NTErrorLog" + '_') -Append -Force -Encoding $Encoding ; Clear-Content $NTErrorLog -Force | Out-Null}

if ($Credentials) { $credstore = Get-Credential }

$Count = (100 / ($Computername).Count -as [Decimal])

[Decimal]$Complete = "0"

}

PROCESS{

Foreach ($Computer in $Computername) {

try {

$Computer_Active = $true

$TestConnection = Test-Connection -Count 1 -ComputerName $Computer -ea Stop

} catch {

Write-Warning -Message "$computer was not reachable Logging to $NTErrorLog"

$Computer | Out-File -FilePath $NTErrorLog -Append -Encoding $Encoding -Force

$Computer_Active = $false

}

if ($Computer_Active) {

if ($Showprogress) {Write-Progress -Activity "Looking for $Software on $Computer" -CurrentOperation "Connecting to WMI on $Computer" -PercentComplete $Complete}

if ($Credentials) { $Var1 = Get-WmiObject -Credential $credstore -Class Win32_Product -ComputerName $Computer | Where-Object {$_.name -Like "$Software"} }

else { $Var1 = Get-WmiObject -Class Win32_Product -ComputerName $Computer | Where-Object {$_.name -Like "$Software"} }

Write-Output -InputObject $Var1

if ($Uninstall) { $Var1.Uninstall() }

$Complete +=$Count

}

if ($Showprogress) {Write-Progress -Activity "Finished with $Computer" -CurrentOperation "Done" -PercentComplete $Complete}

}

if ($Showprogress) {Write-Progress -Activity "Done" -Completed}

}

END{}

}

Generate-NTPassword

June 8, 2016March 20, 2015 by Nigel Tatschner

<#
	.SYNOPSIS
		Generates a password based on a series of characters in a random order
	
	.DESCRIPTION
		Generates a password based on a series of characters in a random order
	
	.PARAMETER length
		Length of the password to generate
	
	.NOTES
		Additional information about the function.
#>
function Generate-NTPassword
{
	[CmdletBinding()]
	param
	(
		[Parameter(HelpMessage = 'Enter length of the password you would like to generate in numbers')]
		[int]$length = 10
	)
		
	$SourceData = $NULL; For ($a = 33; $a –le 126; $a++) { $SourceData +=, [char][byte]$a } # Converts numbers to legal character bytes for output
	
	For ($loop = 1; $loop –le $length; $loop++)
	{
		# Loops for the ammount of length specified
		
		$Password += ($SourceData | Get-Random) # Gets a randon character from list and stores it for output
		
	}
	
	$Props = @{ 'Password' = $Password } # Creates the property for the output object
	
	$Password = New-Object -TypeName PSObject -Property $Props # creates the output object
	
	Write-Output $Password
} # End of the function

.SYNOPSIS

Generates a password based on a series of characters in a random order

.DESCRIPTION

Generates a password based on a series of characters in a random order

.PARAMETER length

Length of the password to generate

.NOTES

Additional information about the function.

function Generate-NTPassword

{

[CmdletBinding()]

param

(

[Parameter(HelpMessage = 'Enter length of the password you would like to generate in numbers')]

[int]$length = 10

)

$SourceData = $NULL; For ($a = 33; $a –le 126; $a++) { $SourceData +=, [char][byte]$a } # Converts numbers to legal character bytes for output

For ($loop = 1; $loop –le $length; $loop++)

{

# Loops for the ammount of length specified

$Password += ($SourceData | Get-Random) # Gets a randon character from list and stores it for output

}

$Props = @{ 'Password' = $Password } # Creates the property for the output object

$Password = New-Object -TypeName PSObject -Property $Props # creates the output object

Write-Output $Password

} # End of the function

This function generates a secure password, it can be used inside other functions/scripts.

Simply import-module .\Generate-PasswordNT and by default it creates a random 10 character long password.

Use the length parameter to extend the password length for increased security.

Get-NTMailHistory

June 8, 2016March 9, 2015 by Nigel Tatschner

<#
	.SYNOPSIS
		Used to received data for sent and received items in Microsoft Exchange for a user defined amount of days in the past and output it to various source.
	
	.DESCRIPTION
		Used to received data for sent and received items in Microsoft Exchange for a user defined amount of days in the past and output it to various source.
	
	.PARAMETER Days
		Number of days in the past to gather from
	
	.PARAMETER Type
		Specifies what type of information to return, be it Send, Received or Both
	
	.PARAMETER ExchangeServerFQDN
		DNS Name of the Microsoft Exchange Server.
	
	.PARAMETER Credentials
		Credentials to use when connecting to the Microsoft Exchange Server
	
	.PARAMETER ExchangeServer
		DNS Name of the Microsoft Exchange Server.
	
	.EXAMPLE
		PS C:\> Get-NTMailHistory -Days $value1 -ExchangeServerIP $value2
	
	.OUTPUTS
		PSObject
	
	.NOTES
		http://tatux.co.uk/2015/03/09/get-ntmailhistory/
#>
function Get-NTMailHistory
{
	[CmdletBinding(DefaultParameterSetName = 'Default')]
	[OutputType([PSObject], ParameterSetName = 'Default')]
	[OutputType([psobject])]
	param
	(
		[Parameter(ParameterSetName = 'Default',
				   HelpMessage = 'Enter the number of days to search for. 1 being the default and 30 being the maximum.')]
		[ValidateRange(1, 30)]
		[int]
		$Days = 1,
		[Parameter(ParameterSetName = 'Default',
				   HelpMessage = 'Enter Sent, Received or Both for a return of that value')]
		[ValidateSet("Sent", "Received", "Both")]
		[string]
		$Type = "Both",
		[Parameter(ParameterSetName = 'Default',
				   Mandatory = $true,
				   HelpMessage = 'Enter the IP or Host name of the exchnage server you would like to query.')]
		[ValidateLength(3, 15)]
		[Alias('ExSvrDNS')]
		[string]
		$ExchangeServerFQDN,
		[Parameter(ParameterSetName = 'Default',
				   ValueFromPipeline = $true,
				   ValueFromPipelineByPropertyName = $true,
				   HelpMessage = 'Provide PSCredetials Object')]
		[Alias('Creds')]
		[pscredential]
		$Credentials
	)
	
	Begin
	{
		Write-Verbose "Testing to see if the exchnage modules are loaded..."
		
		Get-Command Get-Mailbox -WarningAction 'SilentlyContinue' | Out-Null
		
		if ($? -eq $false)
		{
			if ($ExchangeServerFQDN -gt $null)
			{
				if ($Credentials -gt $null)
				{
					$exchangesession = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri ("http://" + "$ExchangeServerFQDN" + "/PowerShell/") -Authentication Kerberos -Credential $Credentials
				}
				else
				{
					$exchangesession = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri ("http://" + "$ExchangeServerFQDN" + "/PowerShell/") -Authentication Kerberos
				}
				
			}
			Import-PSSession $exchangesession -DisableNameChecking | Out-Null
			
		}
		else
		{
			Write-Verbose "Connection to exchange is already active."
		}
	}
	Process
	{
		$i = 1
		$Range = 1..$Days
		foreach ($a in $Range)
		{
			[DateTime]$DateItem = (Get-Date 00:00:00).AddDays(- $i); $i++
			$EndDate = $DateItem.AddDays(1)
			$Messages = Get-MessageTrackingLog -Start $DateItem -End $EndDate -Resultsize Unlimited
			$MessagesReceived = ($Messages | Where-Object -Property EventID -EQ Receive)
			$MessagesSent = ($Messages | Where-Object -Property EventID -EQ Send)
			$AllMailItems = $MessagesReceived + $MessagesSent
			
			Switch -regex ($Type)
			{
				Both { Write-Output $AllMailItems }
				Sent { Write-Output $MessagesSent }
				Received { Write-Output $MessagesReceived }
				Default { Write-Output $AllMailItems }
			}
		}
	}
	END
	{
	}
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

.SYNOPSIS

Used to received data for sent and received items in Microsoft Exchange for a user defined amount of days in the past and output it to various source.

.DESCRIPTION

Used to received data for sent and received items in Microsoft Exchange for a user defined amount of days in the past and output it to various source.

.PARAMETER Days

Number of days in the past to gather from

.PARAMETER Type

Specifies what type of information to return, be it Send, Received or Both

.PARAMETER ExchangeServerFQDN

DNS Name of the Microsoft Exchange Server.

.PARAMETER Credentials

Credentials to use when connecting to the Microsoft Exchange Server

.PARAMETER ExchangeServer

DNS Name of the Microsoft Exchange Server.

.EXAMPLE

PS C:\> Get-NTMailHistory -Days $value1 -ExchangeServerIP $value2

.OUTPUTS

PSObject

.NOTES

http://tatux.co.uk/2015/03/09/get-ntmailhistory/

function Get-NTMailHistory

{

[CmdletBinding(DefaultParameterSetName = 'Default')]

[OutputType([PSObject], ParameterSetName = 'Default')]

[OutputType([psobject])]

param

(

[Parameter(ParameterSetName = 'Default',

HelpMessage = 'Enter the number of days to search for. 1 being the default and 30 being the maximum.')]

[ValidateRange(1, 30)]

[int]

$Days = 1,

[Parameter(ParameterSetName = 'Default',

HelpMessage = 'Enter Sent, Received or Both for a return of that value')]

[ValidateSet("Sent", "Received", "Both")]

[string]

$Type = "Both",

[Parameter(ParameterSetName = 'Default',

Mandatory = $true,

HelpMessage = 'Enter the IP or Host name of the exchnage server you would like to query.')]

[ValidateLength(3, 15)]

[Alias('ExSvrDNS')]

[string]

$ExchangeServerFQDN,

[Parameter(ParameterSetName = 'Default',

ValueFromPipeline = $true,

ValueFromPipelineByPropertyName = $true,

HelpMessage = 'Provide PSCredetials Object')]

[Alias('Creds')]

[pscredential]

$Credentials

)

Begin

{

Write-Verbose "Testing to see if the exchnage modules are loaded..."

Get-Command Get-Mailbox -WarningAction 'SilentlyContinue' | Out-Null

if ($? -eq $false)

{

if ($ExchangeServerFQDN -gt $null)

{

if ($Credentials -gt $null)

{

$exchangesession = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri ("http://" + "$ExchangeServerFQDN" + "/PowerShell/") -Authentication Kerberos -Credential $Credentials

}

else

{

$exchangesession = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri ("http://" + "$ExchangeServerFQDN" + "/PowerShell/") -Authentication Kerberos

}

Import-PSSession $exchangesession -DisableNameChecking | Out-Null

}

else

{

Write-Verbose "Connection to exchange is already active."

}

Process

{

$i = 1

$Range = 1..$Days

foreach ($a in $Range)

{

[DateTime]$DateItem = (Get-Date 00:00:00).AddDays(- $i); $i++

$EndDate = $DateItem.AddDays(1)

$Messages = Get-MessageTrackingLog -Start $DateItem -End $EndDate -Resultsize Unlimited

$MessagesReceived = ($Messages | Where-Object -Property EventID -EQ Receive)

$MessagesSent = ($Messages | Where-Object -Property EventID -EQ Send)

$AllMailItems = $MessagesReceived + $MessagesSent

Switch -regex ($Type)

{

Both { Write-Output $AllMailItems }

Sent { Write-Output $MessagesSent }

Received { Write-Output $MessagesReceived }

Default { Write-Output $AllMailItems }

}

END

{

}