Yeah you heard it right. There is solid reason for Grand 2 fans to delight. Samsung has always been choosy in providing updates to their devices, at least for the low end and mid-range devices. Android KitKat was the last upgrade provided by Samsung, and no updates since then. But you need not worry, the developer community has already started building Cyanogen Mod 13 for grand 2, which is based on Android Marshmallow i.e. 6.0. [Read more…]
Sqlite is one of the popular database formats is used by many mobile systems including Android devices for structured data storage. Sqlite application is an open source application and resembles SQL server but is lite implementation of it. Android supports Sqlite application through dedicated APIs and it happens to be a crucial source of evidence from forensics prospect. Sqlite files used by the apps are usually stored at the location: /data/data/<ApplicationPackageName>/databases. Forensically, these files are highly important, as these files will store valuable data handled by respective application. Many apps are used for making fund transfers, booking tickets, bank transactions, and personal chats. These details can be found in apps Sqlite files, which can be interrogated for evidence.
Important Sources for Forensics Investigation
- Browser Memory
- Application storage
- External Card & System Storage
- Sqlite Database files
- SMS/Call Records
- GPS Records
- Social Sites (Facebook, Twitter)
- Messenger (MSN, Yahoo)
- Email associated data
Sqlite database analysis of Android device can be done either using an image of the device data or by accessing the files through a rooted device. Once the device is rooted, investigators can acquire all the Sqlite files of apps. These files can belong to many applications and its analysis can lead to multiple pieces of evidence. For instance, database file of a YouTube app of an android device comprises of several tables showing details like _id (for each entry made in YouTube app), display1, display2, query (text typed for searching video) and date (epoch date and time stamp).
Explore Sqlite File for Investigation
Sqlite forensic explorer is adept application software, which is capable to perform complete examination of a Sqlite file. Android application data is saved in different versions of Sqlite file. This application program is capable to explore the Sqlite files and the tables embedded. For this, install the application and launch it.
Learn More about the Product
Product Name: Sqlite Forensic Explorer
Size: 13.3 MB
Supported Operating system: Windows 8, 7, Vista, and XP
Free Demo: Available
Product Website Link: http://www.acquireforensics.com/products/sqlite-forensic-explorer/
Step by step guide to perform Sqlite data analysis with SqLite Forensics Explorer:
- Click on Add File which will pop-up another window for adding the file. Click on the Browsing icon to add the Sqlite file saved on the system.
- Left-pane will show up all the tables present in the Sqlite file. Different tables store different data like “urls”, “visits”, “keyword search”, “downloads”, Users can view any of the table and integrated data in it. Here, different rows of the tables can be viewed like title, url, visit_cont, types_count, last_visit_time hidden, favicon_id, etc.
- Users can view the details in Hex tab. Hex view helps in interrogating the data unaltered. Users can perform the analysis on the data here and can check for the manipulation done here.
- This software can also show Deleted tab where deleted data from the Sqlite file can be viewed.
- This application has this Query feature which help to examine the Sqlite database using commands. SQL Editor Functionality helps to add multiple queries for performing execution on the database added. These queries can also be saved for future analysis.
This software also allows recovery of corrupted data from Sqlite database. Its support towards damaged Sqlite files provides an exceptional functionality for forensics investigation. It is a comprehensive application program, which allows users to export the carved details to CSV, PDF or HTML file for further analysis or reporting purpose. It supports varied formats of Sqlite like .db or .sqlite and this allows variant of Sqlite databases to be examined. Investigators can dig into details by viewing the data in Hex format and the deleted data. It also supports BLOB data type for analyzing multimedia components.
The material design on Android lollipop is truly a sight to behold. With so many transitions and animations, along with premium white settings as compared to black ones, Android is looking better than any of the previous versions. The problem is, not everyone have received Lollipop yet. The recent data suggests that adoption rate of Android 5.0 is just 1.6%, which is nowhere. Majority of the Android devices are still using Android Kit Kat (39%) and 44.5% running on Android Jellybean (4.1, 4.2 and 4.3 combined). [Read more…]
Outlook has been provided by Microsoft for both Windows as well as Mac Operating Systems. Microsoft Outlook 2011 that is provided for Mac Operating System is a widely used email client and is quite similar to Outlook for Windows in numerous ways. However, the difference lies in the data file formats used in both the client versions for storing user data. MS Outlook for Windows provides a local archive of the user’s mailbox on the system in a Personal Storage Table (PST) file format. In Outlook for Mac, the Microsoft User Data folder stores the data file. This file includes the entire data in the user’s mailbox such as; email messages, contacts, calendar events, notes, tasks, and other items. [Read more…]
Smartphones have become our lifelines today. With new features and hardware coming along in new smartphones, our dependency have increased a lot on them. Apart from just using it to send out important mails and updating social media profiles, we even use it for storing precious information like official presentations, documents and other stuff. There is always risk of losing data, so it is always recommended to take backups. Unfortunately, in our busy lives today, it is impossible to take complete backups due to the amount of time it takes. However, you do not need to worry about it anymore now! I am going to introduce you to a tool, called Vibosoft Dr. Mobile for Android which helps you to take one click backups and restore if needed. [Read more…]
PDF unlocker is a commercial application which unlocks the PDF files protected by owner level password. Issues in unlocking PDF files usually downloaded from the web, which came with restrictions are usually confronted. However, the difficulties that were earlier faced in the task of unlocking protected PDF’s have now been lowered to a greater level with the availability of this software. [Read more…]
DBX to PST Converter is a conversion application from a prestigious company. The main functionality of the utility is to convert the Outlook Express (a desktop based mail program) DBX files into various forms like EML, PST and MSG too. It has been developed with many enhanced characteristics and this makes it a highly proficient tool for the conversion. [Read more…]
In today’s digital world, virtualization in IT infrastructure has gained importance and is being used currently by almost all IT industries. Undoubtedly, it can be said that VMware virtualization is a robust, reliable and proven virtualization platform that creates VMDK files. It also reduces capital and operational costs by increasing energy efficiency and requiring less hardware. In spite of all these advantages that the VMware application offers, the disadvantage is that the VMDK files are not immune to corruption issues. The VMDK files may get damaged due to corruption issues and also VMware error while powering on a Windows virtual machine may be encountered. At such situations the query arises as how to get rid of the error and resolve such corruption issues and its consequences. [Read more…]
Running a race to get the best is human tendency! However, definition of “Best” varies according to the requirement and not just on universal acceptance. Something is in case of IBM Notes and MS Outlook. Notes® is integrated with facility for emailing, forum discussions, programming, calendaring and scheduling etc. and for its exceptional services, IBM do charges a good amount.
Meanwhile, if there is requirement for sheer emailing, then spending a high amount on Notes is surely not an intelligent approach. This could be the reason why users now days are more interested in Outlook than Lotus Notes. The idea of changing mail service at an organizational level is not easy and thus there is high risk of data loss while migration. [Read more…]
If you own a smartphone that has good camera, than you might be using it for taking selfies, nature snaps and some funny images with your dear ones. Over time, the number of images on your phone builds up. Very soon, you will realize that your gallery is filled with all those memories you have captured with your device. Many images are sometimes embarrassing, wherein you might have been trolled, or might include some private moments with your near and dear ones. So, it’s better to hide images from gallery. In such cases, you do not want anyone else to see your images and rather prefer them keeping to yourself. Luckily, there are certain easy ways that will prevent your private photos from being displayed in gallery. [Read more…]