{"id":6235,"date":"2022-10-12T22:46:47","date_gmt":"2022-10-12T22:46:47","guid":{"rendered":"https:\/\/pariswells.com\/blog\/?p=6235"},"modified":"2023-01-18T01:41:34","modified_gmt":"2023-01-18T01:41:34","slug":"azure-audit-logging-analysis","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/research\/azure-audit-logging-analysis","title":{"rendered":"Azure Audit Logging Analysis"},"content":{"rendered":"\n

Note that this requires the customer to have the Unified Audit Logging feature enabled.\u00a0<\/p>\n\n\n\n

This is enabled by default on tenants created after 2020; for those created before 2020 you need to enable it.<\/p>\n\n\n\n

    \n
  1. Log in as a GA – NB: not available via partner centre<\/li>\n\n\n\n
  2. Open the complaince centre \/ purview – https:\/\/compliance.microsoft.com\/homepage<\/a><\/li>\n\n\n\n
  3. Solutions -> Audit
    If you see a blue bar that says “click here to enable unified audit logging” the feature is not enabled. Please enable it now and you won’t be able to do any further analysis. <\/li>\n\n\n\n
  4. Create a search for the specific user and timeframe you are interested in. Use the sign in logs for the user to determine the initial attack time.
    Note this is UTC so you need to subtract at least 10 hours; i normally do 12-18.<\/li>\n\n\n\n
  5. Download the resulting CSV file. <\/li>\n<\/ol>\n\n\n\n

    This CSV file will contain 4 columns – the one you are mostly interested in is the AuditData column; however this is stored in JSON format. <\/p>\n\n\n\n

      \n
    1. Easiest way of handling this is to turn the data into a table. Select all of your data then Home -> Format as Table<\/li>\n\n\n\n
    2. Open PowerQuery with Data -> From Table\/Range<\/li>\n\n\n\n
    3. Hilight the AuditData Column <\/li>\n\n\n\n
    4. Transform -> Parse -> As JSON
      The column will now show “Record” instead of text data
      Expand the AuditData column using the <-> arrows in the header<\/li>\n\n\n\n
    5. Repeat for any other columns that have a “List” or “Record”<\/li>\n\n\n\n
    6. Return to Excel with Home -> Close & Load<\/li>\n\n\n\n
    7. Create a Pivot Table Table Design -> Summarise with Pivor Table<\/li>\n\n\n\n
    8. Add “Operation” to “Rows” and Values
      You should now have a table that looks like the following<\/li>\n\n\n\n
    9. Particular items of itnerest are New-InboxRules, Create (This is New Emails) and any Hard Deletes.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

      Note that this requires the customer to have the Unified Audit Logging feature enabled.\u00a0 This is enabled by default on tenants created after 2020; for those created […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[4150,2548,1464,4149],"class_list":["post-6235","post","type-post","status-publish","format-standard","hentry","category-research","tag-analysis","tag-audit","tag-azure","tag-log"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/6235","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=6235"}],"version-history":[{"count":2,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/6235\/revisions"}],"predecessor-version":[{"id":6558,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/6235\/revisions\/6558"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=6235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=6235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=6235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}