After fetching the audit logs files by navigating to Export results > Download all results option on the Audit log search page, you can process and view the information in the CSV file. But the column AuditData containing additional information from each audit record is stored as a JSON object. This object needs to be split as separate columns, processed using the Power Query and can only then be read and analysed.
M365 Manager Plus, an intuitive Microsoft 365 reporting, managing, monitoring, auditing, and alerting tool provides a better solution. It comprehensive audit reports give information about all the related attributes involved in a change process. The tool also offers advanced filtering options and custom view options that help you filter out required columns and get summaries based on the certain important attributes. You can also add and delete columns to the audit report as you desire. If you are wondering what else M365 Manager Plus offers, read on.
Why use M365 Manager Plus?
Geolocation enabled audit reports: With these reports, you can look for changes performed by users along with their location. You can filter these reports location-wise and make management easy for regional admins.
Custom views and advanced filtering options: You can create audit reports with the type of view you prefer (like summarised views) and also choose the columns that must go into the report.
Business hours auditing: You can audit actions throughout the day and also get a separate set of report on the action performed within and outside the usual business hours. This will help you track the unusual activities performed outside business hours (if any) easily.
User-based and group-based auditing: With the advance filter options, you can filter the audits domain-wise and also pick out reports related to specific user or group in particular if would choose to.
Indefinite audit log storage: M365 Manager Plus allows you to store the audit logs for an indefinite period unlike in native tool with specific restrictions for storage period as per your subscription type.
Inpidual audit profiles for each activity: The main advantage of using this tool is that you can audit actions for most of the Microsoft 365 services and yet have distinct and comprehensive reports that track each activity accurately.
Create your own custom alerts: Using this feature, you can create your own alert profiles that help you get instant email notifications about the important changes made to your Microsoft 365 accounts.
Click here to learn more about how M365 Manager Plus helps you audit and manage Microsoft 365 accounts easily and efficiently.