{"id":349,"date":"2023-10-03T14:54:12","date_gmt":"2023-10-03T11:54:12","guid":{"rendered":"https:\/\/kb.astrocroc.com\/?p=349"},"modified":"2023-10-03T14:54:12","modified_gmt":"2023-10-03T11:54:12","slug":"%d1%81%d1%82%d0%b0%d1%82%d0%b8%d1%81%d1%82%d0%b8%d0%ba%d0%b0-%d0%bf%d0%be%d1%81%d0%b5%d1%89%d0%b5%d0%bd%d0%b8%d1%8f-sharepoint","status":"publish","type":"post","link":"https:\/\/kb.astrocroc.com\/?p=349","title":{"rendered":"\u0421\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0430 \u043f\u043e\u0441\u0435\u0449\u0435\u043d\u0438\u044f SharePoint"},"content":{"rendered":"\n<p>\u0412 Central administration \u0432 \u043c\u0435\u043d\u044e Monitoring &#8212; Configire usage and health data collection \u0443\u0431\u0435\u0434\u0438\u0442\u044c\u0441\u044f \u0447\u0442\u043e \u0432\u043a\u043b\u044e\u0447\u0435\u043d \u0441\u0431\u043e\u0440 \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0438, \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c Logging Database Server.<\/p>\n\n\n\n<p>\u0414\u0430\u043b\u0435\u0435 \u0434\u0435\u043b\u0430\u0435\u043c \u0437\u0430\u043f\u0440\u043e\u0441:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\" data-line=\"\">--USE [WSS_UsageApplication]\nDECLARE @StartTime DATETIME = DATEADD(MONTH, -1, GETDATE()),\n@EndTime DATETIME = GETDATE();\nSELECT [SiteUrl], [WebUrl], webs.Title, [DocumentPath], count(RowId) as Hits --[LogTime]--, count(RowId) as Hits\nFROM [WSS_UsageApplication].[dbo].[RequestUsage_Partition9]\n\nLEFT JOIN [ContentMain].[dbo].[AllWebs] webs ON ([WSS_UsageApplication].[dbo].[RequestUsage_Partition9].WebId = webs.Id)\n\nWHERE LogTime BETWEEN @StartTime AND @EndTime\nAND WebId &lt;&gt; &#039;00000000-0000-0000-0000-000000000000&#039; --\u0421\u043b\u0443\u0436\u0435\u0431\u043d\u044b\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u044b (\u043a\u0430\u043b\u0435\u043d\u0434\u0430\u0440\u044c, PeoplePicker...)\nAND HttpStatus = 200\t\t\t\t\t\t\t\t--\u0422\u043e\u043b\u044c\u043a\u043e \u0443\u0441\u043f\u0435\u0448\u043d\u044b\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u044b, \u0431\u0435\u0437 \u043a\u044d\u0448\u0430\nAND (ServerUrl = &#039;http:\/\/portal.sogaz.ru&#039;\t\t\t--\u0418\u0441\u043a\u043e\u043c\u043e\u0435 Web \u041f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0435\n\tOR ServerUrl = &#039;http:\/\/portal&#039;)\t\t\t\t\t--\u0418 \u0435\u0433\u043e \u0430\u043b\u044c\u0442\u0435\u0440\u043d\u0430\u0442\u0438\u0432\u043d\u044b\u0439 \u0430\u0434\u0440\u0435\u0441\nAND DocumentPath NOT LIKE &#039;\/_layouts\/15%&#039;\t\t\t--\u041e\u0442\u0441\u0435\u043a\u0430\u0435\u043c \u0441\u043b\u0443\u0436\u0435\u0431\u043d\u044b\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u044b\nAND DocumentPath NOT LIKE &#039;\/_vti_bin\/%&#039;\t\t\t\t--\u041e\u0442\u0441\u0435\u043a\u0430\u0435\u043c \u0441\u043b\u0443\u0436\u0435\u0431\u043d\u044b\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u044b\nAND DocumentPath NOT LIKE &#039;\/_api\/search\/%&#039;\t\t\t--\u041e\u0442\u0441\u0435\u043a\u0430\u0435\u043c \u043f\u043e\u0438\u0441\u043a\u043e\u0432\u044b\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u044b (\u043f\u043e \u043d\u0438\u043c \u0435\u0441\u0442\u044c \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u0430\u044f \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0430)\nAND DocumentPath NOT LIKE &#039;%.jpg&#039;\t\t\t\t\t--\u041e\u0442\u0441\u0435\u043a\u0430\u0435\u043c \u043a\u0430\u0440\u0442\u0438\u043d\u043a\u0438\nAND DocumentPath NOT LIKE &#039;%.jpeg&#039;\t\t\t\t\t--\u041e\u0442\u0441\u0435\u043a\u0430\u0435\u043c \u043a\u0430\u0440\u0442\u0438\u043d\u043a\u0438\nAND DocumentPath NOT LIKE &#039;%.png&#039;\t\t\t\t\t--\u041e\u0442\u0441\u0435\u043a\u0430\u0435\u043c \u043a\u0430\u0440\u0442\u0438\u043d\u043a\u0438\nAND UserLogin &lt;&gt; &#039;i:0#.w|sogaz\\00-0000.sharepoint&#039;\t--\u041e\u0442\u0441\u0435\u043a\u0430\u0435\u043c \u0441\u043b\u0443\u0436\u0435\u0431\u043d\u0443\u044e \u0443\u0447\u0435\u0442\u043a\u0443\nGROUP BY [DocumentPath], [SiteUrl], [WebUrl], webs.Title\nORDER BY Hits DESC <\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u0412 Central administration \u0432 \u043c\u0435\u043d\u044e Monitoring &#8212; Configire usage and health data collection \u0443\u0431\u0435\u0434\u0438\u0442\u044c\u0441\u044f \u0447\u0442\u043e \u0432\u043a\u043b\u044e\u0447\u0435\u043d \u0441\u0431\u043e\u0440 \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0438, \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c Logging Database Server. \u0414\u0430\u043b\u0435\u0435 \u0434\u0435\u043b\u0430\u0435\u043c \u0437\u0430\u043f\u0440\u043e\u0441:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,59],"tags":[61],"class_list":["post-349","post","type-post","status-publish","format-standard","hentry","category-sharepoint","category-sql","tag-sql"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/posts\/349","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=349"}],"version-history":[{"count":1,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/posts\/349\/revisions"}],"predecessor-version":[{"id":350,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/posts\/349\/revisions\/350"}],"wp:attachment":[{"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=349"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}