I want to generate Sharepoint audit logs through code

Mani Rudraraju

I want to generate Sharepoint audit logs through code instead of going site setting -->audit log reports , manually.

i want to schedule it , so is there a way to generate it through powershell for sharepoint online site, Can anyone share solution.

Thanks in advance.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mani Rudraraju6y ago
in Graph API it might be avilable but in my org they are not allowing Grapgh API because of security reasons , Can you please let me know if there is any other way?
Rajkiran Swain6y ago
Please check if is there any Graph API is avaliable for this. If its there then you can easily fetch the logs using Javascript.
Mani Rudraraju6y ago
Hi Rajkiran,
Thank you , but i want it for Sharepoint Online not for the server side .

those objects are not available for Sharepoint online , Please share the solution if you have anything.
Rajkiran Swain6y ago
You can iuse the below query to get Audit report.
try
{
    using(SPSite site = new SPSite("https://SiteURL.com")) {
        using(SPWeb web = site.OpenWeb()) {
            SPAuditQuery query = new SPAuditQuery(site);
            query.AddEventRestriction(SPAuditEventType.View);
            query.AddEventRestriction(SPAuditEventType.Search);
            query.SetRangeStart(DateTime.Now.AddHours(-1));
            query.SetRangeEnd(DateTime.Now);
            SPAuditEntryCollection auditCol = web.Audit.GetEntries(query);
            foreach(SPAuditEntry audit in auditCol) {
                string docName = audit.DocLocation;
                string userID = audit.UserId;
                string ItemID = Convert.ToString(audit.ItemId);
                string ItemType = Convert.ToString(audit.ItemType);
                string EventType = Convert.ToString(audit.Event);
                string OccuredDate = audit.Occurred;
            }
        }
    }
} catch (Exception ex) {
    //Catch error in to ULS log.
}
Mani Rudraraju6y ago
not able to coonect Exachange online
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -Uri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection
and Search-UnifiedAuditLog giving issue