Unit 3 / 11

Log and Timeline Analysis: Putting Events in the Correct Order

Gains:

  • Ability to normalize multiple timestamp sources to a single reference (UTC) and mark anomalies and gaps in the super timeline with artificial intelligence
  • Ability to distinguish between correlation and causality and verify the narrative established by artificial intelligence by connecting each event to its source
  • Ability to recognize risks such as timestomping, clock drift and log gaps and confirm them with multiple sources

There is only one thing that tells you when, how and in what order a cyber event actually happens: time. When an attacker entered the system, which file he touched and when, when he exfiltrated data — all of this is stored in different logs (recording files where the system records events) and different timestamps (timestamp — a record of the date and time when an event occurred). Timeline analysis arranges these scattered timestamps into a single chronological narrative and asks “what happened?” It is the art of answering the question. In this unit, we will see how AI provides great speed in organizing this messy data and where it can mislead you.

The multitude and pitfalls of timestamps

Even a single file has multiple timestamps. For example, a file system has MACB stamps: Modified, Accessed, Changed, Born. In addition, there are operating system event logs (Windows Event Log), web server logs, firewall logs, application logs and registry (Windows registry - hierarchical database where system and application settings are stored) records.

The biggest pitfall is time zone and time drift. One log records UTC (coordinated universal time), the other local time; a system's clock may be set incorrectly; The attacker may have deliberately manipulated the timestamps (timestomping — spoofing file timestamps). So before establishing a timeline, the time zone and clock accuracy of each source must be determined, all normalized to a common reference (usually UTC).

Caution: It is a classic mistake to put two logs side by side at different time periods and say "it happened at the same time". Convert all timestamps to a single reference before correlating; Otherwise, the cause-effect relationship established by AI (and you) is rotten from the beginning.

Super timeline and AI

In computer forensics, the structure that combines all these sources is called super timeline; It is often generated with tools like Plaso/log2timeline and can be tens of thousands or even millions of rows. This is where AI comes in: marking meaningful patterns and anomalies on this huge chart.

Safe contributions of AI:

  • Anomaly flagging: Out of hours access, sudden privilege escalation, unusual process chain, multiple failed logins in a short interval.
  • Event clustering: Grouping events that concentrate in the same time window and marking them as "something happened here."
  • Narrative outline: Translating verified events into a plain language chronological story (first draft for the report).
  • Gap detection: "There are no logs in this 40 minute interval — could they have been deleted?" Asking about deficiencies such as.

In each, AI generates hypotheses; You prove causality and evidentiary value.

Tip: When giving the timeline to the AI, first tell it clearly the time zone and format: "All timestamps are in UTC, ISO 8601 format." Normalize mixed formats first; Letting the AI ​​guess the format is an invitation for error.

Correlation is not causation

The most dangerous logical error in time analysis is to think that succession is cause and effect. "A USB was inserted at 22:10, a file was copied at 22:12" two events may occur consecutively, but they do not prove that the same person did it for the same purpose; There may be another explanation. While the AI ​​constructs a fluent narrative, it does not see this gap and can produce an exact sentence such as "Data was stolen via USB." The expert's job is to eliminate alternative explanations and support each step with independent evidence.

three mini cases

Case 1 — Clock drift caught. In one case, the web server log and the firewall log looked different for 3 hours. In the first draft, AI considered these "two separate attacks." The expert found that the server's time zone was set incorrectly; When normalized, the two logs fit into a single event. The 3-hour "phantom difference" is gone.

Case 2 — A gap revealed a deletion. In the 1.1 million line super timeline, the AI ​​flagged that there were no records between 02:30-03:10. The expert examined: In this window, the security logs were deliberately cleared (log wiping). The void itself became one of the strongest evidence of the attack.

Case 3 — Hallucination fabricated an event. While making a summary, YZ said, "Administrator account was created at 03:45." The expert looked at the source: there was no such Event ID — the number in the Windows logs that indicates the type of event; The AI ​​combined two different lines and produced an event that did not exist. The linking step to the source prevented the false narrative.

Four copyable templates

1) Time normalization plan:

Your role: forensic timeline analyst. I will give you timestamps from different sources (formats and time periods may differ). First determine the format and time zone of each source, then come up with a plan to convert them all to UTC / ISO 8601. Mark the time zone you are not sure of as "needs confirmation".

2) Anomaly marking:

Context: enterprise server, normal working hours 08:00-18:00 (UTC+3).I will give you the normalized event list. Based only on records that ACTUALLY appear in the list, flag the following: out-of-hours access, privilege escalation, repeatedly failed login, unusual process chain. For each sign, quote the relevant line. Adding interpretation/causation; I will evaluate it.

3) Narrative outline (for the report):

Below are the events I VERIFIED (each with its source). Turn them into a simple, chronological narrative. Use only the events I give; adding a new event, prediction or causality. Write vague connections in language that characterizes them as "possible."

4) Gap and inconsistency scanning:

In this normalized timeline: (1) mark log periods that are expected but appear missing, (2) records that are out of order (future to past), (3) spikes that appear batch/automatically. Show each with corresponding line spacing. Point out that these may be SIGNS of deletion/manipulation but are not proof.

Weak prompt / Strong prompt

Weak prompt:

Summarize these logs and explain what happened.

No time frame, source or "real recording only" restrictions; AI can construct a fluent but fabricated story.

Powerful prompt:

Your role: forensic log analyst. Source: 3 logs (Windows Security,Apache access, firewall), all normalized to UTC,ISO 8601. Task: chronologically list events from March 14th 21:00-23:00 based on given lines only; quote each line with its source and Event ID/code. Establishing correlation, claiming causality; I will comment. Mark the intervals you see as missing or unusual separately.

Source, normalized reference, "given row only" and "establish causality" constraints make the output defensible.

Table of timestamp sources

Source

Example timestamp

Attention

File system (MACB)

Modify/access/create

Open to timestomping

Windows Event Log

Login, process, service events

Verify Event ID

web server log

request time

time zone check

firewall/network

connection, rejection

Clock synchronization (NTP)

Registry

Last write time

Comment requires expertise

App/browser

history, cache

may be local time

Common mistakes

  • Establishing correlation without normalizing the time period. Different slices create false "concurrency".
  • Mistaking correlation for causation. Successive events do not mean the same perpetrator/purpose.
  • Absolute trust in timestamp. Timestomping and incorrect time are possible; Confirm with multiple sources.
  • Not verifying the event that the AI ​​has assembled. The union of two lines may produce a nonexistent event.
  • Ignoring the gaps. The missing log is often the most important evidence.

In summary

Timeline analysis is the act of stringing together scattered timestamps into a single verifiable chronology. AI provides great speed in anomaly flagging, clustering, gap detection, and narrative drafting across million-line super timelines. But time period normalization, correlation-causation distinction, and attribution of each event to the source belong to humans. AI generates hypotheses; You are the one defending the chronology in court.

Application task

Prepare a sample event list of 15-20 lines in different format and time zone (intentionally include a time shift and a space). First convert them all to UTC with the "Time normalization plan" template. Then apply the "Anomaly marking" and "Gap scan" templates and verify the clock drift and gap recorded by the AI ​​at the source.

checklist

  • [ ] I normalized all timestamps to a single reference (UTC).
  • [ ] I linked each event to its source (file/Event ID/line).
  • [ ] I distinguished between correlation and causation; I considered alternative explanations.
  • [ ] I marked log gaps and unusual records.
  • [ ] I confirmed the events that the AI ​​consolidated/summarized in the original recording.