WEBVTT

00:00:01.719 --> 00:00:04.659 align:middle line:84%
Basic terminology that
is so important to you--

00:00:04.659 --> 00:00:06.879 align:middle line:90%
you're going to have a database.

00:00:06.879 --> 00:00:10.329 align:middle line:84%
That database is going to
be comprised of tables.

00:00:10.329 --> 00:00:11.649 align:middle line:90%
It could be one table.

00:00:11.649 --> 00:00:14.289 align:middle line:90%
It could be so many tables.

00:00:14.289 --> 00:00:17.829 align:middle line:84%
There are some tables or
databases on iOS devices

00:00:17.829 --> 00:00:20.819 align:middle line:84%
that could have
hundreds of tables.

00:00:20.819 --> 00:00:24.509 align:middle line:84%
Look for the one that stores
the conversations, whether it's

00:00:24.509 --> 00:00:26.527 align:middle line:90%
chats, messages--

00:00:26.527 --> 00:00:29.069 align:middle line:84%
that's typically where you want
to start in a lot of the chat

00:00:29.069 --> 00:00:30.239 align:middle line:90%
applications.

00:00:30.239 --> 00:00:33.899 align:middle line:84%
You can also sort by row
count and look accordingly.

00:00:33.899 --> 00:00:36.089 align:middle line:84%
Then you're going to have
the different columns.

00:00:36.089 --> 00:00:39.054 align:middle line:84%
And then those columns will
have data stored in rows.

00:00:39.054 --> 00:00:40.929 align:middle line:84%
So I want to show you
something really quick.

00:00:40.929 --> 00:00:43.589 align:middle line:84%
And this is a nice trick
that I had learned.

00:00:43.589 --> 00:00:45.989 align:middle line:84%
In Physical Analyzer,
I don't care

00:00:45.989 --> 00:00:49.019 align:middle line:84%
if it's an iPhone or an
Android, under Data Files,

00:00:49.019 --> 00:00:50.609 align:middle line:90%
you're going to have databases.

00:00:55.169 --> 00:00:58.739 align:middle line:84%
And in that cold case that
I mentioned previously

00:00:58.739 --> 00:01:03.559 align:middle line:84%
in this course, there was
a person that was murdered.

00:01:03.559 --> 00:01:05.599 align:middle line:84%
None of the data
was really speaking

00:01:05.599 --> 00:01:08.959 align:middle line:84%
on anything that could
prove the innocence or guilt

00:01:08.959 --> 00:01:11.389 align:middle line:90%
of the person of interest.

00:01:11.389 --> 00:01:13.889 align:middle line:84%
But what my friend had done who
was working this with me is,

00:01:13.889 --> 00:01:17.549 align:middle line:84%
he went into databases
just out of desperation,

00:01:17.549 --> 00:01:21.059 align:middle line:90%
and he sorted by row count.

00:01:21.059 --> 00:01:23.489 align:middle line:84%
So sort by row count
descending, go up to the top,

00:01:23.489 --> 00:01:27.379 align:middle line:84%
and look at the ones that
have the most information.

00:01:27.379 --> 00:01:29.259 align:middle line:84%
And this is where
this gets interesting.

00:01:29.259 --> 00:01:34.469 align:middle line:84%
Within here, he was able to
identify applications that were

00:01:34.469 --> 00:01:35.909 align:middle line:90%
used for transferring money.

00:01:35.909 --> 00:01:37.919 align:middle line:84%
There were very large
transfers of money

00:01:37.919 --> 00:01:40.109 align:middle line:84%
to a person of
interest that maybe

00:01:40.109 --> 00:01:42.399 align:middle line:84%
shouldn't have had that
type of money sent to them.

00:01:42.399 --> 00:01:46.399 align:middle line:84%
So as we start looking through
this, here we can see--

00:01:46.399 --> 00:01:49.129 align:middle line:84%
I'm going to choose
worldcity.db.

00:01:49.129 --> 00:01:52.839 align:middle line:90%
This one only has three tables.

00:01:52.839 --> 00:01:55.089 align:middle line:84%
But as you look, you
can get a quick glimpse

00:01:55.089 --> 00:01:56.799 align:middle line:90%
of what you're looking for.

00:01:56.799 --> 00:01:58.094 align:middle line:90%
Here, we have internal.db.

00:01:58.094 --> 00:01:59.469 align:middle line:84%
And you could go
over and say, is

00:01:59.469 --> 00:02:01.419 align:middle line:84%
any of this stuff
of interest to me?

00:02:01.419 --> 00:02:04.929 align:middle line:90%
Is this relevant or not?

00:02:04.929 --> 00:02:06.839 align:middle line:90%
So it's just a good clue to you.

00:02:06.839 --> 00:02:09.789 align:middle line:84%
And what I like to do
is, I want to say, OK,

00:02:09.789 --> 00:02:12.806 align:middle line:84%
show me the ones that are
not decoded by my tool,

00:02:12.806 --> 00:02:14.639 align:middle line:84%
and then that's my good
cheat sheet on where

00:02:14.639 --> 00:02:15.699 align:middle line:90%
I'm going to start.

00:02:15.699 --> 00:02:19.289 align:middle line:84%
So row count, it's
difficult. Even

00:02:19.289 --> 00:02:21.959 align:middle line:84%
malware, anything that
has a database involved,

00:02:21.959 --> 00:02:24.979 align:middle line:84%
you can't hide from
the row count--

00:02:24.979 --> 00:02:27.251 align:middle line:84%
very, very helpful,
just if you get

00:02:27.251 --> 00:02:28.959 align:middle line:84%
lost, and you're trying
to keyword search

00:02:28.959 --> 00:02:30.042 align:middle line:90%
and you can't find things.
