Monthly Archives: August 2013

My frequently used SCOM Queries

I won’t take the credit for most of these queries. I have compiled them overtime from different blogs, sites /* Database size */ SELECT DB_NAME() AS DbName, name AS FileName, size/128.0 AS CurrentSizeMB, size/128.0 – CAST(FILEPROPERTY(name, ‘SpaceUsed’) AS INT)/128.0 AS FreeSpaceMB FROM sys.database_files;. … Continue reading

Posted in System Center Operations Manager | Leave a comment

Who is connected to my SCOM console

The following command will help to find who is connected to your SCOM console. This works for SCOM 2012. (Get-SCOMManagementGroup).getconnectedusernames() For SCOM 2007 you will have to use the ones below. I have not tested the below commands, though. Get-ManagementGroupConnection … Continue reading

Posted in System Center Operations Manager | Leave a comment