• 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
=LEFT([@Column1],SEARCH(CHAR(13),[@Column1]))


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