topic Re: Get Filename from .bin file in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/get-filename-from-bin-file/m-p/46341#M18486 <HTML><HEAD></HEAD><BODY><P>You can find the *.bin files referenced in the alf_content_url table. This table can be joined with alf_content_data, alf_node_properties and alf_node to find the node which referenced a specific *.bin file. For joining alf_content_data with alf_node_properties you need to join the content data ID on the long_value column for entries with actual_type_n = 21 (that constant stands for "content data with ID").</P></BODY></HTML> Fri, 30 Nov 2018 12:50:47 GMT afaust 2018-11-30T12:50:47Z Get Filename from .bin file https://connect.hyland.com/t5/alfresco-forum/get-filename-from-bin-file/m-p/46340#M18485 Hi there.For some reason we are unable to boot Alfredo but we have all the content (in bin format) and a dB backup.So the main idea is trying to recover the file properties from the DB knowing the bin name (file system).Could you suggest any query or any tool to do that? Thank you Fri, 30 Nov 2018 10:10:05 GMT https://connect.hyland.com/t5/alfresco-forum/get-filename-from-bin-file/m-p/46340#M18485 dozios 2018-11-30T10:10:05Z Re: Get Filename from .bin file https://connect.hyland.com/t5/alfresco-forum/get-filename-from-bin-file/m-p/46341#M18486 <HTML><HEAD></HEAD><BODY><P>You can find the *.bin files referenced in the alf_content_url table. This table can be joined with alf_content_data, alf_node_properties and alf_node to find the node which referenced a specific *.bin file. For joining alf_content_data with alf_node_properties you need to join the content data ID on the long_value column for entries with actual_type_n = 21 (that constant stands for "content data with ID").</P></BODY></HTML> Fri, 30 Nov 2018 12:50:47 GMT https://connect.hyland.com/t5/alfresco-forum/get-filename-from-bin-file/m-p/46341#M18486 afaust 2018-11-30T12:50:47Z