Hi there!
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
Hey!
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
Hey there!
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
Hey guys,
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
Hi there,
everybody’s speaking about automation within IT, which I want to cover a little bit next time.
Sometimes a word orchestration can be heard in regards with automation. What it really is and why is it important? I’ll try to give my insight. Continue reading What is IT orchestration
Hey there!
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
Hey there!
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
Hey there!
Today I will tell you a very simple guide to apply security patches to your Debian system. Continue reading Security patch Debian server
Hey there!
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.
Hey there,
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
