summaryrefslogtreecommitdiff
path: root/graphs/sql/file_archaeology/req01.sql
diff options
context:
space:
mode:
Diffstat (limited to 'graphs/sql/file_archaeology/req01.sql')
-rw-r--r--graphs/sql/file_archaeology/req01.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/graphs/sql/file_archaeology/req01.sql b/graphs/sql/file_archaeology/req01.sql
new file mode 100644
index 0000000..9a9d059
--- /dev/null
+++ b/graphs/sql/file_archaeology/req01.sql
@@ -0,0 +1,2 @@
+SELECT MIN(size) FILTER (WHERE filename ILIKE '%secret%') AS smallest_secret_file_size, MIN(size) AS smallest_file_size
+FROM dtf.madelines_files