{"id":2136,"date":"2011-05-18T13:32:12","date_gmt":"2011-05-18T12:32:12","guid":{"rendered":"https:\/\/www.peppercrew.nl\/index.php\/2011\/05\/maintenance-mode-report-in-scom-fixed\/"},"modified":"2011-05-19T15:13:37","modified_gmt":"2011-05-19T14:13:37","slug":"maintenance-mode-report-in-scom-fixed","status":"publish","type":"post","link":"https:\/\/ingmarverheij.com\/en\/maintenance-mode-report-in-scom-fixed\/","title":{"rendered":"Maintenance mode report in SCOM (fixed)"},"content":{"rendered":"

Object, like computers, in System Center Operations Manager (SCOM) can be placed in a maintenance mode. While the object is in maintenance mode no alerts will be generated, as expected.<\/p>\n

I wanted to see which objects have been placed in maintenance mode, unfortunately there is no default report supplied by Microsoft.<\/p>\n

Fortunately Alain C\u00f4te wrote a report, along with a stored procedure, which enables me the insights requested. The management pack, containing the report and stored procedure, can be downloaded here: Maintenance Mode History Report Management Pack<\/a><\/p>\n

There is one instruction missing in the documentation, additional permissions are required to run the stored procedure required by the report. Without the permissions the following error is displayed:<\/p>\n

\"Query<\/a><\/p>\n

<\/p>\n

If you execute the report via a webpage, for instance on the reporting server, you whould get the following error:<\/p>\n

\"The<\/a><\/p>\n

 <\/p>\n

So the resolution to the problem is fairly easy, give the Datawarehouse Read Account EXECUTE permissions on the object’ SearchMaintMode’. This can be done following these steps:<\/p>\n

1. Open Microsoft SQL Server Managemend Studio;
\n2. Connect to the SQL server hosting the OperationsManagerDW database;
\n3. Browse to DatabasesOperationsManagerDWProgrammabilityStored Procedures’;
\n4. Open the properties of the SP ‘dbo.SearchMaintMode’;
\n5. Select the page ‘Permission’ (on the left);
\n6. Click Search;
\n7. Search your DRA account (for instance SVC_SCOM_DRA);
\n8. Grant the permission ‘Execute’ (third row, first checkbox);
\n9. Okay, you’re done!<\/p>\n

\"image\"<\/a>\"image\"<\/a><\/p>\n

 <\/p>\n

Ingmar Verheij<\/p>","protected":false},"excerpt":{"rendered":"

Object, like computers, in System Center Operations Manager (SCOM) can be placed in a maintenance mode. While the object is in maintenance mode no alerts will be generated, as expected. I wanted to see which objects have been placed in maintenance mode, unfortunately there is no default report supplied by Microsoft. Fortunately Alain C\u00f4te wrote […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[311],"tags":[284,285,286,235],"class_list":["post-2136","post","type-post","status-publish","format-standard","hentry","category-system-center-operations-manager-scom","tag-maintenance-mode","tag-query-failed-for-data-set-operationsmanagerdw","tag-report","tag-scom"],"_links":{"self":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/2136","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/comments?post=2136"}],"version-history":[{"count":5,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/2136\/revisions"}],"predecessor-version":[{"id":2574,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/2136\/revisions\/2574"}],"wp:attachment":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/media?parent=2136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/categories?post=2136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/tags?post=2136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}