Difference between revisions of "TruxtonEXIF"

From truxwiki.com
Jump to navigation Jump to search
 
(20 intermediate revisions by the same user not shown)
Line 1: Line 1:
This class lets you add to the [[EXIF Table | EXIF]] table in Truxton.
+
This class lets you add to the <code><nowiki>[</nowiki>[[EXIF Table|EXIF]]<nowiki>]</nowiki></code> table in Truxton.
 +
Truxton will store any information about an imaging device it can find in this table.
 +
This information may not come from [https://en.wikipedia.org/wiki/Exif Exif] sections of the exploited file.
 +
If the same information is embedded using a different format, the fields of the <code><nowiki>[</nowiki>[[EXIF Table|EXIF]]<nowiki>]</nowiki></code> table will still be filled with that data.
 +
Just because there's a record in the <code><nowiki>[</nowiki>[[EXIF Table|EXIF]]<nowiki>]</nowiki></code> doesn't mean that data came from an [https://en.wikipedia.org/wiki/Exif Exif] blob.
 +
 
 
=Attributes and Methods=
 
=Attributes and Methods=
 +
==<code>addnote(text: str) -> boolean</code>==
 +
This adds an investigator's note.
 +
The <code>text</code> parameter is the contents of the note.
 +
It will return
 +
[https://docs.python.org/3.10/library/constants.html?highlight=false#True True] if the tag was associated with the EXIF, [https://docs.python.org/3.10/library/constants.html?highlight=false#False False] on failure.
 +
The note is stored in the <code>[InvestigatorNote]</code> table in the database.
 +
 +
==<code>altitude: float</code>==
 +
The altitude in meters.
 +
 +
==<code>altitudeoffset: int</code>==
 +
The offset into the file where the altitude was found.
 +
 +
==<code>bodyserialnumber: str</code>==
 +
The serial number of the body of the imaging device.
 +
 +
==<code>bodyserialnumberoffset: int</code>==
 +
The offset into the file where the body serial number was found
  
 +
==<code>devicetime: [https://docs.python.org/3/library/datetime.html datetime]</code>==
 +
The timestamp of the image taken from the clock of the imaging device.
 +
This value can be set with either a datetime value or an integer representing [https://docs.microsoft.com/en-us/windows/win32/api/minwinbase/ns-minwinbase-filetime FILETIME] ticks.
  
==<code>altitude</code>==
+
==<code>devicetimeoffset: int</code>==
==<code>altitude</code>==
+
The offset into the file where the device time was found.
==<code>altitudeoffset</code>==
 
==<code>bodyserialnumber</code>==
 
==<code>bodyserialnumberoffset</code>==
 
==<code>devicetime</code>==
 
==<code>devicetimeoffset</code>==
 
==<code>fileid</code>==
 
The [https://en.wikipedia.org/wiki/Universally_unique_identifier GUID] of the file this artifact came from.
 
This corresponds to the <code>FileID</code> column of the [[Entity Table | <code>Entity</code>]] table.
 
  
==<code>focallength</code>==
+
==<code>fileid: str</code>==
==<code>focallengthoffset</code>==
+
The [https://en.wikipedia.org/wiki/Universally_unique_identifier GUID] of the file this camera information came from.
==<code>gpstime</code>==
+
This corresponds to the <code>[FileID]</code> column of the <code><nowiki>[</nowiki>[[EXIF Table|EXIF]]<nowiki>]</nowiki></code> table.
==<code>gpstimeoffset</code>==
+
 
==<code>heading</code>==
+
==<code>focallength: int</code>==
==<code>headingoffset</code>==
+
The focal length of the lens in [https://en.wikipedia.org/wiki/35_mm_equivalent_focal_length 35mm equivalent.]
==<code>id</code>==
+
 
 +
==<code>focallengthoffset: int</code>==
 +
The offset in the file where focal length was found.
 +
 
 +
==<code>gpstime: [https://docs.python.org/3/library/datetime.html datetime]</code>==
 +
The timestamp from a [https://en.wikipedia.org/wiki/Global_Positioning_System GPS] unit in the imaging device.
 +
This value can be set with either a datetime value or an integer representing [https://docs.microsoft.com/en-us/windows/win32/api/minwinbase/ns-minwinbase-filetime FILETIME] ticks.
 +
 
 +
==<code>gpstimeoffset: int</code>==
 +
The offset in the file where the [https://en.wikipedia.org/wiki/Global_Positioning_System GPS] time was found.
 +
 
 +
==<code>heading: float</code>==
 +
The compass heading of the image.
 +
The direction the camera was pointing when the image was taken.
 +
 
 +
==<code>headingoffset: int</code>==
 +
The offset into the file where the heading was found.
 +
 
 +
==<code>id: str</code>==
 
This is the [https://en.wikipedia.org/wiki/Universally_unique_identifier GUID] of the record.
 
This is the [https://en.wikipedia.org/wiki/Universally_unique_identifier GUID] of the record.
 
It becomes non-zero after <code>save()</code> has been called.
 
It becomes non-zero after <code>save()</code> has been called.
This corresponds to the <code>ID</code> column of the [[Entity Table | <code>Entity</code>]] table.
+
This corresponds to the <code>[ID]</code> column of the <code><nowiki>[</nowiki>[[EXIF Table|EXIF]]<nowiki>]</nowiki></code> table.
==<code>latitude</code>==
+
 
==<code>latitudeoffset</code>==
+
==<code>latitude: float</code>==
==<code>lensserialnumber</code>==
+
The [https://en.wikipedia.org/wiki/Latitude latitude] portion of the geographic coordinate using the [https://en.wikipedia.org/wiki/World_Geodetic_System#WGS84 WGS84] ellipsoid.
==<code>lensserialnumberoffset</code>==
+
 
==<code>longitude</code>==
+
==<code>latitudeoffset: int</code>==
==<code>longitudeoffset</code>==
+
The offset into the file where the latitude was found.
==<code>make</code>==
+
 
==<code>makeoffset</code>==
+
==<code>lensserialnumber: str</code>==
==<code>mediaid</code>==
+
The serial number of the lens.
 +
 
 +
==<code>lensserialnumberoffset: int</code>==
 +
The offset into the file where the lens serial number was found.
 +
 
 +
==<code>longitude: float</code>==
 +
The [https://en.wikipedia.org/wiki/Longitude longitude] portion of the geographic coordinate using the [https://en.wikipedia.org/wiki/World_Geodetic_System#WGS84 WGS84] ellipsoid.
 +
Many thanks go to [https://en.wikipedia.org/wiki/John_Harrison John Harrison] for his work.
 +
 
 +
==<code>longitudeoffset: int</code>==
 +
The offset into the file where longitude was found.
 +
 
 +
==<code>make: str</code>==
 +
The manufacturer of the imaging device.
 +
 
 +
==<code>makeoffset: int</code>==
 +
The offset into the file where the make was found.
 +
 
 +
==<code>mediaid: str</code>==
 
This is the [https://en.wikipedia.org/wiki/Universally_unique_identifier GUID] of the media this artifact came from.
 
This is the [https://en.wikipedia.org/wiki/Universally_unique_identifier GUID] of the media this artifact came from.
This corresponds to the <code>MediaID</code> column of the [[Entity Table | <code>Entity</code>]] table.
+
This corresponds to the <code>[MediaID]</code> column of the <code><nowiki>[</nowiki>[[EXIF Table|EXIF]]<nowiki>]</nowiki></code> table.
  
==<code>model</code>==
+
==<code>model: str</code>==
==<code>modeloffset</code>==
+
The model of the imaging device.
  
==<code>save()</code>==
+
==<code>modeloffset: int</code>==
This will commit the information to the [[Entity Table | <code>Entity</code>]] table.
+
The offset into the file where the model was found.
 +
 
 +
==<code>save() -> boolean</code>==
 +
This will commit the information to the <code><nowiki>[</nowiki>[[EXIF Table|EXIF]]<nowiki>]</nowiki></code> table.
 
It will return [https://docs.python.org/3/library/constants.html#True True] if the record was saved to the database, [https://docs.python.org/3/library/constants.html#False False] if there was an error.
 
It will return [https://docs.python.org/3/library/constants.html#True True] if the record was saved to the database, [https://docs.python.org/3/library/constants.html#False False] if there was an error.
  
==<code>shuttercount</code>==
+
==<code>shuttercount: int</code>==
==<code>shuttercountoffset</code>==
+
The number of times the shutter has been activated on the imaging device.
==<code>tag(tag, reason, origin)</code>==
+
 
 +
==<code>shuttercountoffset: int</code>==
 +
The offset into the file where shutter count was found.
 +
 
 +
==<code>tag(tag: str, reason: str, origin: int) -> boolean</code>==
 
This creates a tag associated with this camera information in Truxton.
 
This creates a tag associated with this camera information in Truxton.
 
The <code>tag</code> parameter is a short, one or two word, bit of text that will be displayed in the UI.
 
The <code>tag</code> parameter is a short, one or two word, bit of text that will be displayed in the UI.
Line 51: Line 112:
 
The <code>origin</code> is either <code>TAG_ORIGIN_AUTOMATIC</code> (1) or <code>TAG_ORIGIN_HUMAN</code> (2).
 
The <code>origin</code> is either <code>TAG_ORIGIN_AUTOMATIC</code> (1) or <code>TAG_ORIGIN_HUMAN</code> (2).
 
It will return  
 
It will return  
[https://docs.python.org/3.8/library/constants.html?highlight=false#True True] if the tag was associated with the camera information, [https://docs.python.org/3.8/library/constants.html?highlight=false#False False] on failure.
+
[https://docs.python.org/3.10/library/constants.html?highlight=false#True True] if the tag was associated with the camera information, [https://docs.python.org/3.10/library/constants.html?highlight=false#False False] on failure.
  
==<code>thumbnaillength</code>==
+
==<code>thumbnaillength: int</code>==
==<code>thumbnaillengthoffset</code>==
+
The length of the thumbnail of this image.
==<code>thumbnailoffset</code>==
+
 
==<code>thumbnailoffsetoffset</code>==
+
==<code>thumbnaillengthoffset: int</code>==
 +
The offset in the file where the length of the thumbnail image was found.
 +
 
 +
==<code>thumbnailoffset: int</code>==
 +
The offset of the thumbnail image.
 +
 
 +
==<code>thumbnailoffsetoffset: int</code>==
 +
The offset in the file where thumbnail offset was found.
  
 
=Sample=
 
=Sample=
 
+
<source lang="Python" highlight="37-43">
<syntaxhighlight lang="Python" highlight="63-70">
+
import sys
 +
sys.path.append('C:/Program Files/Truxton/SDK')
 
import truxton
 
import truxton
 
import shutil
 
import shutil
Line 67: Line 136:
 
from calendar import timegm
 
from calendar import timegm
 
from pathlib import Path
 
from pathlib import Path
 
EPOCH_AS_FILETIME = 116444736000000000
 
HUNDREDS_OF_NANOSECONDS = 10000000
 
 
EVENT_TYPE_FBI = 20001
 
 
def date_to_filetime(dt):
 
  return EPOCH_AS_FILETIME + (timegm(dt.timetuple()) * HUNDREDS_OF_NANOSECONDS)
 
 
def create_event_type(t, id, name):
 
  event_type = t.neweventtype()
 
  event_type.id = id
 
  event_type.name = name
 
  event_type.save()
 
  
 
def add_file(parent_truxton_file, filename):
 
def add_file(parent_truxton_file, filename):
  source_file = open(filename, "rb")
 
 
   child = parent_truxton_file.newchild()
 
   child = parent_truxton_file.newchild()
 
   child.name = Path(filename).name
 
   child.name = Path(filename).name
   shutil.copyfileobj(source_file, child)
+
   with open(filename, "rb") as source_file:
  source_file.close()
+
    shutil.copyfileobj(source_file, child)
 
   child.save()
 
   child.save()
 +
 
   return child
 
   return child
 
def add_event(parent_file, start, end, title, description, type):
 
  event = parent_file.newevent()
 
  event.start = date_to_filetime(datetime.fromisoformat(start))
 
  event.end = date_to_filetime(datetime.fromisoformat(end))
 
  event.title = title
 
  event.description = description
 
  event.type = type
 
  event.save()
 
  return event
 
  
 
def add_media(t):
 
def add_media(t):
Line 112: Line 157:
 
   media.longitude = -77.036458
 
   media.longitude = -77.036458
 
   media.type = truxton.MEDIA_TYPE_LOGICAL_FILES
 
   media.type = truxton.MEDIA_TYPE_LOGICAL_FILES
 
+
   media.save()
   if media.save():
 
    print("Media saved")
 
  else:
 
    print("Media not saved")
 
  
 
   return media
 
   return media
  
def add_ec(parent_file ):
+
def add_cs(parent_file ):
   child_file = add_file(parent_file, "JW-v-DOJ-reply-02743.pdf")
+
   child_file = add_file(parent_file, "cs.jpg")
 
 
  url = child_file.newurl()
 
  url.url = "https://www.judicialwatch.org/documents/jw-v-doj-reply-02743/"
 
  url.localfilename = "JW-v-DOJ-reply-02743.pdf"
 
  url.type = truxton.URL_TYPE_FIREFOX
 
  url.method = truxton.URL_METHOD_TYPE_CLICKED_ON_A_LINK
 
  url.format = truxton.URL_FORMAT_ASCII
 
  url.when = date_to_filetime(datetime.fromisoformat("2020-05-20T00:00:00-05:00"))
 
  url.save()
 
  
   add_event( child_file, "2016-07-31T12:00:00-05:00", "2016-07-31T12:00:00-05:00", "Crossfire Hurricane Created", "At FBI HQ", EVENT_TYPE_FBI )
+
   exif = child_file.newexif()
   add_event( child_file, "2016-07-27T12:00:00-05:00", "2016-07-27T12:00:00-05:00", "Legat called needing to meet US ambassador", "In London", EVENT_TYPE_FBI )
+
  exif.latitude = 51.487329
   add_event( child_file, "2016-07-29T12:00:00-05:00", "2016-07-29T12:00:00-05:00", "FBI Receives Downer Info from Legat", "Probably legat London", EVENT_TYPE_FBI )
+
  exif.longitude = -0.124057
 +
  exif.make = "Universal"
 +
  exif.model = "Minute 16"
 +
   exif.devicetime = datetime.fromisoformat("2016-04-01T12:00:00-05:00")
 +
   exif.save()
  
 
def main():
 
def main():
 
   t = truxton.create()
 
   t = truxton.create()
 
  create_event_type(t, EVENT_TYPE_FBI, "FBI Actions" )
 
  
 
   media = add_media(t)
 
   media = add_media(t)
Line 146: Line 180:
 
   root_file.save()
 
   root_file.save()
  
   add_ec(root_file)
+
   add_cs(root_file)
  
 
if __name__ == "__main__":
 
if __name__ == "__main__":
   main()
+
   sys.exit(main())
</syntaxhighlight>
+
</source>

Latest revision as of 14:17, 11 September 2024

This class lets you add to the [EXIF] table in Truxton. Truxton will store any information about an imaging device it can find in this table. This information may not come from Exif sections of the exploited file. If the same information is embedded using a different format, the fields of the [EXIF] table will still be filled with that data. Just because there's a record in the [EXIF] doesn't mean that data came from an Exif blob.

Attributes and Methods

addnote(text: str) -> boolean

This adds an investigator's note. The text parameter is the contents of the note. It will return True if the tag was associated with the EXIF, False on failure. The note is stored in the [InvestigatorNote] table in the database.

altitude: float

The altitude in meters.

altitudeoffset: int

The offset into the file where the altitude was found.

bodyserialnumber: str

The serial number of the body of the imaging device.

bodyserialnumberoffset: int

The offset into the file where the body serial number was found

devicetime: datetime

The timestamp of the image taken from the clock of the imaging device. This value can be set with either a datetime value or an integer representing FILETIME ticks.

devicetimeoffset: int

The offset into the file where the device time was found.

fileid: str

The GUID of the file this camera information came from. This corresponds to the [FileID] column of the [EXIF] table.

focallength: int

The focal length of the lens in 35mm equivalent.

focallengthoffset: int

The offset in the file where focal length was found.

gpstime: datetime

The timestamp from a GPS unit in the imaging device. This value can be set with either a datetime value or an integer representing FILETIME ticks.

gpstimeoffset: int

The offset in the file where the GPS time was found.

heading: float

The compass heading of the image. The direction the camera was pointing when the image was taken.

headingoffset: int

The offset into the file where the heading was found.

id: str

This is the GUID of the record. It becomes non-zero after save() has been called. This corresponds to the [ID] column of the [EXIF] table.

latitude: float

The latitude portion of the geographic coordinate using the WGS84 ellipsoid.

latitudeoffset: int

The offset into the file where the latitude was found.

lensserialnumber: str

The serial number of the lens.

lensserialnumberoffset: int

The offset into the file where the lens serial number was found.

longitude: float

The longitude portion of the geographic coordinate using the WGS84 ellipsoid. Many thanks go to John Harrison for his work.

longitudeoffset: int

The offset into the file where longitude was found.

make: str

The manufacturer of the imaging device.

makeoffset: int

The offset into the file where the make was found.

mediaid: str

This is the GUID of the media this artifact came from. This corresponds to the [MediaID] column of the [EXIF] table.

model: str

The model of the imaging device.

modeloffset: int

The offset into the file where the model was found.

save() -> boolean

This will commit the information to the [EXIF] table. It will return True if the record was saved to the database, False if there was an error.

shuttercount: int

The number of times the shutter has been activated on the imaging device.

shuttercountoffset: int

The offset into the file where shutter count was found.

tag(tag: str, reason: str, origin: int) -> boolean

This creates a tag associated with this camera information in Truxton. The tag parameter is a short, one or two word, bit of text that will be displayed in the UI. The reason a sentence explaining why this camera information was tagged. The origin is either TAG_ORIGIN_AUTOMATIC (1) or TAG_ORIGIN_HUMAN (2). It will return True if the tag was associated with the camera information, False on failure.

thumbnaillength: int

The length of the thumbnail of this image.

thumbnaillengthoffset: int

The offset in the file where the length of the thumbnail image was found.

thumbnailoffset: int

The offset of the thumbnail image.

thumbnailoffsetoffset: int

The offset in the file where thumbnail offset was found.

Sample

import sys
sys.path.append('C:/Program Files/Truxton/SDK')
import truxton
import shutil

from datetime import datetime
from calendar import timegm
from pathlib import Path

def add_file(parent_truxton_file, filename):
  child = parent_truxton_file.newchild()
  child.name = Path(filename).name
  with open(filename, "rb") as source_file:
    shutil.copyfileobj(source_file, child)
  child.save()

  return child

def add_media(t):
  media = t.newmedia()

  media.name = "Public Documents"
  media.description = "Publicly available documents"
  media.case = "DC-SNAFU-2016.2020"
  media.evidencebag = "EV-0937459386623-a"
  media.originator = "Jeffrey Jensen"
  media.latitude = 38.897661
  media.longitude = -77.036458
  media.type = truxton.MEDIA_TYPE_LOGICAL_FILES
  media.save()

  return media

def add_cs(parent_file ):
  child_file = add_file(parent_file, "cs.jpg")

  exif = child_file.newexif()
  exif.latitude = 51.487329
  exif.longitude = -0.124057
  exif.make = "Universal"
  exif.model = "Minute 16"
  exif.devicetime = datetime.fromisoformat("2016-04-01T12:00:00-05:00")
  exif.save()

def main():
  t = truxton.create()

  media = add_media(t)

  root_file = media.addroot()
  root_file.save()

  add_cs(root_file)

if __name__ == "__main__":
  sys.exit(main())