Microsoft 365サブスクリプションがあります。 サブスクリプションから監査ログ検索を実行し、すべての結果をダウンロードします。 Microsoft Excelを使用して、監査ログデータを確認する予定です。 各監査プロパティが個別のExcel列に表示されるようにする必要があります。 最初に何をすべきですか?
正解:A
After you search the Office 365 audit log and download the search results to a CSV file, the file contains a column named AuditData, which contains additional information about each event. The data in this column is formatted as a JSON object, which contains multiple properties that are configured as property:value pairs separated by commas. You can use the JSON transform feature in the Power Query Editor in Excel to split each property in the JSON object in the AuditData column into multiple columns so that each property has its own column. This lets you sort and filter on one or more of these properties Reference: https://docs.microsoft.com/en-us/microsoft-365/compliance/export-view-audit-log-records