Category: Codes

blog.KimConnect.com >> Codes , Database
Post Image

Read More

June 15, 2020June 15, 2020 kimconnectkimconnect

Loading the SQL Server Management Objects (SMO)

function loadSMO{ $ErrorActionPreference = "Stop" $sqlpsRegistry="HKLM:\SOFTWARE\Microsoft\PowerShell\1\ShellIds\Microsoft.SqlServer.Management.PowerShell.sqlps" try{ if (Get-ChildItem $sqlpsRegistry -ErrorAction "SilentlyContinue") { throw "SQL…
0 Comments
Post Image

Read More

June 14, 2020June 14, 2020 kimconnectkimconnect

PowerShell: Replace 1 Line in a Text File Matching Certain Values

# replaceLine -textContent $fileContent -match $url -updateLineContent $record function replaceLine($textContent,$match,$updateLineContent){ $line = $textContent | Select-String…
0 Comments
Post Image

Read More

June 14, 2020June 14, 2020 kimconnectkimconnect

PowerShell: Invoke-Command to Add A Host Record on DNS Server

# DNS Host Record Information $aRecord="superman" $recordIP='192.168.0.256' $zoneName='kimconnect.com' $dnsServer='dc01.intranet.kimconnect.com' # Admin Credential $adminUsername='DoeManeAdmin' $adminPassword='WhatPassword?' $adminCredential=New-Object…
0 Comments
Post Image

Read More

June 14, 2020June 14, 2020 kimconnectkimconnect

PowerShell: Validate SQL Server Credentials

Add this to your SQL toolbox so that it'll be quick and easy to validate…
0 Comments
Post Image

Read More

June 14, 2020June 14, 2020 kimconnectkimconnect

PowerShell: Error Unable to find package provider ‘NuGet’ Resolved

How to install module in Powow Shill Current Version: $moduleCommand='New-SSHSession' $moduleName='Posh-SSH' if(!(get-command $moduleCommand -ea Ignore)){…
0 Comments
Post Image

Read More

June 13, 2020June 13, 2020 kimconnectkimconnect

PowerShell: Convert Local Path to UNC Path

function convertLocalToUnc($localPath,$computername){ $uncPath=.{$x=$localPath -replace "^([a-zA-Z])\:","\\$computername\`$1`$"; if($x -match '\\$'){return $x.Substring(0,$x.length-1)}else{return $x} } $validLocal=if($localPath){test-path $localPath -ErrorAction SilentlyContinue}else{$false}…
2 Comments
Post Image

Read More

June 13, 2020June 13, 2020 kimconnectkimconnect

PowerShell: Stream Reader

Have you ran into scripting situations where opening a file would result in locking from…
0 Comments
Post Image

Read More

June 12, 2020June 12, 2020 kimconnectkimconnect

PowerShell: Mount A Remote SMB/CIFS/NFS Share as a Specific User

This function is useful in scenarios where a separate user account is needed to mount…
0 Comments
Post Image

Read More

June 11, 2020June 11, 2020 kimconnectkimconnect

PowerShell: Deploy Choco Apps

Deployment Instructions: Create a batch file with this content to call this PowerShell Script @echo…
0 Comments
Post Image

Read More

June 11, 2020June 11, 2020 kimconnectkimconnect

PowerShell: Outdated Method of Sending Emails

# Credentials section $emailFrom = "[email protected]" $password = "eatYourSalad!" | ConvertTo-SecureString -AsPlainText -Force # plaintext…
0 Comments
Post Image

Read More

June 4, 2020June 4, 2020 kimconnectkimconnect

BASH: Basic AWK Training

At first, AWK resembles the first three letter of 'awkward'. Nope, it's a scripting language…
0 Comments
Post Image

Read More

June 4, 2020June 4, 2020 kimconnectkimconnect

PowerShell: Reset Password for All Users inside an OU

$ouName="Funky Dudes" $ouPath = "ou=$ouName,dc=intranet,dc=baam,dc=com" $plaintextPassword='WHATPASSWORD?' $users=Get-ADUser -Filter * -SearchBase $ouPath | Select-object Name,UserPrincipalName,DistinguishedName foreach…
0 Comments
Post Image

Read More

May 31, 2020May 31, 2020 kimconnectkimconnect

Linux: How to Set Startup Script

In previous Linux versions, startup scripts can simply be enabled by linking a script into…
0 Comments
Post Image

Read More

May 26, 2020May 26, 2020 kimconnectkimconnect

PowerShell: Send Email Notifications to Computer Users Before Maintentance

# sendEmailToUsers.ps1 # Query Active Directory for computers running a Server operating system #$targetServers =…
0 Comments
Post Image

Read More

May 26, 2020May 26, 2020 kimconnectkimconnect

PowerShell: How to Create Multiple Arrays or Columns from an Array

# This snippets scans the localhost for common ports and outputs 4 arrays $limitPorts=10000 $netstat=netstat…
0 Comments
Post Image

Read More

May 26, 2020May 26, 2020 kimconnectkimconnect

PowerShell: Inter-Domain SMB Shares Mounting

# interDomainFileCopy.ps1 # Note: this is a quick and dirty method. Password security must be…
0 Comments
Post Image

Read More

May 26, 2020May 26, 2020 kimconnectkimconnect

PowerShell: Detect Whether Computer is Connected To Domain

# The easy method $domainConnected=.{ try { [void]::([System.DirectoryServices.ActiveDirectory.Domain]::GetComputerDomain()) return $true } catch{ return $false }…
0 Comments
Post Image

Read More

May 24, 2020May 24, 2020 kimconnectkimconnect

Linux: Use Lubuntu 20.04, TightVNC Server, NoVNC, WebSockify to Create a Terminal Server Accessible via Any Browser!

Use Case:Imagine a virtual classroom with students using Chromebooks, iPads, and other types of computers,…
0 Comments
Post Image

Read More

May 22, 2020May 22, 2020 kimconnectkimconnect

How to Enable GPUPDATE When Connected via OpenVPN Client

// Explanation: to prevent locking of processes, we set a proxy batch file (on_connect.bat) to…
0 Comments
Post Image

Read More

May 21, 2020May 21, 2020 kimconnectkimconnect

PowerShell: Disable Forticlient Web Filtering

# disableForticlientWebfiltering.ps1 # Note: untested script - use as sample as this snippet is incomplete…
0 Comments