{"id":2095,"date":"2017-07-21T12:46:08","date_gmt":"2017-07-21T18:46:08","guid":{"rendered":"https:\/\/kevinjustin.com\/blog\/?p=2095"},"modified":"2022-06-24T16:55:39","modified_gmt":"2022-06-24T20:55:39","slug":"use-dwdatarp-utility-on-scom2016","status":"publish","type":"post","link":"https:\/\/kevinjustin.com\/blog\/2017\/07\/21\/use-dwdatarp-utility-on-scom2016\/","title":{"rendered":"Use DWdataRP utility on SCOM2016"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2105\" src=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2017\/07\/ReadMe.jpg\" alt=\"\" width=\"273\" height=\"214\" \/><\/p>\n<p><span style=\"color: #000000; font-family: Calibri;\">Extra, Extra, r<\/span><span style=\"color: #000000; font-family: Calibri;\">ead all about it!\u00a0 \u00a0<\/span><strong><span style=\"color: #ff0000;\">Updated 24 June 2022<\/span><\/strong><\/p>\n<p><span style=\"color: #000000; font-family: Calibri;\">The DWdataRP utility works on SCOM2016+\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>This tool has been around since SCOM 2007, and\u00a0blogged about by Kevin Holman and the SCOM Engineering Team<\/p>\n<p><span style=\"color: #000000; font-family: Calibri;\">DW Retention <\/span><a href=\"https:\/\/kevinholman.com\/2010\/01\/05\/understanding-and-modifying-data-warehouse-retention-and-grooming\/\">https:\/\/kevinholman.com\/2010\/01\/05\/understanding-and-modifying-data-warehouse-retention-and-grooming\/<\/a><\/p>\n<p><span style=\"font-family: Segoe UI;\"><span style=\"color: #333333;\"><strong><span style=\"font-size: medium;\">Kevin added these &#8211; <\/span><\/strong><\/span><\/span><\/p>\n<p><span style=\"font-family: Segoe UI;\"><span style=\"color: #333333;\"><strong><span style=\"font-size: medium;\">Here is a link to the original command line tool, DWDATARP:<\/span><\/strong>\u00a0\u00a0\u00a0<\/span><\/span><a href=\"https:\/\/kevinholman.com\/files\/dwdatarp.zip\" target=\"_blank\" rel=\"noopener\">https:\/\/kevinholman.com\/files\/dwdatarp.zip<\/a><\/p>\n<p><strong><span style=\"font-family: Segoe UI; font-size: medium;\">Here is a tool which makes this even simpler:<\/span><\/strong>\u00a0\u00a0<a href=\"https:\/\/www.scom2k7.com\/scom-datawarehouse-grooming-settings-super-easy-with-new-gui-tool\/\" target=\"_blank\" rel=\"noopener\">https:\/\/www.scom2k7.com\/scom-datawarehouse-grooming-settings-super-easy-with-new-gui-tool\/<\/a><\/p>\n<p><strong><span style=\"font-family: Segoe UI; font-size: medium;\">And the latest new tool which adds features and simplicity, which is what I recommend:\u00a0<\/span><\/strong><a href=\"https:\/\/blakedrumm.com\/blog\/scom-dw-grooming-tool\/\" target=\"_blank\" rel=\"noopener\">https:\/\/blakedrumm.com\/blog\/scom-dw-grooming-tool\/<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000; font-family: Calibri;\">DWDataRP <\/span><a href=\"https:\/\/techcommunity.microsoft.com\/t5\/System-Center-Blog\/Data-Warehouse-Data-Retention-Policy-dwdatarp-exe\/ba-p\/340415?search-action-id=139683980150&amp;search-result-uid=340415\">https:\/\/techcommunity.microsoft.com\/t5\/System-Center-Blog\/Data-Warehouse-Data-Retention-Policy-dwdatarp-exe\/ba-p\/340415?search-action-id=139683980150&amp;search-result-uid=340415<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Download the link at the second link, and save to your machine (x86 or x64)<\/p>\n<p>&nbsp;<\/p>\n<p>Run the executable<\/p>\n<p><span style=\"font-family: Calibri;\">dwdatarp.exe -s &lt;DB Server Name&gt;\u00a0-D &lt;DW Database Name&gt;<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: Calibri;\">Example <\/span><span style=\"color: #3366ff; font-family: Calibri;\">dwdatarp.exe -s 16DB02 -D OperationsManagerDW<\/span><\/p>\n<p><span style=\"color: #000000; font-family: Calibri;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2115\" src=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2017\/07\/CurrentSettings.PNG\" alt=\"\" width=\"868\" height=\"290\" \/><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Set Data sets according to SLA<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2106\" src=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2017\/07\/SetValues.PNG\" alt=\"\" width=\"926\" height=\"333\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Ever need to shorten up your Lab DB, so you can export it, to leverage PowerBI dashboards?<\/p>\n<p>&nbsp;<\/p>\n<p>Example Output<\/p>\n<p>PS C:\\Users\\sqladmin\\Documents\\DWDataRP\\amd64&gt; .\\dwdatarp.exe -s 16db02.testlab.net -d OperationsManagerDW<br \/>\nDataset name Aggregation name Max Age Current Size, Kb<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\nAlert data set Raw data 180 28,736 ( 0%)<br \/>\nClient Monitoring data set Raw data 30 0 ( 0%)<br \/>\nClient Monitoring data set Daily aggregations 400 136 ( 0%)<br \/>\n<span style=\"color: #0000ff;\">Configuration dataset Raw data 400 259,968 ( 3%)<\/span><br \/>\nDPM event dataset Raw data 400 0 ( 0%)<br \/>\nDPM.Backup.DataSet Raw data 400 0 ( 0%)<br \/>\nDPM.Backup.DataSet Hourly aggregations 3 0 ( 0%)<br \/>\nDPM.Backup.DataSet Daily aggregations 182 0 ( 0%)<br \/>\nDPM.DiskMgmt.DataSet Raw data 400 0 ( 0%)<br \/>\nDPM.DiskMgmt.DataSet Hourly aggregations 3 0 ( 0%)<br \/>\nDPM.DiskMgmt.DataSet Daily aggregations 182 0 ( 0%)<br \/>\nDPM.DiskUtilization.DataSet Raw data 400 0 ( 0%)<br \/>\nDPM.DiskUtilization.DataSet Hourly aggregations 3 0 ( 0%)<br \/>\nDPM.DiskUtilization.DataSet Daily aggregations 182 0 ( 0%)<br \/>\nDPM.Recovery.DataSet Raw data 400 0 ( 0%)<br \/>\nDPM.Recovery.DataSet Hourly aggregations 3 0 ( 0%)<br \/>\nDPM.Recovery.DataSet Daily aggregations 182 0 ( 0%)<br \/>\nDPM.SLATrend.DataSet Raw data 400 0 ( 0%)<br \/>\nDPM.SLATrend.DataSet Hourly aggregations 3 0 ( 0%)<br \/>\nDPM.SLATrend.DataSet Daily aggregations 182 0 ( 0%)<br \/>\nDPM.TapeUtilization.DataSet Raw data 400 0 ( 0%)<br \/>\nDPM.TapeUtilization.DataSet Hourly aggregations 3 0 ( 0%)<br \/>\nDPM.TapeUtilization.DataSet Daily aggregations 182 0 ( 0%)<br \/>\n<span style=\"color: #0000ff;\">Event data set Raw data 100 456,144 ( 5%)<\/span><br \/>\nExchange 2013: Mailbox Database data warehouse dataset Raw data 30 0 ( 0%)<br \/>\nExchange 2013: Mailbox statistics data warehouse dataset Raw data 30 0 ( 0%)<br \/>\nExchange 2013: Mailbox statistics data warehouse dataset Daily aggregations 400 0 ( 0%)<br \/>\nPerformance data set Raw data 10 216,096 ( 2%)<br \/>\n<span style=\"color: #0000ff;\">Performance data set Hourly aggregations 400 5,552,832 ( 61%)<\/span><br \/>\nPerformance data set Daily aggregations 400 221,312 ( 2%)<br \/>\nProcess Monitoring: Performance Metric State data warehouse dataset Raw data 10 0 ( 0%)<br \/>\nProcess Monitoring: Performance Metric State data warehouse dataset Hourly aggregations 90 0 ( 0%)<br \/>\nProcess Monitoring: Performance Metric State data warehouse dataset Daily aggregations 180 0 ( 0%)<br \/>\nProcess Monitoring: Process Health State data warehouse dataset Raw data 10 0 ( 0%)<br \/>\nProcess Monitoring: Process Network Ports data warehouse dataset Raw data 10 0 ( 0%)<br \/>\nState data set Raw data 180 6,080 ( 0%)<br \/>\n<span style=\"color: #0000ff;\">State data set Hourly aggregations 400 2,335,968 ( 25%)<\/span><br \/>\nState data set Daily aggregations 400 99,840 ( 1%)<\/p>\n<p>&nbsp;<\/p>\n<p>Commands to run to clean up the warehouse&#8230;<\/p>\n<p><span style=\"color: #0000ff;\">.\\dwdatarp.exe -s 16db02.testlab.net -d OperationsManagerDW -ds Performance -a Hourly -m 60<\/span><br \/>\n<span style=\"color: #0000ff;\">.\\dwdatarp.exe -s 16db02.testlab.net -d OperationsManagerDW -ds Performance -a Hourly -m 60<\/span><br \/>\n<span style=\"color: #0000ff;\">.\\dwdatarp.exe -s 16db02.testlab.net -d OperationsManagerDW -ds State -a Hourly -m 60<\/span><br \/>\n<span style=\"color: #0000ff;\">.\\dwdatarp.exe -s 16db02.testlab.net -d OperationsManagerDW -ds event -a raw -m 30<\/span><\/p>\n<p><strong>Example Output<\/strong><br \/>\nPS C:\\Users\\admin\\Documents\\DWDataRP\\amd64&gt; .\\dwdatarp.exe -s 16db02.testlab.net -d OperationsManagerDW -ds Performan<br \/>\nce -a Hourly -m 60<br \/>\nMax data age set to 60 on dataset &#8220;Performance data set&#8221; aggregation type &#8220;Hourly aggregations&#8221;<br \/>\nPS C:\\Users\\admin\\Documents\\DWDataRP\\amd64&gt; .\\dwdatarp.exe -s 16db02.testlab.net -d OperationsManagerDW -ds State -a<br \/>\nHourly -m 60<br \/>\nMax data age set to 60 on dataset &#8220;State data set&#8221; aggregation type &#8220;Hourly aggregations&#8221;<br \/>\nPS C:\\Users\\admin\\Documents\\DWDataRP\\amd64&gt; .\\dwdatarp.exe -s 16db02.testlab.net -d OperationsManagerDW -ds event -a<br \/>\nraw -m 30<br \/>\nMax data age set to 30 on dataset &#8220;Event data set&#8221; aggregation type &#8220;Raw data&#8221;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h3>Don&#8217;t forget to execute cleanup<\/h3>\n<p>&#8211;This will manually run grooming for this dataset<br \/>\n<span style=\"color: #0000ff;\">DECLARE @DatasetId uniqueidentifier<\/span><br \/>\n<span style=\"color: #0000ff;\">SET @DatasetId = (SELECT DatasetId FROM StandardDataset WHERE SchemaName = &#8216;Alert&#8217;) <\/span><br \/>\n<span style=\"color: #0000ff;\">EXEC StandardDatasetGroom @DatasetId<\/span><\/p>\n<p>&#8211;This will manually run grooming for this dataset<br \/>\n<span style=\"color: #0000ff;\">DECLARE @DatasetId uniqueidentifier<\/span><br \/>\n<span style=\"color: #0000ff;\">SET @DatasetId = (SELECT DatasetId FROM StandardDataset WHERE SchemaName = &#8216;Event&#8217;) <\/span><br \/>\n<span style=\"color: #0000ff;\">EXEC StandardDatasetGroom @DatasetId<\/span><\/p>\n<p>&#8211;This will manually run grooming for this dataset<br \/>\n<span style=\"color: #0000ff;\">DECLARE @DataSetId uniqueidentifier <\/span><br \/>\n<span style=\"color: #0000ff;\">SET @DataSetId = (SELECT DatasetId FROM StandardDataset WHERE SchemaName = &#8216;Perf&#8217;) <\/span><br \/>\n<span style=\"color: #0000ff;\">EXEC StandardDatasetGroom @DataSetId<\/span><\/p>\n<p>&#8211;This will manually run grooming for this dataset<br \/>\n<span style=\"color: #0000ff;\">DECLARE @DataSetId uniqueidentifier <\/span><br \/>\n<span style=\"color: #0000ff;\">SET @DataSetId = (SELECT DatasetId FROM StandardDataset WHERE SchemaName = &#8216;State&#8217;) <\/span><br \/>\n<span style=\"color: #0000ff;\">EXEC StandardDatasetGroom @DataSetId<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Extra, Extra, read all about it!\u00a0 \u00a0Updated 24 June 2022 The DWdataRP utility works on SCOM2016+\u00a0 &nbsp; &nbsp; This tool has been around since SCOM 2007, and\u00a0blogged about by Kevin Holman and the SCOM Engineering Team DW Retention https:\/\/kevinholman.com\/2010\/01\/05\/understanding-and-modifying-data-warehouse-retention-and-grooming\/ Kevin added these &#8211; Here is a link to the original command line tool, DWDATARP:\u00a0\u00a0\u00a0https:\/\/kevinholman.com\/files\/dwdatarp.zip Here &hellip; <a href=\"https:\/\/kevinjustin.com\/blog\/2017\/07\/21\/use-dwdatarp-utility-on-scom2016\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Use DWdataRP utility on SCOM2016&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,5,11],"tags":[28,103,112,113,114,115,118,136,144,303,322,342,410,456],"class_list":["post-2095","post","type-post","status-publish","format-standard","hentry","category-administration","category-best-practice","category-troubleshooting","tag-administration","tag-console","tag-data-base","tag-data-set","tag-data-warehouse","tag-database","tag-db","tag-dwdatarp","tag-event-data","tag-performance-data","tag-raw-data","tag-scom","tag-sql","tag-troubleshooting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Use DWdataRP utility on SCOM2016 - Kevin Justin&#039;s Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kevinjustin.com\/blog\/2017\/07\/21\/use-dwdatarp-utility-on-scom2016\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Use DWdataRP utility on SCOM2016 - Kevin Justin&#039;s Blog\" \/>\n<meta property=\"og:description\" content=\"Extra, Extra, read all about it!\u00a0 \u00a0Updated 24 June 2022 The DWdataRP utility works on SCOM2016+\u00a0 &nbsp; &nbsp; This tool has been around since SCOM 2007, and\u00a0blogged about by Kevin Holman and the SCOM Engineering Team DW Retention https:\/\/kevinholman.com\/2010\/01\/05\/understanding-and-modifying-data-warehouse-retention-and-grooming\/ Kevin added these &#8211; Here is a link to the original command line tool, DWDATARP:\u00a0\u00a0\u00a0https:\/\/kevinholman.com\/files\/dwdatarp.zip Here &hellip; Continue reading &quot;Use DWdataRP utility on SCOM2016&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kevinjustin.com\/blog\/2017\/07\/21\/use-dwdatarp-utility-on-scom2016\/\" \/>\n<meta property=\"og:site_name\" content=\"Kevin Justin&#039;s Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-07-21T18:46:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-24T20:55:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2017\/07\/ReadMe.jpg\" \/>\n<meta name=\"author\" content=\"Kevin Justin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kevin Justin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/07\\\/21\\\/use-dwdatarp-utility-on-scom2016\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/07\\\/21\\\/use-dwdatarp-utility-on-scom2016\\\/\"},\"author\":{\"name\":\"Kevin Justin\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/213cdc5c6c3f2a1d9e8417c07440972d\"},\"headline\":\"Use DWdataRP utility on SCOM2016\",\"datePublished\":\"2017-07-21T18:46:08+00:00\",\"dateModified\":\"2022-06-24T20:55:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/07\\\/21\\\/use-dwdatarp-utility-on-scom2016\\\/\"},\"wordCount\":711,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/07\\\/21\\\/use-dwdatarp-utility-on-scom2016\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/ReadMe.jpg\",\"keywords\":[\"Administration\",\"Console\",\"data base\",\"data set\",\"data warehouse\",\"database\",\"db\",\"dwdatarp\",\"event data\",\"performance data\",\"raw data\",\"SCOM\",\"sql\",\"troubleshooting\"],\"articleSection\":[\"Administration\",\"Best Practice\",\"Troubleshooting\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/07\\\/21\\\/use-dwdatarp-utility-on-scom2016\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/07\\\/21\\\/use-dwdatarp-utility-on-scom2016\\\/\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/07\\\/21\\\/use-dwdatarp-utility-on-scom2016\\\/\",\"name\":\"Use DWdataRP utility on SCOM2016 - Kevin Justin&#039;s Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/07\\\/21\\\/use-dwdatarp-utility-on-scom2016\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/07\\\/21\\\/use-dwdatarp-utility-on-scom2016\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/ReadMe.jpg\",\"datePublished\":\"2017-07-21T18:46:08+00:00\",\"dateModified\":\"2022-06-24T20:55:39+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/213cdc5c6c3f2a1d9e8417c07440972d\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/07\\\/21\\\/use-dwdatarp-utility-on-scom2016\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/07\\\/21\\\/use-dwdatarp-utility-on-scom2016\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/07\\\/21\\\/use-dwdatarp-utility-on-scom2016\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/ReadMe.jpg\",\"contentUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/ReadMe.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2017\\\/07\\\/21\\\/use-dwdatarp-utility-on-scom2016\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Use DWdataRP utility on SCOM2016\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/\",\"name\":\"Kevin Justin&#039;s Blog\",\"description\":\"Operational monitoring tools including System Center, Azure Monitor\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/213cdc5c6c3f2a1d9e8417c07440972d\",\"name\":\"Kevin Justin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4c2a0d1189dd1ad7f305cf08aa9c5e2d4cc8fc26fde7ca573d3fd7e75520334e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4c2a0d1189dd1ad7f305cf08aa9c5e2d4cc8fc26fde7ca573d3fd7e75520334e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4c2a0d1189dd1ad7f305cf08aa9c5e2d4cc8fc26fde7ca573d3fd7e75520334e?s=96&d=mm&r=g\",\"caption\":\"Kevin Justin\"},\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/author\\\/kejustin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Use DWdataRP utility on SCOM2016 - Kevin Justin&#039;s Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kevinjustin.com\/blog\/2017\/07\/21\/use-dwdatarp-utility-on-scom2016\/","og_locale":"en_US","og_type":"article","og_title":"Use DWdataRP utility on SCOM2016 - Kevin Justin&#039;s Blog","og_description":"Extra, Extra, read all about it!\u00a0 \u00a0Updated 24 June 2022 The DWdataRP utility works on SCOM2016+\u00a0 &nbsp; &nbsp; This tool has been around since SCOM 2007, and\u00a0blogged about by Kevin Holman and the SCOM Engineering Team DW Retention https:\/\/kevinholman.com\/2010\/01\/05\/understanding-and-modifying-data-warehouse-retention-and-grooming\/ Kevin added these &#8211; Here is a link to the original command line tool, DWDATARP:\u00a0\u00a0\u00a0https:\/\/kevinholman.com\/files\/dwdatarp.zip Here &hellip; Continue reading \"Use DWdataRP utility on SCOM2016\"","og_url":"https:\/\/kevinjustin.com\/blog\/2017\/07\/21\/use-dwdatarp-utility-on-scom2016\/","og_site_name":"Kevin Justin&#039;s Blog","article_published_time":"2017-07-21T18:46:08+00:00","article_modified_time":"2022-06-24T20:55:39+00:00","og_image":[{"url":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2017\/07\/ReadMe.jpg","type":"","width":"","height":""}],"author":"Kevin Justin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kevin Justin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kevinjustin.com\/blog\/2017\/07\/21\/use-dwdatarp-utility-on-scom2016\/#article","isPartOf":{"@id":"https:\/\/kevinjustin.com\/blog\/2017\/07\/21\/use-dwdatarp-utility-on-scom2016\/"},"author":{"name":"Kevin Justin","@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/213cdc5c6c3f2a1d9e8417c07440972d"},"headline":"Use DWdataRP utility on SCOM2016","datePublished":"2017-07-21T18:46:08+00:00","dateModified":"2022-06-24T20:55:39+00:00","mainEntityOfPage":{"@id":"https:\/\/kevinjustin.com\/blog\/2017\/07\/21\/use-dwdatarp-utility-on-scom2016\/"},"wordCount":711,"commentCount":0,"image":{"@id":"https:\/\/kevinjustin.com\/blog\/2017\/07\/21\/use-dwdatarp-utility-on-scom2016\/#primaryimage"},"thumbnailUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2017\/07\/ReadMe.jpg","keywords":["Administration","Console","data base","data set","data warehouse","database","db","dwdatarp","event data","performance data","raw data","SCOM","sql","troubleshooting"],"articleSection":["Administration","Best Practice","Troubleshooting"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kevinjustin.com\/blog\/2017\/07\/21\/use-dwdatarp-utility-on-scom2016\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kevinjustin.com\/blog\/2017\/07\/21\/use-dwdatarp-utility-on-scom2016\/","url":"https:\/\/kevinjustin.com\/blog\/2017\/07\/21\/use-dwdatarp-utility-on-scom2016\/","name":"Use DWdataRP utility on SCOM2016 - Kevin Justin&#039;s Blog","isPartOf":{"@id":"https:\/\/kevinjustin.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kevinjustin.com\/blog\/2017\/07\/21\/use-dwdatarp-utility-on-scom2016\/#primaryimage"},"image":{"@id":"https:\/\/kevinjustin.com\/blog\/2017\/07\/21\/use-dwdatarp-utility-on-scom2016\/#primaryimage"},"thumbnailUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2017\/07\/ReadMe.jpg","datePublished":"2017-07-21T18:46:08+00:00","dateModified":"2022-06-24T20:55:39+00:00","author":{"@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/213cdc5c6c3f2a1d9e8417c07440972d"},"breadcrumb":{"@id":"https:\/\/kevinjustin.com\/blog\/2017\/07\/21\/use-dwdatarp-utility-on-scom2016\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kevinjustin.com\/blog\/2017\/07\/21\/use-dwdatarp-utility-on-scom2016\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kevinjustin.com\/blog\/2017\/07\/21\/use-dwdatarp-utility-on-scom2016\/#primaryimage","url":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2017\/07\/ReadMe.jpg","contentUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2017\/07\/ReadMe.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/kevinjustin.com\/blog\/2017\/07\/21\/use-dwdatarp-utility-on-scom2016\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kevinjustin.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Use DWdataRP utility on SCOM2016"}]},{"@type":"WebSite","@id":"https:\/\/kevinjustin.com\/blog\/#website","url":"https:\/\/kevinjustin.com\/blog\/","name":"Kevin Justin&#039;s Blog","description":"Operational monitoring tools including System Center, Azure Monitor","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kevinjustin.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/213cdc5c6c3f2a1d9e8417c07440972d","name":"Kevin Justin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4c2a0d1189dd1ad7f305cf08aa9c5e2d4cc8fc26fde7ca573d3fd7e75520334e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4c2a0d1189dd1ad7f305cf08aa9c5e2d4cc8fc26fde7ca573d3fd7e75520334e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4c2a0d1189dd1ad7f305cf08aa9c5e2d4cc8fc26fde7ca573d3fd7e75520334e?s=96&d=mm&r=g","caption":"Kevin Justin"},"url":"https:\/\/kevinjustin.com\/blog\/author\/kejustin\/"}]}},"_links":{"self":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/2095","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/comments?post=2095"}],"version-history":[{"count":4,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/2095\/revisions"}],"predecessor-version":[{"id":6959,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/2095\/revisions\/6959"}],"wp:attachment":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/media?parent=2095"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/categories?post=2095"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/tags?post=2095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}