Hi,
this is a script to set the DNS Servers for all ESXi Hosts connected to vCenter.
Usage is very simple. Open a PowerCli Command shell. The script accept 2 parameters. “vc” = the vCenter and “s” is the a comma separarted list of DNS Servers.
PS D:\temp> .\SetHostDNS.ps1 -vc yourVCenterServer.yourdomain -s 8.8.4.4,8.8.8.8 Set DNS Server at host1.yourdomain ... ok Set DNS Server at host2.yourdomain ... ok
Thats all 🙂
Michael
Hi,
here is a “oneliner” to uninstall all Windows Update at once. They were deinstalled in order from the highest to the lowest KB Number which increases speed of the remove process(Latest fix first).
Continue reading Windows: Script to uninstall all Hotfixes and Updates
Hi,
sometimes it makes sence to write Data in a “real” Databasesystem instead of writing to a text- or xml file.
MySQL offers an native Windows .NET Connector to its Database. You can get it here.
Continue reading Powershell: Some examples to use a MySQL Database
Hi,
with a few lines Powershell code it is possible to export a Excel Workbook as a csv file.
Define your excel list
$sExcelFile="D:\temp\ExcelFile.xlsx" $sCSVFile="D:\temp\list.csv"
Open Excel using DCOM
Continue reading Powershell: Export a Excel Worksheet as csv file
Hi,
the time command in Windows gets or sets the system time. If you need an equivalent to the linux time command – which measure the execution time of a given command – you can use the powershell commandlet Measure-Command. Limitation is that only the time can measure how long the command execution runs, not splited into user, system and realtime.
Continue reading Windows: Equivalent to linux time command