Share
ReportI want to Export audit logs maximum of one year before we delete the audit logs or is their any way to store the audit logs maximum of one year.
You’re offline. This is a read only version of the page.
15
I want to Export audit logs maximum of one year before we delete the audit logs or is their any way to store the audit logs maximum of one year.
Thanks for this but we don't want to add any new tool we try to achieve this using plugin we writtena a code please review our code and help us to resolve this error.
=====================================
using Microsoft.Xrm.Sdk;
using System;
using ClosedXML.Excel;
using Microsoft.Xrm.Sdk.Query;
using System.Security;
using System.Security.Permissions;
namespace Test
{
public class Class1 : IPlugin
{
public void Execute(IServiceProvider serviceProvider)
{
// Obtain the execution context and necessary services
IPluginExecutionContext context = (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext));
IOrganizationServiceFactory serviceFactory = (IOrganizationServiceFactory)serviceProvider.GetService(typeof(IOrganizationServiceFactory));
IOrganizationService service = serviceFactory.CreateOrganizationService(context.UserId);
try
{
// Retrieve the relevant audit log data using the CRM API or SDK queries
// Customize the query to retrieve the audit logs for the desired entity and any necessary filters
// Set the entity name for which you want to retrieve audit logs
string entityName = "opportunity";
// Set the GUID of the specific record for which you want to retrieve audit logs
Guid recordId = new Guid("344c4fbf-463a-4016-9eda-753fea8013a0");
// Create the query to retrieve audit logs
QueryExpression query = new QueryExpression("audit")
{
ColumnSet = new ColumnSet(true),
Criteria = new FilterExpression
{
Conditions =
{
new ConditionExpression("objecttypecode", ConditionOperator.Equal, entityName),
new ConditionExpression("objectid", ConditionOperator.Equal, recordId)
}
},
Orders =
{
new OrderExpression("createdon", OrderType.Descending)
}
};
// Retrieve the audit logs
EntityCollection result = service.RetrieveMultiple(query);
// Process the retrieved audit logs as needed
foreach (Entity auditLog in result.Entities)
{
// Access the audit log attributes and perform any required actions
Guid auditLogId = auditLog.Id;
DateTime createdOn = (DateTime)auditLog["createdon"];
string action = auditLog.GetAttributeValue<OptionSetValue>("action").Value.ToString();
// Access more attributes as needed
}
// Continue with the rest of your export logic
// Your code to retrieve the audit logs goes here
// Create a new workbook and worksheet using ClosedXML
XLWorkbook workbook = new XLWorkbook();
{
PermissionSet permissions = new PermissionSet(PermissionState.Unrestricted);
var worksheet = workbook.Worksheets.Add("Audit Logs");
// Add headers
worksheet.Cell(1, 1).Value = "Audit Log ID";
worksheet.Cell(1, 2).Value = "Action";
worksheet.Cell(1, 3).Value = "Attribute";
// Add more headers as needed
// Add data to the worksheet
int row = 2;
foreach (var auditLog in result.Entities)
{
worksheet.Cell(row, 1).Value = auditLog.Id.ToString();
worksheet.Cell(row, 2).Value = auditLog.Attributes["ig1_projectnumber"].ToString();
worksheet.Cell(row, 3).Value = auditLog.Attributes["name"].ToString();
// Add more data fields as needed
row++;
}
// Save the workbook to a file
string filePath = "E:/Excel File/Test2.Xlsx";
workbook.SaveAs(filePath);
}
// Handle the exported Excel file as desired (e.g., store it, send it as an attachment, etc.)
// Optionally, perform any additional actions or logic based on the exported audit log data
}
catch (Exception ex)
{
throw new InvalidPluginExecutionException("Erron In Test Plugin " + ex);
}
}
}
}
==============================we debug this code and we get the error how we solve this error :
Request for the permission of type 'System.Security.Permissions.EnvironmentPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed
Hi Rahul Rathore,
To do this requires the use of some external tools:
https://community.dynamics.com/365/sales/f/dynamics-365-for-sales-forum/434177/download-audit-log
All responses (
Answers (
