Related Articles
PowerShell – Create “Clean” Custom Objects From DataTable Object
Posted on Author stefanroth
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 […]
OMS – HTTP Data Collector API 403 (Forbidden)
Posted on Author stefanroth
Few weeks ago Microsoft released the Azure Log Analytics HTTP Data Collector API, which allows you to shoot JSON data into OMS Log Analytics. This is awesome news, because now anything is possible. This means, you are able to use (m)any script languages to send any data to OMS for further analytics and you are […]
SCOM 2012 – Export Grey Agents using Powershell
Posted on Author stefanroth
There was a request in the TechNet forum to get all grey agents in SCOM 2012 using Powershell and export the Displayname and HealthState into a file. Because I haven’t seen a solution I thought I will share these few lines of code maybe you can use them also. #Import the OperationsManager module Import-Module OperationsManager […]