• Extract creation timestamp of a note from Google Keep Notes.
  • Finding location, date & time from Slack Messages.
  • Extract no. of tasks completed and created from Google Tasks.
  • Finding secret code from Google Docs cache.
  • Extract first opened timestamp of a Game.

Challenge Points: 989
Challenge Solves: 6
Challenge Author: g4rud4

Challenge Description


Download the challenge file from here


Initial Analysis

We are given a with an Android Device dump, I will be using Alexis Brignoni‘s ALEAPP to parse the given android dump. ALEAPP generated a HTML report of all artifacts that can be parse by it.

Android stores its application data in /data/data directory and all the installed applications in /data/app directory.

We can see a lot of apps being installed, some of which are Google apps, Slack, Dr. Driving, etc.

Android Version

From the ALEAPP report, we can see that the given Android device is running Android 10.

Answering 1st Question

  1. When did the Professor create the note for Rio?

We can only find one note taking app installed, i.e: Google Keep - Notes and Lists. Keep stores user data in the following directory: /data/data/ Only file of interest for this question is keep.db present in databases directory. We can go through the database and extract the creation time of the Note.

As we already ran ALEAPP, we can go check the Google Keep - Notes report.

Google Keep

As highlighted above, We can get the note creation time as 2021-07-19 12:28:39. Converting that to the format mentioned in the description would result in 19-07-2021_12:28:39.

If you want to learn more about the artifacts of Google Keep, checkout my blog post here.

Answering 2nd Question

  1. Where did Professor and Rio, Plan to meet to plan the heist?

As Slack is installed on the device, they might have used it for communication.

This blog post from Alexis Brignoni, gives us a detailed info on how we can extract messages from Slack Workspace. And here you can find the SQL queries required for extracting chats and files shared in a slack workspace.

Slack stores user data in the following directory, \data\data\com.Slack.

Main files of interest are the database files named with the workspace ID found in databases directory.

We can see 2 files: org_T027GM97WJ3 and T027GM97WJ3.

Extracting messages from Slack

Extracting the useful data from org_T027GM97WJ3, we can get all the messages between Professor and Rio.

SELECT datetime(ts , 'unixepoch') AS 'Time Sent', channel_id, user_id, json_extract(message_json, '$.text') AS 'Messages' FROM messages ORDER BY ts;


As highlighted, we can see a message from user with user ID U027H1QN8MD, saying that they were planning to meet exactly at 9 PM on July 20, 2021 at this location.

We can get the Latitude and Longitude from the url shared.

Hence, we got the answer. Latitude and Longitude as 13.106_80.225

Answering 3rd Question

  1. When did Rio plan to meet Professor?

We got the answer for this question in the previous question.

We need to answer in original timezone, so irrespective of timezone that the user using on slack, we don’t need to convert it to different timezone.

So, We got our answer. Converting it to the format given in description, results in 20-07-2021_21:00:00.

Answering 4th Question

  1. How many members did Rio gathered for the heist?

From the Slack messages that we extracted previously. We can see a conversation regarding how many members for heist. Where Rio says, he is having a team of 11 members.

Members for the heist

We got the answer. Members for the heist are 11.

Answering 5th Question

  1. How many tasks did Rio created in planning the heist, and how many did he complete?

As there are a lot of Google apps installed, we found an installation of Google Tasks.

Google Tasks stores user data at \data\data\\.

Main files of interest is data.db present in files\tasks-109039317116448576167\.

This database contains a lot of tables, but the table of interest is Tasks. Where we can find Task ID, Task list ID, completion status, Effective task(A blob data contains infomation about task, task details, creation, modification, & completion timestamps) etc.


AS highlighted, we can see that 4 tasks were created and 3 were completed. Converting to the format mentioned in description, results in 4_3.

Answering 6th Question

  1. There is a secret code present in a document shared between Rio & Professor, can you find out what it is?

From the Slack messages, we saw some conversion, where Rio sharing a link to the document. And also Google Docs is installed in the android device.

We can find the 1st page cache of the document opened via Google docs from the mobile device.

Finding docs cache

Location for the documents cache is data\data\\cache\docs_glide\data. We will find some images where they contain the 1st page cache.

cached image

From the image you can find the secret code used by Rio & Professor.

Secret code is MintMMCT15AUG.

Answering 7th Question

  1. We found a game installed on the device. When did Rio first open this game?

We only found one game installed on the device. Which is Dr. Driving. We are asked to find the first open time of this game.

Dr. Driving stores user data at data\data\com.ansangha.drdriving.

Finding First Time app opened

Main files for interest is present in shared_prefs.

<long value="1626782632701" name="last_upload"/>
<long value="1626782629126" name="first_open_time"/>
<long value="1628089054881" name="health_monitor:start"/>
<string name="previous_os_version">10</string>
<boolean value="true" name="has_been_opened"/>
<boolean value="false" name="allow_remote_dynamite"/>
<long value="1628089934425" name="last_pause_time"/>

This file contains some metadata information about first time app opened, last upload, previous os version, etc.

Converting the epoch timestamp to UTC, we get 20-07-2021_12:03:49.


Combining all answers gives us the flag.


For further queries, please DM on Twitter: