As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
<Service name="FileFolderService" mode="none"> <Method name="rename" mode="all"/> <Method name="move" mode="all"/> <Method name="copy" mode="all" auditInternal="true"/> <Method name="create" mode="all"/> <Method name="delete" mode="all"/> <Method name="makeFolders" mode="all"/> <Method name="getWriter" mode="all"/> <Method name="getReader" mode="all"/> </Service> <Service name="ContentService" mode="none"> <Method name="getWriter" mode="all"/> <Method name="transform" mode="all"/> <Method name="getReader" mode="all"/> </Service>
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 = 'ContentService' and source.method = 'getReader') or (source.service = 'FileFolderService' and source.method = 'getReader') ) join alf_node_status ns on ns.guid = fact.node_uuid join alf_node_properties prop on ns.node_id = prop.node_id