By:
On:
In: automation, Scripting
With: 0 Comments

Background VMware wants us to prepopulate an Excel-Sheet with SSH-Keys and SSL-Thumbprints of all ESXi-Hosts, who have been freshly deployed minutes before, which effectivly protects against man-in-the-middle-attacks – maybe a problem in US-datacenters. Beginning with VMware Cloud Foundation Release VCF 4.2 the Cloud-Builder-App verifies the „CN“ of all ESXi-SSL-Certificates, which is in default-setup set to „localhost“ (to be overwritten when connecting to the vCenter so this is seemed to be no issue) – not accepted, CN has to be set to <server-fqdn>. Solution plink.exe „plink.exe“ from the Putty-Suite allows to be called from PowerShell in automated fashion without interactive Password-Prompt. (In May 2021 there seemsRead More →

By:
On:
In: Scripting
With: 0 Comments

Resize Page to Fit Contents, Set Zoom to Fit Page When the drawing is ready, the size of the page will be too large or too small – „fit to contents“ might be the solution. Additionally, I prefer the Zoom of the active Window to be set that it shows the whole drawing. ResultRead More →

By:
On:
In: Scripting
With: 0 Comments

Visualize Data from Python in Visio I needed to illustrate some data discovered by a python script in Microsoft Visio. As a starting-point i found two sources of infomation in the Internet: (1) Python => COM => MS Excel How to access a Windows COM-Application from Python: https://pbpython.com/windows-com.html MS Excel not Visio but 50% of the information needed (2) PowerShell => COM => MS Visio How to access Microsoft Visio using the COM-Interface https://www.powershellstation.com/2016/01/20/powershell-and-visio-1 PowerShell the other 50% needed. Result: „Python => COM => MS Visio“ Putting both pieces together, will allow a Python-Script to control MS Visio. (3) MS Visio „Object Model“ Without theRead More →

By:
On:
In: Azure, Cloud, Scripting
With: 0 Comments

Go to https://docs.microsoft.com/en-us/azure/virtual-machines/acu and look for: ***Hyper-threaded and capable of running nested virtualization The following „script“ pulls the SKUs out of the table: wget -O – –no-check-certificate https://docs.microsoft.com/en-us/azure/virtual-machines/acu | egrep -B2 „\*\*\*“ | egrep „data-linktype“ | sed -E „s/^.+relative-path..([^\<]+).+$/SKU: \1/g“ C:\RH>echo „Hyper-threaded and capable of running nested virtualization“ && wget -q -O – –no-check-certificate https://docs.microsoft.com/en-us/azure/virtual-machines/acu | egrep -B2 „\*\*\*“ | egrep „data-linktype“ | sed -E „s/^.+relative-path..([^\<]+).+$/SKU: \1/g““Hyper-threaded and capable of running nested virtualization“SKU: D_v3SKU: Ds_v3SKU: Dv4SKU: Dsv4SKU: Ddv4SKU: Ddsv4SKU: E_v3SKU: Es_v3SKU: Ev4SKU: Esv4SKU: Edv4SKU: Edsv4SKU: F2s_v2 – F72s_v2SKU: M Next Step? Finding one with enough memory for an acceptable price.Read More →

By:
On:
In: automation, Scripting
With: 0 Comments

The existing Windows-Comman-Script has been enhanced so it now waits until the Router-VM is up got an IP-Address assigned using DHCP. For Demonstration-Purposes an SSH-Connection will be established. The public-key of my laptop-ssh-client is part of the slipstreamed Router-Configuration. Deploy a Router-VM with hostname „CSY“. Establish an SSH-Connection to the discovered Router-IP: Have a look to the startup-config used: This is the „CMD“-Script used:Read More →

By:
On:
In: automation, Scripting
With: 0 Comments

The following version adds a „-c“ option: „Connected IP-Address“-Check. the script exits, when the Router-VM is up and running and has an usable IP-Address The Script still checks all CDP-Packets received at the specified Interface: If the Sender has the correct „Hostname“ it reads the CDP-Management-IP-Address announced. This IP-Address has to be within the IP-Range of any connected IP-Network at the specified Interface. So it’ll be possible to establish a SSH-Session to the router-VM.Read More →