You can do an sql query to get all the links. You can also add this app: https://apps.nextcloud.com/apps/sharelisting and do a script via bash to check and list shares.
If you want to see what happens with all the public links you can either write an sql query or use this: https://apps.nextcloud.com/apps/files_trackdownloads to see downloads of public links.