Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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....
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 was part...
  • Blog Post: 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...
  • Blog Post: Reblog: Using Operations Manager Reports to Validate Your Uptime

    Source: Simple-Talk Thomas LaRock has written an article about using OpsMgr Reports to Validate (your SQL components) uptime. Check it out. You can also follow Thomas LaRock ( @sqlbatman ) on Twitter if you want.
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 configured Run on OperationsManager Database Initial query: Daniele Muscetta */...
  • Blog Post: My Operations Manager 2007 SQL Queries

    Jonathan Almquist started a blog post about Operations Manager 2007 SQL Queries . “I’m starting a new post here, similar to my Command Shell reference . This will include some useful SQL queries that I happen to need and direct my customers to on a daily basis. If you don’t see something here, check...
  • Blog Post: Designing a new Report for OpsMgr 2007

    Some time ago Jonathan Hambrook has written an article about Designing a new Report in SCOM 2007 . Although this is great article you need to have some prerequisites ready to get started with Designing your new OpsMgr 2007 Reports. Here are the prerequisites: Visual Studio 2005 or 2008 (Express) SQL...