by skufel | Jul 22, 2015 | Automation, Databases, Scripting, Windows
Recently I went through requirement of running SQL scripts on multiple databases on different servers. As the list of databases was different from script to script I decided to create universal solution, which will allow to easily prepare for deployment and can be...
by skufel | Oct 30, 2014 | Automation, Infrastructure, Scripting, SysAdmin, Windows
If there is a need to pass specific credentials to Get-WmiObject in order to gather information from remote machine, here is how you can do it: $LAdmin = "DOMAIN\Administrator" $LPassword = ConvertTo-SecureString "Password!" -AsPlainText -Force...
by skufel | Dec 5, 2013 | Automation, Infrastructure, Scripting, Windows
Some handy wmic commands which might be helpful when automating OS deployment: wmic bios get serialnumber wmic computersystem get manufacturer wmic computersystem get model
by skufel | Oct 24, 2013 | Automation, Infrastructure, Scripting, SysAdmin, Windows
Handful list of parameters possible to use in CMD scripts: %~I - expands %I removing any surrounding quotes ("") %~fI - expands %I to a fully qualified path name %~dI - expands %I to a drive letter only %~pI - expands %I to a...
by skufel | Jan 2, 2013 | Automation, Scripting, Windows
From script repository I did use in the past, VBscript which allows to clear EvenLog on Windows machine. I did use that on computers with Windows XP and Windows Server 2003. however, this script will work also on Windows 7 and Windows server 2008. By default script...
