Automation - IT - Solutions

Exploring the Azure Update Management Center

This article has not been completed yet. However, it may already contain helpful Information and therefore it has been published at this stage. Prerequesites:An Azure account with an active

Automation

The WScript.Shell Class - a way to interact with an active Window 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. The WScript.Shell class provides a set

Cloud

Spot by Netapp (Account - Creation)

This article has not been completed yet. However, it may already contain helpful Information and therefore it has been published at this stage. Signing Up:https://console.spotinst.com/spt/

Azure

Setting Up an Azure Automation Account

This article has not been completed yet. However, it may already contain helpful Information and therefore it has been published at this stage. Prerequesites:Azure AccountAzure SubscriptionAzure Log Analytics WorkspaceRefernces:

Powershell

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

Automation

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

Azure

Remote Script Execution on Azure Arc enabled Servers using Custom Script Extension

This article has not been completed yet. However, it may already contain helpful Information and therefore it has been published at this stage. $chocolateyAppList = "microsoft-windows-terminal,microsoft-edge,7zip,notepadplusplus" if ([string]::IsNullOrWhiteSpace($chocolateyAppList) -eq $false -or [string]::IsNullOrWhiteSpace($dismAppList) -eq $false) { try{ choco config get

Azure

How to deploy MMA - Agent ( Log Analytic Workspace - Agent) on Arc enabled Server

This article has not been completed yet. However, it may already contain helpful Information and therefore it has been published at this stage. Via Azure Portal / Arc - Management - Portal:# Retrieve information about the existing Log Analytic Workspaces Get-AzOperationalInsightsWorkspace # Read out keys for

DevOps

Connecting DevOps Pipelines (Azure)

This article has not been completed yet. However, it may already contain helpful Information and therefore it has been published at this stage. Creating a Personal Access Token (PAT) Setting Up a Pipeline Trigger Task Sources: Authenticate with personal access tokens - Azure DevOpsUse

DevOps

Building my first Pipeline in Azure Devops (Azure)

This article has not been completed yet. However, it may already contain helpful Information and therefore it has been published at this stage. Creating a new Project:Importing the Code:https://github.com/codekoenig/Azure-Functions-VSCode-Demo.gitCreating the CI - Pipeline + Createing an Artifact:Deploy

AWS

Getting started with CodeStar (AWS) - Deploying a static HTML - Website via CI/CD

This article has not been completed yet. However, it may already contain helpful information and therefore it has been published at this stage. Review everything and create the poject... Clean up....

Automation

My first VBA - Project in Excel

This article has not been completed yet. However, it may already contain helpful information and therefore it has been published at this stage. Sub helloWorld() MsgBox ("Hello World!") End SubSub helloWorldtoCell() Sheets("Sheet1").Select Cells(1, 1).Value = "Hello World!" End SubExtended HelloWorld-App: The

Automation

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)

Powershell

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

Automation

Installing Ansible on Windows 10

In this short blogpost I want to go through the installation of Ansible on Windows 10. Since you need a management workstation from which you control the deployments.... Requirements: Most recent build of Windows 10 (20H2 at the time the post was created) WSL