WEBVTT

00:00:01.731 --> 00:00:05.121 align:middle line:84%
BLOBs can be a pain for you,
but they are approachable.

00:00:05.121 --> 00:00:07.131 align:middle line:84%
BLOBs are Binary
Large OBjects that

00:00:07.131 --> 00:00:12.151 align:middle line:84%
are found within databases
that contain content,

00:00:12.151 --> 00:00:15.141 align:middle line:84%
whether it's a picture,
a message, a zip file.

00:00:15.141 --> 00:00:17.811 align:middle line:84%
There are all kinds of things
that you can get from this.

00:00:17.811 --> 00:00:21.421 align:middle line:84%
A student wrote a
sqlite_miner parser for us.

00:00:21.421 --> 00:00:24.191 align:middle line:84%
So when we look at this--
this is a Perl script.

00:00:24.191 --> 00:00:29.581 align:middle line:84%
We type perl, sqlite
miner.pl, --file,

00:00:29.581 --> 00:00:30.811 align:middle line:90%
and what you want to parse.

00:00:30.811 --> 00:00:33.271 align:middle line:84%
I'm going to show
you how this works.

00:00:33.271 --> 00:00:35.071 align:middle line:84%
And I'm going to
risk it on a database

00:00:35.071 --> 00:00:37.471 align:middle line:84%
that I don't know if it
even has anything in it.

00:00:37.471 --> 00:00:45.951 align:middle line:84%
So I'm going to go into Scripts
for Class, sqlite_miner,

00:00:45.951 --> 00:00:47.046 align:middle line:90%
and I'm going to type cmd.

00:00:49.621 --> 00:00:50.761 align:middle line:90%
Now, you have to type perl.

00:00:50.761 --> 00:00:54.621 align:middle line:84%
And make sure you spell
it correctly, P-E-R-L.

00:00:54.621 --> 00:00:58.631 align:middle line:84%
I'm going to start typing
sqlite, and just press Tab,

00:00:58.631 --> 00:00:59.981 align:middle line:90%
--file.

00:00:59.981 --> 00:01:01.581 align:middle line:90%
What do we want to parse?

00:01:01.581 --> 00:01:04.821 align:middle line:90%
Now, I'm going to try--

00:01:04.821 --> 00:01:09.551 align:middle line:84%
let's try photos.sqlite,
and I press Enter.

00:01:09.551 --> 00:01:11.871 align:middle line:84%
It tells you, hey, there's
absolutely no warranty.

00:01:11.871 --> 00:01:12.851 align:middle line:90%
This is open source.

00:01:12.851 --> 00:01:14.921 align:middle line:84%
I'm doing this out of
the kindness of my heart.

00:01:14.921 --> 00:01:16.361 align:middle line:90%
But look at this.

00:01:16.361 --> 00:01:20.201 align:middle line:84%
It's telling us
that, in the table

00:01:20.201 --> 00:01:23.411 align:middle line:84%
ZADDITIONALASSETATTRIBUTES,
that there's

00:01:23.411 --> 00:01:25.841 align:middle line:84%
a column called
ZREVERSELOCATIONDATA,

00:01:25.841 --> 00:01:28.981 align:middle line:84%
and there are 8 binary
plists hidden in there.

00:01:28.981 --> 00:01:33.681 align:middle line:84%
In ZDISTANCEIDENTITY,
there are 10 binary plists.

00:01:33.681 --> 00:01:38.421 align:middle line:84%
In this table,
ZCLOUDMASTERMEDIAMETADATA,

00:01:38.421 --> 00:01:41.541 align:middle line:84%
there's a m and it
has 11 binary plists.

00:01:41.541 --> 00:01:42.661 align:middle line:90%
So you get the point.

00:01:42.661 --> 00:01:44.271 align:middle line:84%
It tells you the
table, the column,

00:01:44.271 --> 00:01:45.931 align:middle line:90%
and you know what's there.

00:01:45.931 --> 00:01:48.441 align:middle line:84%
If you want to go-- ooh, sorry,
I zoomed out the wrong way.

00:01:48.441 --> 00:01:54.881 align:middle line:84%
If you want to go
take a look at it,

00:01:54.881 --> 00:01:58.541 align:middle line:84%
you can go into sqlite_miner,
you'll see output.

00:02:02.888 --> 00:02:04.471 align:middle line:84%
It's sorted by dates
and times, so I'm

00:02:04.471 --> 00:02:05.763 align:middle line:90%
going to look at Photos.sqlite.

00:02:05.763 --> 00:02:07.921 align:middle line:84%
You can see
Photos.investigated.sqlite.

00:02:07.921 --> 00:02:09.541 align:middle line:90%
You also have a results.csv.

00:02:09.541 --> 00:02:11.431 align:middle line:90%
You could look at it this way.

00:02:11.431 --> 00:02:14.071 align:middle line:84%
But you can go and
look at these files.

00:02:14.071 --> 00:02:16.441 align:middle line:84%
Let's say you actually
wanted to export them.

00:02:16.441 --> 00:02:18.841 align:middle line:90%
You can do --export.

00:02:18.841 --> 00:02:22.621 align:middle line:84%
If you want to decompress
them, you can do --decompress.

00:02:22.621 --> 00:02:24.631 align:middle line:90%
Just be careful how far you go.

00:02:24.631 --> 00:02:27.961 align:middle line:84%
If you do
--decompress, and there

00:02:27.961 --> 00:02:31.741 align:middle line:84%
are a whole bunch of GZips
or other TAR archives,

00:02:31.741 --> 00:02:34.111 align:middle line:84%
it will decompress
all of them, and that

00:02:34.111 --> 00:02:35.421 align:middle line:90%
could take a period of time.

00:02:35.421 --> 00:02:39.001 align:middle line:84%
So I usually recommend doing
--export and then looking

00:02:39.001 --> 00:02:40.051 align:middle line:90%
for relevance.
