Powershell - IT - Solutions - Blog (Page 2)

Converting CSV to JSON (PowerShell)

This article has not been completed yet. However, it may already contain helpful Information and therefore it has been published at this stage Import-Module .\CSV2Json.psm1 Get-Module -Name CSV2Json Get-Command -Module CSV2JsonConvert-CSV2JsonConvert-CSV2JsonWithParam -inputFiles "C:\temp\query_data_16_02_2022.csv" -delimiter ","Convert-CSV2JsonWithParam -inputFiles

How to set the Desktop Background via PowerShell

This article has not been completed yet. However, it may already contain helpful Information and therefore it has been published at this stage. <#PSScriptInfo .VERSION 1.0.0.0 .GUID 084a184a-faa1-47e4-9f1a-5d9ecede68c3 .AUTHOR Jeffrey Snover .COMPANYNAME .COPYRIGHT .TAGS .LICENSEURI .PROJECTURI .ICONURI .EXTERNALMODULEDEPENDENCIES .REQUIREDSCRIPTS .EXTERNALSCRIPTDEPENDENCIES

How to Execute a Stored Procedure in MS SQL Using PowerShell

This article has not been completed yet. However, it may already contain helpful information and therefore it has been published at this stage. Generating some Template Tables..... CREATE TABLE Product (ProductID INT, ProductName VARCHAR(100) ) GO CREATE TABLE ProductDescription (ProductID INT, ProductDescription VARCHAR(800)

AWS (Amazon Web Service)

How to Create a Key Pair for EC2 Instances (AWS)

This article has not been completed yet. However, it may already contain helpful information and therefore it has been published at this stage. Introduction: #ec2-user Conlusio: Sources:General prerequisites for connecting to your instance - Amazon Elastic Compute CloudBefore you connect to your Linux

How to transfer netdrives using PowerShell

IntroductionEvery sysadmin knows the problem. An employee moves to a new workstation, notebook or takes over the duties of another employee. In all these cases, the need to take over the network drives of the old device or the colleague may arise. In this

How to work with JSON via PowerShell

In this article, you will learn how to persistently store parameters for your scripts. PrerequisitesPSv3 (PowerShell 3.0) and upIDE (integrated development environment) - Power Shell ISE / Visual Studio CodeIntroduction:With almost every project that is based on PowerShell, I ask myself how and

Installing OpenSSH (Windows)

Prerequisites: ChocolateyInstallation (serverside):# Installation via Choco choco install openssh -y -f # Neustart Restart-Computer -Force # Check Version ssh -Vssh -V # Change folder cd "C:\Program Files\OpenSSH-Win64" # Running Installation & Setup-Script powershell.exe -ExecutionPolicy Bypass -File install-sshd.ps1 # Creating needed Firewall Rule New-NetFirewallRule

WebJea Introduction - a web-based PowerShell Self Service Portal (for free)

It is probably a well-known problem in IT. More services are to be provided with the same number of IT employees. Mostly this is due to a natural development, e.g. that a new IT system or a new IT service has been added,

Exchange Online

How to display mailbox sizes sorted by size

Below a small powershell script with which you can connect to Office 365 and retrieve all mailboxes by size. # Prequisites: # Install Chocolatey # Set-ExecutionPolicy Bypass -Scope Process -Force; iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1')) # Install Powershell Version 5.1 # choco

How to make the Powershell the default shell on a server core

When you sign in into Windows Server Core the first time, you will quickly notice that Cmd.exe is opened as the default shell. This may not sound critical as you normally configure a server core remotely, but it is still sometimes annoying. I

AZ-104 Preparations - Lab 1: "Deploy and Manage Virtual Machines" - Task 2

Task 2:Deploy an Azure VM running Windows Server 2019 Datacenter into an existing availability set by using Azure PowerShell From the Azure Portal, start a PowerShell session in the Cloud Shell pane.Note: If this is the first time you are launching the

Exchange Online

How to get Office 365 to accept mails from your homepage (contact form)

Recently, a customer had his homepage redesigned without my knowledge, in the belief that this does not require consultation and interaction with me. Unfortunately they didn't think about the dependency to their mail system, whose migration to Office 365 or Exchange Online was done

Managing File System Access Control Lists (Powershell)

Today I had to copy the permissions from one folder to another folder. Instead of doing this manually, I tried to do it with Powershell. And I succeeded... Here are my experiences with it.... Obtaining the ACL for files and folders:get-acl <folder&

Simplest way to gather Input information (Powershell)

For each of my scripts I try to make them as easy as possible so that I have as little effort as necessary to solve an already solved problem again when I use it one more time. To make this possible, I often use

Create a Wifi QR-Code (PowerShell)

Installation of the necessary module: Install-Module QRCodeGenerator Complete all needed steps to create a QR Code: # Allow unlimited execution of scripts Set-ExecutionPolicy Unrestrict # Import the module you just installed Import-Module QRCodeGenerator # Assign WIFI Variables $wifissid = <SSID> $pwd = <password> $path = "

How to access OneDrive (Office 365) of a deleted user account (Powershell)

Today, one of my supervisors asked me if I could recover the data from a former employee's OneDrive (whose account has been deleted). So I got right down to work and started researching on that topic. The result is this script: # Requirements: # - Azure

Relative File Paths in Powershell

My first intensive use of PowerShell was for scripting software installations/configurations. From development to deployment, I couldn’t guarantee the absolute file path of my script and any supporting files would be constant. I needed my script to be able to figure out

How to query the execution path of a service (PowerShell)

Sometime you have to kill a process related to a service. To identify the process it is necessary to know the underlying service executable. Below you will find a small guide (using PowerShell), demonstrating how I managed to do this for Adobe's Update Service.

Disk management with PowerShell: initialize, partition, format

Windows offers a historically grown collection of tools for disk management, both for the graphical user interface and the command line (diskpart, chkdsk, defrag, format.....) But as you hopefully know, PowerShell is state of the art... So here is the way to manage hard

FSMO - Role Transfer (NTDSUTIL | Powershell)

Introduction:Recently the support for Windows Server 2008 & 2008 R2 has expired (14.01.2020 (see references at the end of the blog post). For this reason, it is highly probable that there are currently a number of projects for IT service providers

Run a PowerShell Scripts from Task Scheduler

PowerShell is the de facto scripting language in Windows environments. Microsoft has even decreed that all software units must be able to be managed by using PowerShell cmdlets. This means that we need to learn how to run scripts from the Task Scheduler. Left