Powershell – Execute Windows Update On All Windows Servers in Active Directory

A powershell script to run Windows Updates on all Windows Servers in Active Directory   Part 1: Build a list of all Windows Servers in Active Directory # # Get all Windows Servers (Windows Server version 2016/2019/2022) # $Computers = Get-ADComputer -Properties * -Filter { OperatingSystem -like “*Windows Server*” } …

Obtaining MSI productcodes via powershell

To obtain the productcode of an MSI installed application, you can search the Windows registry at the following locations: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall However, there is an easier way obtaining the productcodes of all installed applications through powershell by executing the following command: get-wmiobject Win32_Product | sort name | Format-Table IdentifyingNumber, Name, …

Packer – introduction

What is Packer Packer is a simple, easy open source tool from HashiCorp that runs on all major operating systems and is ued to create identical machine images for different platforms from a single source configuration template. Packer Templates A Packer templates is a json formatted file containing the build …

VMware Horizon View – Script to create Persona Management Repositories, Shares and Permissions

When setting up VMware Horizon View Persona Management, one of the task to do is to create a remote repository to store the user data and settings, application-specific data, and other user-generated information in user profiles. Required persona management remote repository permissions The minimum required NTFS and share level permissions …

VMware Horizon View – Maximum concurrent connections within a certain period

Last week, I received the question from a client wether it was easy to see the maximum concurrent connections in VMware Horizon View between two distinct dates. There are several ways to do this: Through vRealize operations manager for Horizon In the standard VMware Horizon View console you can see the maximum …

VMware – SQL script to create the vCenter 4.1 database

use [master] go CREATE DATABASE [VCDB] ON PRIMARY (NAME = N’vcdb’, FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL10.VIMSQL\MSSQL\DATA\VCDB.mdf’, SIZE = 2000KB, FILEGROWTH = 10%) LOG ON (NAME = N’vcdb_log’, FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL10.VIMSQL\MSSQL\DATA\VCDB.ldf’, SIZE = 1000KB , FILEGROWTH = 10%) COLLATE SQL_Latin1_General_CP1_CI_AS go use VCDB go sp_addlogin @loginame=[vpxuser], @passwd=N’@Password’, …

VMware – SQL script to create the SRM 4.1 database

use [master] go CREATE DATABASE [SRMDB] ON PRIMARY (NAME = N’srmdb’, FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL10.VIMSQL\MSSQ\DATA\SRMDB.mdf’) LOG ON (NAME = N’srmdb_log’, FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL10.VIMSQL\MSSQ\DATA\SRMDB.ldf’) COLLATE SQL_Latin1_General_CP1_CI_AS go use SRMDB go sp_addlogin @loginame=[srm], @passwd=N’@Password’, @defdb=’SRMDB’, @deflanguage=’us_english’ go ALTER LOGIN [srm] WITH CHECK_POLICY = OFF go CREATE USER …

VMware – Powershell

How te get started with Powershell. Download and install Powershell from https://docs.microsoft.com/en-us/powershell/  Powershell 1.0: http://support.microsoft.com/kb/926139 Powershell 2.0: http://support.microsoft.com/kb/968930 Add Registry key HKLM\Software\Microsoft\PowerShell\1\ShellIds\Microsoft.PowerShell\ExecutionPolicy and set to “RemoteSigned” (REG_SZ) Download and install VMware PowerCLI from http://www.vmware.com/go/powershell Download and install vEcoshell from http://thevesi.org/ Download and install VMWare community Powerpack from http://powergui.org/entry.jspa?externalID=2551&categoryID=290 References: Powershell …