Skip to content

File

Contains collected files per machine.

erDiagram
    FileType ||--o{ File : "FileTypeID"
    Machine ||--o{ File : "MachineID"

Fields

Field Type Description
CreationTime datetime CreationTime of the file
Data varbinary File data
Filename string File name
FileTypeID numeric Internal ID that references the FileType entity (Foreign Key)
ID numeric Internal ID for the File entity (Primary Key)
LastAccessTime datetime Last access time of the file
LastWriteTime datetime Last write time of the file
MachineID numeric Internal ID that references the Machine entity (Foreign Key)
Path string Original full path of the file

References

Column Name Referenced Table Description
FileTypeID FileType Lookup table for collected file types
MachineID Machine Basic machine information. A machine is a physical or virtual device that can be scanned by OctoSAM Inventory. A machine can also be a mobile device such as a phone or tablet.