[opencms-dev] OpenCms 11: SQL-Statement to find state before publishing

[Schliemann, Kai]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opencms.org/pipermail/opencms-dev/attachments/20221206/f7cd8891/attachment.htm>