keepassxreboot / keepassxc

KeePassXC is a cross-platform community-driven port of the Windows application “Keepass Password Safe”.
https://keepassxc.org/
Other
21.36k stars 1.47k forks source link

Find duplicate or very similar entries #10586

Open smehrens opened 7 months ago

smehrens commented 7 months ago

Summary

Pleace provide a "find duplicates" to show all entries with same (username and password) or (website and username) and a) delete duplicate entries b) mark one entry as "main" and set references to password (and maybe username) in all "minor" entries.

Examples

Multiple entries for user "amueller for" websites: account.foobar.com cloud.foobar.com groupware.foobar.com external-tools.barfoor.com

click on "find duplicate":

select main account:

Context

To found duplicates and delete or link(references) them

smehrens commented 7 months ago

okay sorry... a just found a way for a) by filtering the list and by showing the passwords.

but there ist no easy way to reference to entries.

droidmonkey commented 7 months ago

Reference syntax: https://keepassxc.org/docs/KeePassXC_UserGuide#_entry_cross_reference

We have had requests for 'duplicate detection' before. I cannot find an open issue so I'll keep this one open.

brianjmurrell commented 2 months ago

We have had requests for 'duplicate detection' before. I cannot find an open issue so I'll keep this one open.

2202 perhaps? Although that one is for a manual de-duplication, I suggested that automatic duplication detection would be more ideal.

Viper780 commented 1 month ago

Reference syntax: https://keepassxc.org/docs/KeePassXC_UserGuide#_entry_cross_reference

We have had requests for 'duplicate detection' before. I cannot find an open issue so I'll keep this one open.

should be #750 or #2369

because of merging some databases I have many duplicates but with small differences (other Favicon, different subdomain, different comment,...)

nerdoc commented 1 month ago

I think this iss not the same as https://github.com/keepassxreboot/keepassxc/issues/551. A Health check tool can make use of duplicate detection. But if you merge another db into yours, typically a diverged copy of your passwords db, 99,9% are duplicates, you want to just "add" the 3 passwords you saved accidentally in your other copy. So the health check does not apply, as the db is already "health checked", and let's say all passwords are super-secure and unique. Except the 99,9% of the just merged.

And this must be done at the merging procedure. So when some passwords are matching 100%, just don't include them.

droidmonkey commented 1 month ago

This would never be implemented to exclude valid merge entries. That would be completely improper. This is most useful as a report (allongside the other database reports) that allows you to make a decision on the various entries.

PS- if you know which 3 entries need to be moved over just open both databases and drag/drop the 3

nerdoc commented 1 month ago

But what is the valid use case of having an exact copy of an already existing entry? I just can't think about one. If I have a double entry, I delete one, as it leads to problems when you change one of the two and have diverged entries.

Viper780 commented 1 month ago

Exactly there is no point to have double entrys. But when importing some hundred entrys and have of them are duplicates (maybe with a different comment, another favicon or in a different group) finding and deleting them by hand is half a days work.

Keepass has a duplicate check which is very helpful and it would solve such problems in seconds

droidmonkey commented 1 month ago

The only time you have a true duplicate in the keepass world is when two entries have the same uuid.