VM19_thumb.png

PowerShell – Create “Clean” Custom Objects From DataTable Object

I recently had a need to create “clean” PowerShell custom objects out of a DataTable object. What does that mean? Well, let me explain. When you try to get data out of SQL Server using PowerShell there are many ways to do it. Either you use Invoke-SQLCmd, SQL Server PowerShell (SQLPS), SQL Server Management Objects […]

SCSM – Get Service Request Object From Any Nested Child Runbook Activity

When you are starting to automate stuff in your cloud environment you probably use SMA for automation and Service Manager to trigger the necessary runbooks in SMA. As this is really great stuff you will start facing many new challenges because you have to script in PowerShell to achieve your goals. Depending on your architecture […]

PowerShell – Convert Special Character String Into Numbers

Do you know the situation where you have to handle strings / string data that has a lot of complex characters? In certain situation it is just a pain to deal with strings that have special characters like “*ç%&/()=`è or even an entire Export-CliXML output content. Recently I had the need to embed such data […]