we had quite a funny period while being hit by a bug in System Center Orchestrator 2012 R2. What happened is that basically after installing UR14, we faced several issues with “Query Database” activity like multiple orphaned runbook instances, or that the configuration values of the activity got vanished upon Check-in. Continue reading Orchestrator 2012 R2 bug – SQL activity
Finally found time to post in here. Recently I’ve been working on a Powershell script that connects to a SQL 2016 database. Easy one, huh?
The problem may be using Invoke-Sqlcmd cmdlet when you’re using Windows authentication ONLY. In such cases, here’s a function I use to connect to SQL: Continue reading Powershell: Run SQL command using different credentials
I have recently played around with an error handling, also using functions.
You can explicitly define the behaviour of the script and how it should handle errors using an $ErrorActionPreference variable. You will typically set it to either of following: Continue reading Error handling in Powershell
long time no see!
As you may be aware, there has been some malware activities within last few days and your Windows environments could be affected as well. One of the recommendations is to disable SMB v1 protocol and here’s how to do it using Powershell. Continue reading How to disable SMB v1 using Powershell
I knew about this quite some time already, but never had time and apettite to do this change. Finally today I decided to use Powershell v4.0 in my Orchestrator dev environment in order to use all its wonderful features.
Continue reading Using Powershell v4.0 in your Orchestrator environment
Sometimes you may have a need to encode or encrypt a string. This is usually neccessary for strings like passwords. Continue reading Powershell and Secure/Encrypted strings
Today I will tell you a very simple guide to apply security patches to your Debian system. Continue reading Security patch Debian server
So sometimes when developing in Orchestrator you turn on object specific logging in order to debug something. It happend to me many times I forgot to turn it off, and then you forget which runbooks you turned it on for. Here’s a SQL query to execute against Orchestrator’s DB that turns off for all runbooks.
Continue reading SCORCH turn on/off object specific logging
so today I’d like to take a look at sending an e-mail from Powershell, that I’m sure many of us had to do. Continue reading Send e-mail using Powershell
sometimes you’d just like to run Powershell on remote servers but from local console. So you work locally from your PC, but get results from remote computers or servers. It can save you some time automating stuff, doing reports etc. Continue reading Enable WinRM to run remote Powershell commands