{"id":2256,"date":"2021-10-14T09:58:35","date_gmt":"2021-10-14T07:58:35","guid":{"rendered":"https:\/\/www.apvnorge.no\/?page_id=2256"},"modified":"2021-10-14T10:44:23","modified_gmt":"2021-10-14T08:44:23","slug":"wsus-cleanup-sql","status":"publish","type":"page","link":"https:\/\/www.apvnorge.no\/cz\/it-knowledge-base\/microsoft-wsus\/wsus-cleanup-sql\/","title":{"rendered":"WSUS CleanUp SQL"},"content":{"rendered":"<div id=\"apvno-840589236\" class=\"apvno-before-content apvno-entity-placement\"><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-7003427967427457\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:inline-block;width:970px;height:250px;\" \ndata-ad-client=\"ca-pub-7003427967427457\" \ndata-ad-slot=\"6272152047\"><\/ins> \n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<ul class=\"wp-block-list\"><li><strong><a href=\"https:\/\/www.apvnorge.no\/it-knowledge-base\/microsoft-wsus\/\" data-type=\"page\" data-id=\"2245\">Back to Microsft WSUS<\/a><\/strong><\/li><li><strong><a href=\"https:\/\/www.apvnorge.no\/it-knowledge-base\/\">Back to IT Knowledge Base<\/a><\/strong><\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>To clean deleted\/removed\/expired WSUS 3.0 Database entries, connect SQL Management Studio via:<br>\\.\\pipe\\MSSQL$MICROSOFT##SSEE\\sql\\query<br>and execute the following script:<\/p>\n\n\n\n<p>Depending on the count of entries, it might take several hours. check it by running: exec spGetObsoleteUpdatesToCleanup<\/p>\n\n\n\n<p>USE SUSDB<br>DECLARE @var1 INT, @curitem INT, @totaltodelete INT<br>DECLARE @msg nvarchar(200)<br>CREATE TABLE #results (Col1 INT) INSERT INTO #results(Col1)<br>EXEC spGetObsoleteUpdatesToCleanup<br>SET @totaltodelete = (SELECT COUNT(*) FROM #results)<br>SELECT @curitem=1<br>DECLARE WC Cursor FOR SELECT Col1 FROM #results<br>OPEN WC<br>FETCH NEXT FROM WC INTO @var1 WHILE (@@FETCH_STATUS &gt; -1)<br>BEGIN SET @msg = cast(@curitem as varchar(5)) + &#8216;\/&#8217; + cast(@totaltodelete as varchar(5)) + &#8216;: Deleting &#8216; + CONVERT(varchar(10), @var1) + &#8216; &#8216; + cast(getdate() as varchar(30))<br>RAISERROR(@msg,0,1) WITH NOWAIT<br>EXEC spDeleteUpdate @localUpdateID=@var1<br>SET @curitem = @curitem +1<br>FETCH NEXT FROM WC INTO @var1<br>END<br>CLOSE WC<br>DEALLOCATE WC<br>DROP TABLE #results<\/p>\n<div id=\"apvno-1653588938\" class=\"apvno-after apvno-entity-placement\"><script>\r\n_adsys_id = 33949;\r\n_adsys_size = 1;\r\n<\/script>\r\n<script src=\"https:\/\/d.wedosas.net\/d.js\"><\/script>    \r\n<\/br>\r\n<div>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- AD-4 -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:inline-block;width:970px;height:250px\"\r\n     data-ad-client=\"ca-pub-7003427967427457\"\r\n     data-ad-slot=\"6272152047\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><\/div>\r\n<a href=\"https:\/\/affiliates.ssl.com\/820-3-1-13.html\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border:0px\" src=\"https:\/\/i0.wp.com\/affiliates.ssl.com\/media\/banners\/SSL-banner-UC-certificate-2-v5.png?resize=640%2C79&#038;ssl=1\" width=\"640\" height=\"79\" alt=\"Microsoft Exchange SAN UCC SSL\"><\/a><\/div>","protected":false},"excerpt":{"rendered":"<p>Back to Microsft WSUS Back to IT Knowledge Base To clean deleted\/removed\/expired WSUS 3.0 Database entries, connect SQL Management Studio via:\\.\\pipe\\MSSQL$MICROSOFT##SSEE\\sql\\queryand execute the following script: Depending on the count of entries, it might take several hours. check it by running: exec spGetObsoleteUpdatesToCleanup USE SUSDBDECLARE @var1 INT, @curitem INT, @totaltodelete INTDECLARE @msg nvarchar(200)CREATE TABLE #results (Col1 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":2245,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"om_disable_all_campaigns":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-2256","page","type-page","status-publish","hentry"],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"cz","enabled_languages":["en","no","cz"],"languages":{"en":{"title":true,"content":true,"excerpt":false},"no":{"title":false,"content":false,"excerpt":false},"cz":{"title":false,"content":false,"excerpt":false}}},"aioseo_notices":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P9T0bk-Ao","jetpack-related-posts":[],"jetpack_likes_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.apvnorge.no\/cz\/wp-json\/wp\/v2\/pages\/2256","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.apvnorge.no\/cz\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.apvnorge.no\/cz\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.apvnorge.no\/cz\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.apvnorge.no\/cz\/wp-json\/wp\/v2\/comments?post=2256"}],"version-history":[{"count":2,"href":"https:\/\/www.apvnorge.no\/cz\/wp-json\/wp\/v2\/pages\/2256\/revisions"}],"predecessor-version":[{"id":2270,"href":"https:\/\/www.apvnorge.no\/cz\/wp-json\/wp\/v2\/pages\/2256\/revisions\/2270"}],"up":[{"embeddable":true,"href":"https:\/\/www.apvnorge.no\/cz\/wp-json\/wp\/v2\/pages\/2245"}],"wp:attachment":[{"href":"https:\/\/www.apvnorge.no\/cz\/wp-json\/wp\/v2\/media?parent=2256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}