Forum Discussion
Sharepoint audit log gathering
Hey,
we are in environment with a huge amount of site collections (+100K) and for compliance issues, we need to collect all audit log data to report on user activities accross the environment. Given that querying the content database is not supported on premise and not possible in an Online scenario, I was wondering what other possibilies do exist / if anything is coming through PnP / CSOM?
Kind regards,
Christophe
- have you looked at the O365 Management API, see https://msdn.microsoft.com/en-us/office-365/office-365-management-activity-api-reference
Deleted, have you looked at the audit log reports built into Office 365?
In the Admin application, go to Admin Centers and open the Compliance admin center. In the Compliance (aka Security & Compliance) center, expand "Search & investigation" in the left navigation, and click on "Audit log search". You can also read more about the Audit log search at https://support.office.com/en-us/article/Search-the-audit-log-in-the-Office-365-Security-Compliance-Center-0d4d0f35-390b-4518-800e-0c7ec95e946c?ui=en-US&rs=en-US&ad=US
Do you neede to keep the audit log data for more than 90 days?
- +1 to use the audit log features you have in the Security & Compliance center...by the way, in the PnP space in GitHub you can find samples about how to use CSOM to get information from the SPO change Log
Thanks for your responses. The Security & Compliance center is only giving part of the functionality, as it is only covering SPO.
To clarify a bit more on the needs: we have the requirement to be able to report on who's viewed / downloaded / deleted content in a full on-prem environment which might move in the future partly to SPO (so a hybrid environment). These logs should be consultable for a longer period of time (+ 5 years). We are able to capture that data if we are reading directly from the content databases, but this is not advisable and even impossible on SPO.
VesaJuvonen, is this something that might get into PnP / any other tracks to explore? Thanks for any guidance!
