![]() ![]() BLOB, short for Binary Large Object, is a datatypeįound in databases to store binary objects such as image, music, or videoįiles. Just right click the cell in which you want to view, and a new window will open with your selection.Ĭontain BLOB data, the ability to open and view that data with an external Notice in the image below that after choosing the correct date/time format, all the data in that column was converted to the selection.Įxaminers can now also open embedded plists, in addition to pictures, with our own internal viewer within AXIOM Examine. ![]() You can also choose to display the data as Boolean values, various date/time formats, or as a picture inside the SQLite Viewer. As seen below, right clicking the column header gives the examiner options to convert the data in the column to ASCII, hex, Unicode, etc. New in AXIOM 3.2 are even more features integrated into the SQLite Viewer! Now when examining SQLite databases in your case, we’ve added the ability to decode data within the table. Or SQLite queries and you need a quick way to report on the information shown.Īdditional functionally that is included in the new SQLite Viewer includes freezing columns and opening images directly from cells with supporting data types. This can be especially useful after applying string searches, filters, Just select the Export function in the SQLite Viewer,Īnd the current table you have displayed can be exported into Excel or. column1” (example seen below).įinally, creating a report from the displayed table is exceptionally easy Or even join information from multiple tables in a query such as “SELECT column2, column3 FROM table1 INNER JOIN table2 ON table1. For example, you can run a simple SELECT statement such as “SELECT column FROM table”. The queries are run just like you would normally see in any SQLite browsing environment. In this enhanced SQLite Viewer, examiners even have the ability to run SQL queries on the open database using the Build Query function right within the AXIOM interface. When the funnel icon is clicked in the header of the column, a menu will appear allowing the examiner to choose to display certain rows based on the criteria entered by the user. Simply hit Clear next to the string search text box to remove the search hit view and return to all rows being displayed.Įach column in the table has filtering functionality. The string will be highlighted where it is found within the table. Using the Find button, you can perform a string search within the table that is open. You can easily recheck the columns at any time if you wish to see them again. Just by unchecking the unwanted columns, they will disappear from your view, helping to avoid too much clutter. The Show/Hide button will give the ability to toggle columns on and off, so you can choose narrow down the fields to be shown. ![]() The number of lines that are found in each table will be in parenthesis next to the table name in the dropdown menu. ![]() Using the dropdown, you can browse different tables within the database. Viewer will open on the right side of the user interface.Īs you can see in the screen above, many options are now available for you to utilize when reviewing the database file. To utilize the new features in AXIOM Examine, first select any SQLiteĭatabase file in the File System view, regardless of file extension. You can even export directly from these tables into both. This includes the ability to hide and filter on columns, search tables, and perform custom SQL queries. Now, we’ve added the ability for examiners to truly be able to dig deep and present their findings in a useful manner. In previous versions of AXIOM, we allowed you to see the data within the SQLite databases within your case, but interacting with the data was limited. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |