Storing Sitefinity Access Logs to Azure Storage

The setup consists of 2 parts: Azure and Sitefinity.

Azure Storage configuration and custom code implementation in Sitefinity.

Pre-Requisite

1. Sitefinity 14.4+ (Tested)
2. Running hybrid .NET Core and MVC mode (Net Core Renderer and Progress.Sitefinity)
3. Azure Subscription with right permission to manage Azure Storage

Azure

1. Go to Azure portal and navigate to Storage
2. Create a storage account under resource group
3. Add a storage table to store the logs, save the Url for later use.

4. Generate a SAS (Shared access signature) for later use

Sitefinity

1. Install nuget package Azure.Data.Tables in the Sitefinity project.
2. Create a configuration section to save Azure Storage Table Url and SAS connection string (from Azure step 3 and step 4 above)

3. Create Global file, user service and audit service in Sitefinity core CMS.

• Global.asax.cs
• UserService.cs
• AuditServices.cs

4. Try to login a few times and see the logs appeared in Azure Storage Table

5. Create a report view to show report in CMS dashboard

• ReportController.cs
• ReportModel.cs
• AuditReport.cshtml

6. Setup the widget in Backend Page.

Codes

GitHub Gist - Sample Code