SharePoint audit data missing page information

%3CLINGO-SUB%20id%3D%22lingo-sub-3248727%22%20slang%3D%22en-US%22%3ESharePoint%20audit%20data%20missing%20page%20information%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3248727%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20followed%20the%20article%20on%20using%20PowerShell%20and%20Azure%20function%20to%20get%20the%20SharePoint.Audit%20logs%20from%20the%20management%20API%20but%20data%20on%20the%20SiteUrl%20and%20SourceFileName%20are%20not%20included%20for%20pageViewed%20events.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fsecurity-compliance-and-identity%2Fusing-the-office-365-management-activity-api-and-power-bi-for%2Fba-p%2F189086%22%20target%3D%22_blank%22%3EUsing%20the%20Office%20365%20Management%20Activity%20API%20and%20Power%20BI%20for%20security%20analysis%20(Part%201)%20-%20Microsoft%20Tech%20Community%3C%2FA%3E%3C%2FP%3E%3CP%3EIt%20does%20include%20the%20ListID%20and%20SiteID%20that%20I%20was%20able%20to%20match%20to%20SharePoint%20Search%20properties%20but%20the%20ListItemUniqueID%20column%20does%20not%20match%20the%20UniqueID%20or%20ListItemID%20properties%20for%20any%20items%20in%20the%20that%20list.%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20how%20to%20get%20the%20missing%20details%20of%20the%20page%20from%20SharePoint%20API%20or%20export%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3248727%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECompliance%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Contributor

I've followed the article on using PowerShell and Azure function to get the SharePoint.Audit logs from the management API but data on the SiteUrl and SourceFileName are not included for pageViewed events.

Using the Office 365 Management Activity API and Power BI for security analysis (Part 1) - Microsoft...

It does include the ListID and SiteID that I was able to match to SharePoint Search properties but the ListItemUniqueID column does not match the UniqueID or ListItemID properties for any items in the that list. 

Does anyone know how to get the missing details of the page from SharePoint API or export?

0 Replies