# Backup detailed summary / file list

**URL:** https://forum.duplicati.com/t/backup-detailed-summary-file-list/10156
**Category:** Features
**Created:** [June 26, 2020, 7:36am UTC](https://forum.duplicati.com/t/backup-detailed-summary-file-list/10156 "2020-06-26T07:36:28Z")
**Posts on this page:** 1
**Showing post:** 13

<div class="post-metadata">

### Author: ![ts678](https://forum.duplicati.com/letter_avatar_proxy/v4/letter/t/8491ac/32.png) [@ts678](https://forum.duplicati.com/u/ts678)
#### Post date: [February 5, 2024, 12:49am UTC](https://forum.duplicati.com/t/backup-detailed-summary-file-list/10156/13 "2024-02-05T00:49:04Z")

</div>

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

```plaintext
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](https://forum.duplicati.com/t/files-incorrectly-flagged-as-modified/17368/11) 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.

---

_[View the full topic](https://forum.duplicati.com/t/backup-detailed-summary-file-list/10156)._