使用Powershell在选定库上创建审核报告 [英] Creating audit reports on selected libraries using Powershell

问题描述

大家好，

已要求我每隔90天查看了选定库中文档的用户生成一份报告.具体来说，所有这些都集中在一个站点中.我们只有一个网站集，但是有多个网站.我们的AuditData表约为18GB， 因此我要注意不要运行任何会对性能产生负面影响的查询.在该目录下，大约有40个文档库. http://sitecollection/site  我再次要查询的用户，只是查看过项目(或打开或下载文档，查看列表中的项目，或查看项目属性" 方法对此进行了描述).

I've been asked to produce a report every 90 days of users that have viewed documents in selected libraries.  Specifically, all of those in one site.  We have only one site collection, but multiple sites.  Our AuditData table is about 18GB, so I want to be careful not to run any query that would negatively impact performance.  There are about 40 document libraries under the http://sitecollection/site that I need to query, again just for users that have viewed items (or "Opening or downloading documents, viewing items in lists, or viewing item properties" as the interactive method describes it). 

有人可以帮忙吗?

谢谢

杰夫

推荐答案

您可以创建一个计时器作业来运行PowerShell以获取数据.

You can create a timer job to run the PowerShell to get the data.

以下文章供您参考:

SharePoint:使用PowerShell进行文档审核

SharePoint: Get Audits for a Document using PowerShell

https://social.technet.microsoft.com/wiki/contents/articles/23900.sharepoint-get-audits-for-a-document-using-powershell.aspx

使用PowerShell获取SharePoint文档的审核

Get Audits for a SharePoint Document using PowerShell

http://nikcharlebois.com/get-audits-for-a- sharepoint-document-using-powershell/

最好的问候，

丹尼斯

这篇关于使用Powershell在选定库上创建审核报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！