Backup detailed summary / file list

Features
13

Possible query that for now needs manual help based on look into Fileset table to find highest two ID:

WITH
New AS (
	SELECT Path,BlocksetID FROM FilesetEntry JOIN File ON FilesetEntry.FileID = File.ID WHERE FilesetID = 633
),
Old AS (
	SELECT Path,BlocksetID FROM FilesetEntry JOIN File ON FilesetEntry.FileID = File.ID WHERE FilesetID = 632
)
SELECT New.Path FROM New JOIN Old WHERE New.Path = Old.Path AND New.BlocksetID <> Old.BlocksetID;

This is just automating (for all common files) the manual database study that I suggested be done for
Files incorrectly flagged as modified which I think hit the actual question: what files had data change?
We’re getting extra metadata changes mixed in. They cause small uploads (metadata is pretty small).
More annoyingly, they cause file scans and it’s not clear what gets found. Above SQL can help a little.

1 Like