WEBVTT

00:00:01.648 --> 00:00:03.178 align:middle line:90%
Why do you need to do this?

00:00:03.178 --> 00:00:05.698 align:middle line:84%
I love when students ask
questions that challenge me.

00:00:05.698 --> 00:00:08.578 align:middle line:84%
I had a student in
Vegas a few years ago.

00:00:08.578 --> 00:00:11.498 align:middle line:84%
And he said, I'm never
going to have to do this.

00:00:11.498 --> 00:00:13.438 align:middle line:90%
I work child exploitation cases.

00:00:13.438 --> 00:00:15.701 align:middle line:84%
I was like, OK, here's
a perfect example.

00:00:15.701 --> 00:00:17.368 align:middle line:84%
And we ended up putting
a slide together

00:00:17.368 --> 00:00:20.058 align:middle line:90%
like this for that student.

00:00:20.058 --> 00:00:22.488 align:middle line:84%
You are working a child
exploitation case.

00:00:22.488 --> 00:00:24.798 align:middle line:84%
You have some random
application that's in use

00:00:24.798 --> 00:00:26.898 align:middle line:90%
that the tools are not parsing.

00:00:26.898 --> 00:00:29.268 align:middle line:84%
However, you see chat
messages going back and forth,

00:00:29.268 --> 00:00:31.878 align:middle line:84%
and you see pictures
and other things.

00:00:31.878 --> 00:00:34.278 align:middle line:84%
You're going to have to
write a query to parse that.

00:00:34.278 --> 00:00:35.898 align:middle line:90%
Now, this is super important.

00:00:35.898 --> 00:00:39.875 align:middle line:84%
Every single case you work,
SQLite is going to be relevant.

00:00:39.875 --> 00:00:41.208 align:middle line:90%
Do you need to parse everything?

00:00:41.208 --> 00:00:42.528 align:middle line:90%
Absolutely not.

00:00:42.528 --> 00:00:44.338 align:middle line:84%
What you need to do is
start with the tool.

00:00:44.338 --> 00:00:46.953 align:middle line:84%
So here we can see we have
a message between Lloyd

00:00:46.953 --> 00:00:49.098 align:middle line:90%
Xmas and Ace Ventura.

00:00:49.098 --> 00:00:51.148 align:middle line:90%
We also have those sources.

00:00:51.148 --> 00:00:53.998 align:middle line:84%
Remember how I told you,
always click on the source.

00:00:53.998 --> 00:00:56.478 align:middle line:84%
So here in Physical Analyzer,
we would click on the source.

00:00:56.478 --> 00:00:59.838 align:middle line:84%
It would tell us these are
the databases I'm parsing,

00:00:59.838 --> 00:01:01.938 align:middle line:84%
and these are the
tables of interests.

00:01:01.938 --> 00:01:04.278 align:middle line:84%
The key goal in
most of these apps

00:01:04.278 --> 00:01:07.378 align:middle line:84%
is going to be to
determine the message.

00:01:07.378 --> 00:01:08.658 align:middle line:90%
What was the content?

00:01:08.658 --> 00:01:11.278 align:middle line:84%
What was the context
going back and forth?

00:01:11.278 --> 00:01:13.968 align:middle line:84%
Do we know who sent
it or received it?

00:01:13.968 --> 00:01:16.698 align:middle line:84%
If any attachments are included,
what are those file names?

00:01:16.698 --> 00:01:18.533 align:middle line:84%
You may want to say
file size, hash values.

00:01:18.533 --> 00:01:19.908 align:middle line:84%
You can do all
the things as long

00:01:19.908 --> 00:01:21.828 align:middle line:90%
as the database stores it--

00:01:21.828 --> 00:01:23.748 align:middle line:84%
timestamps, and was it
incoming or outgoing?
