• Export the Security Log to a CSV File
  • Open the CSV in Excel
  • Highlight Columns A - F and click on "Home" -> "Format as table"

  • Paste the following line into G2
=MID([@Column1],SEARCH("Account Name:",[@Column1],SEARCH("Account Domain:",[@Column1]))+13,SEARCH("Account Domain:",[@Column1],SEARCH("Logon ID:",[@Column1]))-SEARCH("Account Name:",[@Column1],SEARCH("Logon ID:",[@Column1]))-16)

  • Paste the following line into H2

  • Now you can filter out the data required and explore the dataset