select fact.timestamp, convert(prop.string_value using utf8)
from alf_audit_fact fact
join alf_audit_source source
on fact.audit_source_id = source.id
and (
(source.service = 'NodeService' and source.method = 'deleteNode')
or (source.service = 'FileFolderService' and source.method = 'delete')
)
join alf_node_status ns on ns.guid = fact.node_uuid
join alf_node_properties prop
on ns.node_id = prop.node_id
and prop.qname = '{http://www.alfresco.org/model/content/1.0}name'
Content from pre 2016 and from language groups that have been closed.
Content is read-only.
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.