I want to generate Sharepoint audit logs through code

Question

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.

Mani Rudraraju · Answer

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

Mani Rudraraju · Answer

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 Swain · Answer

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 Rudraraju · Answer

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 Swain · Answer

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. }