Month: September 2021

blog.KimConnect.com >>
Post Image

Read More

September 30, 2021September 30, 2021 kimconnectkimconnect

PowerShell: Remove A-record in Bluecat

$bluecatUri='https://bluecat.kimconnect.com/Services/API' $bluecatUsername='bluecat-service-api' $bluecatPassword='SOMECOMPLEXPASSWORD' $hostRecord='testrecord.kimconnect.com' function loginBluecat{ param( $username, $password, $uri ) $proxy = New-WebServiceProxy -Uri…
0 Comments
Post Image

Read More

September 29, 2021September 29, 2021 kimconnectkimconnect

PowerShell: Get SQL Job History

$computername='sql01' function getSqlJobHistory($sqlServerName){ try{ if(!(get-module SqlServer)){ Install-Module -Name SqlServer } Import-Module -Name SqlServer $sqlServerInstance=Get-SqlInstance -ServerInstance…
0 Comments
Post Image

Read More

September 29, 2021September 29, 2021 kimconnectkimconnect

PowerShell: Get SQL Server Backup Statuses

$computername='sql01' function getSqlBackupInfo ($sqlInstanceName=$env:computername, $dbName){ [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") $location=if($sqlInstanceName.Contains("`\")){ "SQLSERVER:\SQL\$sqlInstanceName\Databases" }else{ "SQLSERVER:\SQL\$sqlInstanceName\DEFAULT\Databases" } function getPacificTime($time){ if($time){ [System.TimeZoneInfo]::ConvertTimeBySystemTimeZoneId($time,'Pacific…
0 Comments
Post Image

Read More

September 28, 2021September 28, 2021 kimconnectkimconnect

Using SysPrep To Move Windows Users Directory

Assumptions: Windows 2019 Server Standard ISO is mounted as E:\ D:\Users will be the new…
0 Comments
Post Image

Read More

September 27, 2021September 27, 2021 kimconnectkimconnect

WordPress: Remove ‘Built with Storefront & WooCommerce’ in footer

Credit: @jobthomas Automattic Happiness Engineerhttps://wordpress.org/support/topic/remove-built-with-storefront-footer-link-2/ How to apply: search and install Code Snippets > add…
0 Comments
Post Image

Read More

September 24, 2021September 24, 2021 kimconnectkimconnect

Use PowerShell to Set Microsoft SQL Database Owner

$owner='CAP\SQL Admins' $databaseName='TestDb' $sqlServer=$env:computername function setDbOwner{ param( $principle=$env:USERDOMAIN+'\Domain Admins', $databaseName='TestDB', $sqlServer ) function includeSqlTools{ $ErrorActionPreference='stop'…
0 Comments
Post Image

Read More

September 24, 2021September 24, 2021 kimconnectkimconnect

Use PowerShell to Grant SysAdmin Role to Certain Users

$principle=$env:USERDOMAIN+'\Domain Admins' $sqlServer=$env:computername function includeSqlTools{ $ErrorActionPreference='stop' try{ $trustedPsgallery=(Get-PSRepository PSGallery).InstallationPolicy -eq 'Trusted' if(!$trustedPsgallery){ Set-PSRepository -Name PSGallery…
0 Comments
Post Image

Read More

September 17, 2021September 17, 2021 kimconnectkimconnect

PowerShell: Auto Login to WordPress and Update Gold Prices WooCommerce Plugin

# API URI - these are examples, only $goldPriceApi='https://dragoncoin.com/XAU/USD' $silverPriceApi='https://dragoncoin.com/XAG/USD' $platinumApi='https://dragoncoin.com/XPT/USD' $palladiumApi='https://dragoncoin.com/XPD/USD' # Wordpress WooCommerce…
0 Comments
Post Image

Read More

September 17, 2021September 17, 2021 kimconnectkimconnect

WordPress: Gold Price Widget CSS

Here's a sample of CSS Code to customize the display of the WordPress' Gold Pricing…
0 Comments
Post Image

Read More

September 16, 2021September 16, 2021 kimconnectkimconnect

Windows: Disable Automatic Restart After Updates

1. Run gpedit.msc as Administrator2. Navigate to Local Group Policy Editor > Computer Configuration >…
0 Comments
Post Image

Read More

September 16, 2021September 16, 2021 kimconnectkimconnect

PowerShell: Remove IP Address Assignment Using Bluecat API

$bluecatUri='http://bluecat.kimconnect.com/Services/API' $bluecatUsername='svc-bluecat-api' $bluecatPassword='PASSWORD' $configId=17 $ipv4Address='10.10.162.54' $marker='toBeDeleted-' function confirmation($content,$testValue="I confirm",$maxAttempts=3){ $confirmed=$false; $attempts=0; $content|write-host write-host "Please review…
0 Comments
Post Image

Read More

September 16, 2021September 16, 2021 kimconnectkimconnect

PowerShell: Unjoin Computer From Domain

# unjoinComputerFromDomain.ps1 # Version 0.02 # Notes: # - This function doesn't delete the referenced…
0 Comments
Post Image

Read More

September 15, 2021September 15, 2021 kimconnectkimconnect

Windows Server 2019 Remote Desktop Black Screen Problem

While there's no definite solution to this issue, here are some options to work around…
0 Comments
Post Image

Read More

September 15, 2021September 15, 2021 kimconnectkimconnect

How to Use ImageMagic to Resize Images

Converting PNG to JPG (optimized): # This is an optimized resizing command to convert PNG…
0 Comments
Post Image

Read More

September 12, 2021September 12, 2021 kimconnectkimconnect

Excel Visual Basic For Application (VBA): Determine IP List

Set objExcel = CreateObject("Excel.Application") objExcel.Visible = True intRow = 2 Set Fso = CreateObject("Scripting.FileSystemObject") Set…
0 Comments
Post Image

Read More

September 8, 2021September 8, 2021 kimconnectkimconnect

ODBC Driver 32-bit & 64-bit

The 32-bit version: Run: odbcad32.exe > check the list of installed 32-bit drivers as illustrated…
0 Comments
Post Image

Read More

September 8, 2021September 8, 2021 kimconnectkimconnect

PowerShell: Function to Get Group Members as a Bypass Orphanated SID Errors

Problem: [TESTSERVER]: PS C:\Users\administrator> Get-LocalGroupMember 'Remote Desktop Users' Get-LocalGroupMember : Failed to compare two elements…
0 Comments
Post Image

Read More

September 7, 2021September 7, 2021 kimconnectkimconnect

CSS: How To Set Color Gradient and Animation to Text and Background

// Static color gradient .colorGradientClass { background-color: #ffffff !important; background-image: linear-gradient(315deg, #ffffff 0%, #d9d9d9 74%)…
0 Comments
Post Image

Read More

September 1, 2021September 1, 2021 kimconnectkimconnect

Uhhuh. NMI received for unknown reason 3d on CPU 4

Problem: Message from syslogd@linux03 at Aug 31 04:28:21 ... kernel:[273033.123489] Uhhuh. NMI received for unknown…
4 Comments