OpenCms 11: SQL-Statement to find state before publishing

Hi list,

one of our customers accidentally published about 1000 files.
We need to find out,

  1.  Which files were published for the first time
  2.  Which files already existed in online project and therefore were just updated
The publish report does not hold this information.
I would be very happy, if anyone had a similar issue and has a ready to use SQL statement to share.

Best regards and have a nice evening

Kai

_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
https://lists.opencms.org/mailman/listinfo/opencms-dev