Topic lessonTopic: AWS authorization, encryption, audit and response
Preserve AWS and SQL Server forensic evidence for handoff
Track acquisition time and hashes while separating originals from working copies. Correlate cloud audit and SQL Server records in the same incident.
Correlate cloud audit and SQL Server records in the same incident.
This exercise uses fictional evidence and makes no changes in a live environment.
Record the chain of custody
Preserve relevant logs in an authorized boundary. Distinguish event time from acquisition time and work from verified copies.
- Acquire → KeepRecord custody
- Keep → CopyCompare integrity
- Copy → AnalyzeLog access
- Acquire
- Record collector and time
- Keep
- Restrict and retain the original
- Copy
- Verify SHA-256
- Analyze
- Align event timelines
A synthetic time-zone discrepancy
| Source | Time or result | Use |
|---|---|---|
| AWS audit | 01:04 UTC | Event time |
| SQL Server audit | 10:04 JST | The same minute |
| Collection | 02:00 UTC | Acquisition time |
| Working copy | Matching hash | Record analysis and handoff |
Keep the original zones and acquisition time alongside any normalized timestamps.
Evidence for the decision
Protect the original Record scope, purpose, storage, readers and the accountable collector.
Verify integrity Match hashes at acquisition and transfer, then use a restricted working copy.
Align clocks Record the original zone, converted time and any uncertainty.
Check your decision
Choose an option to see the result and explanation.
Check, then explain in your own words
- Protect the original.
- Verify the copy.
- Reconcile normalized times and IDs.
Check your understanding: Does the same minute establish a single caller?
Compare run and session IDs, resources and precise time.
Time alone cannot establish cause.
Sources and conditions checked
The official references used in this lesson are collected here with their scope, conditions and corresponding sections. Independent expert review and live AWS comparison have not been performed.
- Prepare forensic capabilitiesChecked:
Scope and conditionsPreserving and collecting relevant artifacts.
Used in this lessonRecord the chain of custody A synthetic time-zone discrepancy Evidence for the decision