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 | May 11, 2015 | Automation, Scripting, SysAdmin, Windows
If you want to send email from PowerShell script via Google Mail: $SMTPServer = "smtp.gmail.com" $SMTPPort = "587" $SMTPUsername = "sender@gmail.com" $SMTPPassword = "password" $EmailSenderAddress = New-Object...
by skufel | Mar 25, 2015 | Automation, Scripting, Windows
If you want to replace string in multiple files name you can simply use PowerShell for that. Dir -Recurse | Rename-Item -NewName { $_.name -replace "file","name-of-file"...
by skufel | Mar 14, 2015 | Automation, Infrastructure, Linux, SysAdmin
I use SecureCRT quite often to access Linux systems as well as network devices. When going through one of the presentations on SecureCRT web page I found handy tip how to configure session logs to have it divided by date, time and session. Screenshot below...
by skufel | Oct 21, 2014 | Automation, Infrastructure, Scripting, SysAdmin, System Center
During mass reainstallation/redeployment/migration of large number of PCs, always question about applications is raised. How to deploy/deliver applications once all machines are resintalled? If you have SCCM in the infrastructure, this might help a lot with...