How to Implement Auditing Features in SharePoint 2010

Modify the Site Collection's Audit Settings

Here we can modify the site collection's auditing settings to audit the required events:

1. Open in your site browser click Site Actions | Site Settings.
    
2. 
   
   
   a. When the Site Settings page opens, click the Site Collection Audit Settings hyperlink under the Site Collection Administration section.
    
3. 
   
   
   a. When the Configure Audit Settings page opens, select Automatically Trim the Audit Log for This Site.
    
4. 
   
   a. Select the following events to audit from the Documents and Items:
   
   
   • Opening or downloading documents, viewing items in lists or viewing item properties.
   • Editing items
     
   
   b. Click OK to save the auditing configuration.

Create Auditable Events

Open any document library you have

1. After you are on the libraries All Items page, click on any document set link to view the contained documents.
    
2. Hover over the any document select Edit in Microsoft Excel.
   
   
    
3. When the document opens in Excel, review the data but do not make any changes.
4. Exit Microsoft Excel.
5. Repeat the same steps for some other documents also
6. After the document opens, edit the document by clicking in a cell and entering text for some of them.
7. Click the Excel Save icon located in the upper-left corner of the application.
   
   
    
8. Exit Microsoft Excel.
9. If you are prompted to upload the document to SharePoint, click Close File.
10. If you are prompted to check in the document, click Yes.
11. If you are prompted to enter Version Comments, enter a comment and click OK.

Review the Content Viewing Report to Verify the Viewing Event Auditing

1. Go to Site Actions | Site Settings.
2. When the Site Settings page opens, click the Audit Log Reports link.
   
   
    
3. When the View Auditing Reports page opens, click the Content Viewing report link.
   
   
    
4. Click the Browse button and select the Shared Document library. This is where the report will be saved to. Click OK.
5. When the Operation Completed Successfully message displays, click the Click Here to View the Report Link to open the report in Excel.
6. Scroll down toward the bottom of the Excel report. Locate the entries for the documents. There are two entries. One entry is the audit entry for viewing the Competitive analysis page, and the second entry is the audit entry for viewing the Financial Analysis document.
    
7. Go to Site Actions | Site Settings.
8. When the Site Settings page opens, click the Audit log reports link.
9. When the View Auditing Reports page opens, click the Content modifications report link.
10. Click the Browse button, and select the Shared Documents library. This is where the report will be saved to. Click OK.
11. When the Operation Completed Successfully message displays, click the Click here to view the report link to open the report in Excel.
12. Scroll down toward the bottom of the Excel report. Locate the entry for the document. There is one entry for the each documents for which document is edited . This entry is for the edit event.