Clarification on SQL Server Collation Requirements for System Center 2012

We have published a new blogpost on the System Center: Operations Manager Engineering Team Blog about SQL Server Collation Requirements.   “There has been quite a bit of confusion over the requirements for SQL Server collation for the various components of System Center. We didn’t make a coordinated effort here to make this as easy…

0

Who put the RMS in Maintenance Mode? (2nd update)

I was investigating an issue with OpsMgr Agents who where stuck in Maintenance Mode. A big help was this article from David Dixon. We managed to solve the issue but we also wanted to know what caused the issue and I investigated if the RMS HealthService was put in Maintenance Mode accidentally. By the way,…

2

Documenting your OperationsManager Databases? Use PowerShell!

I’ve already blogged a couple of times about ways to document your Operations Manager Databases. First I showed you to use SQLSpec from ElsaSoft, a couple days ago I told you you can find more information about the OperationsManagerDW schema in the new Reporting Documentation. And now I’m telling you, you can use PowerShell to…

0

SQL query for AD Integration

Have you ever wanted to check if AD Integration is enabled for an Agent using a SQL query? Today I wanted to do that and I created the next SQL Query. You may find it usefull. /*Find all Agent where AD Integration is configuredRun on OperationsManager DatabaseInitial query: Daniele Muscetta*/SELECT bme.DisplayName, mths.ActiveDirectoryManagedFROM MT_HealthService mths INNER…

0

Reblog: Find Database Sizes With Operations Manager

Source: Thomas LaRock Thomas LaRock has published a SQL query I had not seen before, about finding the OpsMgr Database Sizes. Could be handy to know. [Thomas LaRock] “I was asked last week if  knew a query that would return the size of the databases that have been discovered by Operations Manager. I went about…

0

OpsMgr SQL Full or Differential Backup Check

I helped a customer creating a OpsMgr Monitor for checking if the there has been a SQL Full or Differential Backup within a specified number of hours. David Scheltens created the SQL query. Remark: Please read information on System Center Central for more info on this article. This is how you could create this kind…

7

OpsMgr Custom Reporting Tips & Tricks

Lately I’ve been busy creating some OpsMgr Custom Reports for customers and wanted to share some tips & tricks for creating custom OpsMgr Reports. Hope you can use them in your own custom OpsMgr Reports. First some background info on what to use for creating Custom OpsMgr Reports. What do I need for creating Custom…

2

User Logon Time Report for Operations Manager 2007

A customer was asking for some information about the time it took for users to logon on their Terminal Server hosted Windows Desktops. Luckily there were two eventID’s created during the logon process.  And if you calculate the time between those eventID’s then you have some insight in the Logon time for a user. When…

1

PowerShell: State Changes for a specified Monitor

This week a got a question from a customer about ‘flapping’ taking place from a Monitor. I found out that they meant the State Changes that took place for a newly created Monitor. They found out that for a certain machine the State changed quite often and this was caused by a Recovery Task that…

2

Everything you wanted to know about OpsMgr Data Warehouse Grooming but were afraid to ask

I know there are already quite some other blog posts about OpsMgr Data Warehouse Grooming.  But I was helping a customer with grooming their OpsMgr Data Warehouse Database (OperationsManagerdw) and got some questions. And you may have the same questions but you are afraid to ask 😉 How can I change the Grooming settings for…

4