Way to see who deleted a Community file?

HCL Connections Connections Forum
,
1

Hi,

is there a convenient way to see who deleted a file from a Community?

I searched the database, but there is no ID recoreded in the FILES.MEDIA_DELETED table.

Also I didn't see anything related in the the logs.

Any help is appreciated.

Thanks

Florian

2

If you want to know who moved the file to the trash, you should have a look at your database table METRICS.f_trx_events. There you will find all events that are recorded for the Metrics application and you should find an entry with event_name "files.file.deleted" and the corresponding user id. If your Connections runs Metrics on component pack + Elastic instead of WebSphere, then you should look at the data stored in Elastic. The data fileds are similar.

If you want to know who emptied the trash, it gets more complicated. Unfortunately, Metrics does not record that the trash has been emptied. But in this case the service provider interfaces (SPI) will be your friend for the future. The SPI throws an event called "files.trash.emptied" and provides the user id when the trash is emptied. But as far as I know, there is no default application or service that stores the events from SPI, so you have to do it on your own. And as past events are gone, I don't know if this will be helpful in your case.

3

Hi Julian,

thank you for your answer.

That was already helpful. I kind of forgot the Metrics since they run in Component Pack.

Any pointers for working with ElasticSearch?

In ComponentPack 7 there seems to be no easy way to work with Kibana...

Greetings

Florian

4

Hi Florian,


The FILES.MEDIA table captures who moves a file to the trash and when via the TRASHED_BY and TRASHED_AT entries. The TRASHED_BY ID corresponds to the ID stored in the FILES.USER table.


Thanks,

Michael Montani
HCL Support

5

Hi Michael,

didn't know that.

That's exactly what I searched for!

Thank you

Florian Stahl