Forum Discussion
miclarsen1
Mar 24, 2021Brass Contributor
SharePoint 2010 + load data from old database
Hey After moving from SHP 2010 to SHP 2019, I need to review the audit log data from one of the old content databases. Since I did a content migration using ShareGate, and not the good old attach ...
Mar 26, 2021
You'll need to attach the database to _a_ SQL Server, it doesn't have to be a production SQL server, but that will be step #1. From there, you can browse the dbo.AuditData table in the Content Database using SSMS or Azure Data Studio.
You will need the SiteId and the UserId will be associated with data from the dbo.UserInfo table.
While I cannot find the AuditData table schema document (may not exist), you can find the bitwise flags, enumerations, etc. for the table at https://docs.microsoft.com/en-us/openspecs/sharepoint_protocols/ms-wssfo/18a44781-ea93-43e1-a292-b265635323f9.
The UserInfo table schema is at https://docs.microsoft.com/en-us/openspecs/sharepoint_protocols/ms-wssfo3/6c3a31c9-475c-42ef-b5e4-689d60b1ee82.
You will need the SiteId and the UserId will be associated with data from the dbo.UserInfo table.
While I cannot find the AuditData table schema document (may not exist), you can find the bitwise flags, enumerations, etc. for the table at https://docs.microsoft.com/en-us/openspecs/sharepoint_protocols/ms-wssfo/18a44781-ea93-43e1-a292-b265635323f9.
The UserInfo table schema is at https://docs.microsoft.com/en-us/openspecs/sharepoint_protocols/ms-wssfo3/6c3a31c9-475c-42ef-b5e4-689d60b1ee82.