Immich•17mo ago

Is there a way to compare two immich users and check duplicate items?

I want to compare two immich users and see the duplicate photos/videos. Is there a way to do so?

Immich•8/27/24, 7:29 PM

:wave: Hey @ksharizard,

Thanks for reaching out to us. Please follow the recommended actions below; this will help us be more effective in our support effort and leave more time for building Immich :immich:.

References

Container Logs:
```
docker compose logs
```
```
docker compose logs
```
docs
Container Status:
```
docker compose ps
```
```
docker compose ps
```
docs
Reverse Proxy: https://immich.app/docs/administration/reverse-proxy

## Checklist

:ballot_box_with_check: I have verified I'm on the latest release(note that mobile app releases may take some time).
:ballot_box_with_check: I have read applicable release notes.
:ballot_box_with_check: I have reviewed the FAQs for known issues.
:ballot_box_with_check: I have reviewed Github for known issues.
:ballot_box_with_check: I have tried accessing Immich via local ip (without a custom reverse proxy).
:blue_square: I have uploaded the relevant logs, docker compose, and .env files, making sure to use code formatting.
:ballot_box_with_check: I have tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable

(an item can be marked as "complete" by reacting with the appropriate number)

If this ticket can be closed you can use the

/close

/close

command, and re-open it later if needed.

ksharizardOP•8/27/24, 7:32 PM

I want to be able to compare users as I have used two different takeouts for the users and I have different photos/videos items for both. I want to see what is duplicated and what is not from both.

Alex Tran•8/27/24, 7:56 PM

there is not, duplication is per user only

Zeus•8/27/24, 9:21 PM

You can find identical duplicates by SHA sum using the database:

Zeus•8/27/24, 9:21 PM

select checksum from assets t1
where (select count(*) from assets t2
where t1.checksum = t2.checksum and t1."deletedAt" is null and t2."deletedAt" is null) > 1
order by "fileCreatedAt"

select checksum from assets t1
where (select count(*) from assets t2
where t1.checksum = t2.checksum and t1."deletedAt" is null and t2."deletedAt" is null) > 1
order by "fileCreatedAt"

Zeus•8/27/24, 9:21 PM

@Varun would it be possible to add a feature like this to PowerTools?

Alex Tran•8/27/24, 9:43 PM

I would be careful with this since we don't want to create a platform that the admin user can easily see the other users assets without explicit permission

Alex Tran•8/27/24, 9:43 PM

granted that if you are the admin, you can just access the file system

AAlex Tran I would be careful with this since we don't want to create a platform that the a...

Zeus•8/27/24, 10:00 PM

Hm. that’s true , but the way power tools works it has access to the entire database anyway

Zeus•8/27/24, 10:01 PM

Good point though

Varun•8/28/24, 3:08 AM

Actually we can find the duplicate items and prompt the users,

but I wouldnt suggest touching the write functionality and override what immich supports.

Varun•8/28/24, 3:09 AM

With power tools I'm limiting any write operations to the boundary of immich's API and for reads I'm doing it directly from DB for faster implementation.

Zeus•8/28/24, 3:18 AM

I wouldn’t suggest a write function, but having the ability to view even a list of files/links would be nice

Zeus•8/28/24, 3:18 AM

There’s a new SQL query in #12086

ZZeus There’s a new SQL query in #12086

Immich•8/28/24, 3:18 AM

[Pull Request] docs: sql query for duplicate files (immich-app/immich#12086)

bigworm•9/14/24, 3:41 PM

I am interested in this functionality also...would save me from having to redo a takeout and reimporting.

radh•9/14/24, 5:04 PM

One thing that would be cool.

In shared albums, if different people have the same image - it would be nice if Immich automatically stacks them..

References

Container Logs:

docker compose logs

docker compose logs

docs

Container Status:

docker compose ps

docker compose ps

docs

Reverse Proxy: https://immich.app/docs/administration/reverse-proxy

# Checklist

:ballot_box_with_check: I have verified I'm on the latest release(note that mobile app releases may take some time).

:ballot_box_with_check: I have read applicable release notes.

:ballot_box_with_check: I have reviewed the FAQs for known issues.

:ballot_box_with_check: I have reviewed Github for known issues.

:ballot_box_with_check: I have tried accessing Immich via local ip (without a custom reverse proxy).

:blue_square: I have uploaded the relevant logs, docker compose, and .env files, making sure to use code formatting.

:ballot_box_with_check: I have tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable

(an item can be marked as

"complete

" by reacting with the appropriate number

)

If this ticket can be closed you can use the

/close

/close

command

, and re

-open it later if needed

Is there a way to compare two immich users and check duplicate items?

References

Similar Threads

Similar Threads

References

Similar Threads