Zach Zeid
11/17/2022, 6:59 PMGavin
11/17/2022, 7:20 PMfile
table
Something like this could be a starting point
SELECT
f.filename,
f.path,
u.username AS file_owner,
g.groupname AS group_owner,
datetime(f.atime,'unixepoch') AS file_last_access_time,
datetime(f.mtime,'unixepoch') AS file_last_modified_time,
datetime(f.ctime,'unixepoch') AS file_last_status_change_time,
datetime(f.btime,'unixepoch') AS file_created_time,
ROUND((f.size * 10e-7),4) AS size_megabytes
FROM file f
LEFT JOIN users u ON f.uid = u.uid
LEFT JOIN groups g ON f.gid = g.gid
WHERE ((f.directory like "/home/%%/.local/share/JetBrains/%/")
OR (f.directory like "C:\users\%\AppData\%\JetBrains\%\Plugins\")
OR (f.directory like "/Users/%/Library/Application Support/JetBrains/%/plugins/"))
AND (
(filename not like "%.xml") AND (filename not like "%.json") AND
(filename not like "%.etag")
);
Zach Zeid
11/17/2022, 8:09 PMseph
11/17/2022, 10:09 PM