{"id":47,"date":"2012-10-03T12:00:49","date_gmt":"2012-10-03T11:00:49","guid":{"rendered":"http:\/\/www.symablog.de\/blog\/?p=47"},"modified":"2013-01-29T08:37:39","modified_gmt":"2013-01-29T07:37:39","slug":"server-maintenance-report","status":"publish","type":"post","link":"https:\/\/www.symablog.de\/blog\/server-maintenance-report\/","title":{"rendered":"Server Maintenance-Report erstellen"},"content":{"rendered":"<p>F\u00fcr einen definierten Server kann man den Maintenance-Mode Report aus dem DataWarehouse anzeigen, mittels Powershell-Skript oder SQL.<\/p>\n<p><strong>SQL Query<\/strong>:<br \/>\n<span style=\"color: #0000ff;\">USE<\/span> OperationsManagerDW<br \/>\n<span style=\"color: #0000ff;\">SELECT<\/span> ManagedEntity.DisplayName, MaintenanceModeHistory.*<br \/>\n<span style=\"color: #0000ff;\">FROM<\/span> ManagedEntity WITH (NOLOCK)<br \/>\nINNER JOIN<br \/>\nMaintenanceMode ON ManagedEntity.ManagedEntityRowId = MaintenanceMode.ManagedEntityRowId<br \/>\nINNER JOIN<br \/>\nMaintenanceModeHistory ON MaintenanceMode.MaintenanceModeRowId = MaintenanceModeHistory.MaintenanceModeRowId<br \/>\n<span style=\"color: #0000ff;\">WHERE<\/span> DisplayName Like &#8218;%servername%&#8216;<\/p>\n<p><strong>Powershell-Skript:<\/strong><br \/>\n$servername = &#8222;SCOM24301P.KP24.DE&#8220;<br \/>\n$mc = get-monitoringClass -name Microsoft.Windows.Computer<br \/>\n$mo = get-monitoringObject -monitoringClass $mc | where {$_.name -eq &#8218;$servername&#8216;}<br \/>\n$mo | get-maintenanceWindow -history<\/p>\n<p><strong>Output:<\/strong><br \/>\nMonitoringObjectId      : drv23dgwu-w3r4-b3c4-d3h6-wh2h45g7ibje<br \/>\nStartTime                       : 10.09 2012 07:28:55<br \/>\nScheduledEndTime       : 10.09.2012 08:28:55<br \/>\nEndTime                         : 10.09.2012 08:30:11<br \/>\nReason                            : PlannedApplicationMaintenance<br \/>\nComments                      : Patch and Update<br \/>\nUser                                : KP24\\ua301<br \/>\nLastModified                 : 10.09.2012 08:30:11<br \/>\nManagementGroup     : KP24_SCOM_PROD<br \/>\nManagementGroupId : drv23dgwu-w3r4-b3c4-d3h6-wh2h45g7ibje<\/p>\n<p><a href=\"http:\/\/www.symablog.de\/blog\/links\/bk_motherboards\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-53\" title=\"Board-1\" src=\"http:\/\/www.symablog.de\/blog\/wp-content\/uploads\/Board-1-300x199.jpg\" alt=\"Motherboard I - Copyright Bj\u00f6rn Kaninke 2012\" width=\"300\" height=\"199\" srcset=\"https:\/\/www.symablog.de\/blog\/wp-content\/uploads\/Board-1-300x199.jpg 300w, https:\/\/www.symablog.de\/blog\/wp-content\/uploads\/Board-1-225x150.jpg 225w, https:\/\/www.symablog.de\/blog\/wp-content\/uploads\/Board-1.jpg 800w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><br \/>\n<span style=\"font-size: xx-small;\">Motherboard I &#8211; Copyright Bj\u00f6rn Kaninke 2012<\/span><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>F\u00fcr einen definierten Server kann man den Maintenance-Mode Report aus dem DataWarehouse anzeigen, mittels Powershell-Skript oder SQL. SQL Query: USE OperationsManagerDW SELECT ManagedEntity.DisplayName, MaintenanceModeHistory.* FROM ManagedEntity WITH (NOLOCK) INNER JOIN MaintenanceMode ON ManagedEntity.ManagedEntityRowId = MaintenanceMode.ManagedEntityRowId INNER JOIN MaintenanceModeHistory ON MaintenanceMode.MaintenanceModeRowId &hellip; <a class=\"more-link\" href=\"https:\/\/www.symablog.de\/blog\/server-maintenance-report\/\">Weiterlesen <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[78,4],"tags":[9,10,193,192],"class_list":["post-47","post","type-post","status-publish","format-standard","hentry","category-praxis","category-scom","tag-maintenance","tag-reporting","tag-scom","tag-systems-management"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p37Rzq-L","_links":{"self":[{"href":"https:\/\/www.symablog.de\/blog\/wp-json\/wp\/v2\/posts\/47"}],"collection":[{"href":"https:\/\/www.symablog.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.symablog.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.symablog.de\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.symablog.de\/blog\/wp-json\/wp\/v2\/comments?post=47"}],"version-history":[{"count":12,"href":"https:\/\/www.symablog.de\/blog\/wp-json\/wp\/v2\/posts\/47\/revisions"}],"predecessor-version":[{"id":427,"href":"https:\/\/www.symablog.de\/blog\/wp-json\/wp\/v2\/posts\/47\/revisions\/427"}],"wp:attachment":[{"href":"https:\/\/www.symablog.de\/blog\/wp-json\/wp\/v2\/media?parent=47"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.symablog.de\/blog\/wp-json\/wp\/v2\/categories?post=47"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.symablog.de\/blog\/wp-json\/wp\/v2\/tags?post=47"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}