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 […]
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 […]
Today while installing SCOM in the lab faced a strange issue. When I tried to open the web console I faced this error… Microsoft.EnterpriseManagement.Presentation.DataAccess.DataProviderException: An error occurred executing the command: [Microsoft.EnterpriseManagement.Presentation.Security!DeclaredAssemblyDataProvider/GetAssemblies] in provider: [Microsoft.EnterpriseManagement.Presentation.Security.DeclaredAssemblyDataProvider, Microsoft.EnterpriseManagement.Presentation.Security, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]. : Connection session is not found.