Un-Escape Special Characters in ConverTTo-Json

Iterating Nested Arrays in Powershell

SHA1 Hash - Powershell

Split with Multiple Characters and Regex

Compare-Object Using Enumerable Class

New Share Creation from Powershell

New Share Creation from Powershell

Ignoring Self-signed Certificates

When using Windows PowerShell as a client, to avoid SSL Certificate trust issues if using HTTPS, enter this function in the PowerShell window:

Oracle Database Query From Powershell

• Download Oracle Data Provider for .NET (ODP.NET). (Just search for “Oracle ODP.NET”.)
  • Select “Download the latest ODP.NET production release.”
  • Select “64-bit ODAC Downloads”
  • Select “ODP.NET_Managed_ODAC12cR4.zip”
• Extract the ZIP file to C:\, which creates C:\ODP.NET_Managed_ODAC12cR4.
• Run cmd as administrator, navigate to C:\ODP.NET_Managed_ODAC12cR4, and run:
  install_odpm.bat C:\oracle\instantclient_10_2 both

In Powershell, add the DLL and set up a database connection and a query:

Script:

Add-Type -Path "C:\Users\User1\ODP.NET_Managed_ODAC12cR4\odp.net\managed\common\Oracle.ManagedDataAccess.dll"

$username = Read-Host -Prompt "Enter database username"
$password = Read-Host -Prompt "Enter database password"
$datasource = Read-Host -Prompt "Enter database TNS name"
$query = "SELECT first_name, last_name FROM users WHERE last_name = 'Lastname' ORDER BY last_name"
$connectionString = 'User Id=' + $username + ';Password=' + $password + ';Data Source=' + $datasource
$connection = New-Object Oracle.ManagedDataAccess.Client.OracleConnection($connectionString)
$connection.open()
$command=$connection.CreateCommand()
$command.CommandText=$query
$reader=$command.ExecuteReader()
while ($reader.Read()) {
$reader.GetString(1) + ', ' + $reader.GetString(0)
}
$connection.Close()

Expected Output:




User1_Firstname, Lastname
User2_Firstname, Lastname
User3_Firstname, Lastname

Powershell DSC Configuration - Pull Server

Vsphere Migration

VSphere Migration Videos

Part 1: 

VSphere Migration-part1

Part 2:

VSphere Migration-part2

Part 3:

VSphere Migration-part3

Part 4:

VSphere Migration-part4

WMI Explorer Remote Connection Issues

GUI - SETUP AND CONFIGURE POWERSHELL WEB ACCESS SERVER (GATEWAY)

Learning VSphere 6.5 -- Installing and Configuring ESXI 6.5 -- Part 1

Object Oriented Scripting in Powershell

Object Oriented Development in PowerShell. PsClass is currently implemented in Powershell in a single file. Makes it simple to use. It supports the following Object Oriented concepts.

• Inheritance
• Polymorphism
• Encapsulation
• Constructors with parameters
• Notes – read-write variables
• Methods – scriptblocks
• Properties with Get scriptblocks and optional Set scriptblocks
• Static and Private Notes and Methods

Start-Job /Passing Value Inside Script Block

Scheduled Task in Powershell

Powershell Custom Object Creation / Objects from Multiple Functions

Custom Operating System Rolling Upgrade

Deploy a Cloud Witness for a Failover Cluster

Invoke a GUI from Remote Input

Input from remote and Invoke a GUI script

cmd.exe /C "pushd \\remoteserver\FolderName && Filename && popd"