topic How to find actual file name in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-to-find-actual-file-name/m-p/263448#M216578 <HTML><HEAD></HEAD><BODY><SPAN>Hi All,</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp; I am new in Alfresco. I need to retrieve the actual document name and logical folder path(as it was showing in application) by querying in DB? I have physical file name for the document as "2d32a1de-6d01-11dc-881a-a183ccacc562.bin". I am able to fetch the physical content URL &amp; MIME type in the table "alf_node_properties" in attribute String_Value as below:</SPAN><BR /><BR /><SPAN>contentUrl=store://2007/9/27/9/54/2d32a1de-6d01-11dc-881a-a183ccacc562.bin|mimetype=application/vnd.excel|size=112640|encoding=UTF-8|locale=en_GB_</SPAN><BR /><SPAN>{</SPAN><A href="http://www.alfresco.org/model/content/1.0}content" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/content/1.0}content</A><BR /><BR /><SPAN>&nbsp;&nbsp; Our alfresco server is corrupted so not able to fetch it from application side. Can any one please let me know how to map the DB tables to get the required result? I got the following query in forum but I did not find the table "alf_content_data". Also the table "alf_content_url" does not contains any records. It seems we are using old version of Alfresco.</SPAN><BR /><BR /><EM>select docid.string_value, url.content_url<BR />from<BR />alf_node_properties np<BR />inner join alf_content_data acd on np.long_value = acd.id<BR />inner join alf_content_url url on acd.content_url_id=url.id<BR />INNER JOIN alf_node_properties docid on docid.node_id=np.node_id<BR />where<BR />np.actual_type_n = 3 and np.persisted_type_n = 3 and docid.string_value='509a52de-8606-40dc-93a9-b770bc9db62c'</EM><BR /><BR /><SPAN>&nbsp; Please help to find out the details. </SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Ashok</SPAN></BODY></HTML> Mon, 09 May 2011 19:00:00 GMT asahublr 2011-05-09T19:00:00Z How to find actual file name https://connect.hyland.com/t5/alfresco-archive/how-to-find-actual-file-name/m-p/263448#M216578 Hi All,&nbsp;&nbsp; I am new in Alfresco. I need to retrieve the actual document name and logical folder path(as it was showing in application) by querying in DB? I have physical file name for the document as "2d32a1de-6d01-11dc-881a-a183ccacc562.bin". I am able to fetch the physical content URL &amp; MIME ty Mon, 09 May 2011 19:00:00 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-find-actual-file-name/m-p/263448#M216578 asahublr 2011-05-09T19:00:00Z Re: How to find actual file name https://connect.hyland.com/t5/alfresco-archive/how-to-find-actual-file-name/m-p/263449#M216579 <HTML><HEAD></HEAD><BODY><SPAN>As I said in another thread.&nbsp;&nbsp; Your best bet will be to get Alfresco up and running again rather than trying to access data directly.&nbsp;&nbsp; </SPAN><BR /><BR /><SPAN>What do you mean by "alfresco is corrupted"?&nbsp; You seem to have a content store and a matching database, that's all that matters.</SPAN></BODY></HTML> Mon, 09 May 2011 19:26:53 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-find-actual-file-name/m-p/263449#M216579 mrogers 2011-05-09T19:26:53Z Re: How to find actual file name https://connect.hyland.com/t5/alfresco-archive/how-to-find-actual-file-name/m-p/263450#M216580 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I wanted to know where exactly the filename and metadata gets stored in the alfresco database.</SPAN></BODY></HTML> Fri, 07 Oct 2011 10:53:49 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-find-actual-file-name/m-p/263450#M216580 samsam 2011-10-07T10:53:49Z Re: How to find actual file name https://connect.hyland.com/t5/alfresco-archive/how-to-find-actual-file-name/m-p/263451#M216581 <HTML><HEAD></HEAD><BODY><SPAN>I'm +1 who is interested in it… I have checked all known to me ways, but I can't find it..</SPAN></BODY></HTML> Fri, 14 Oct 2011 07:02:38 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-find-actual-file-name/m-p/263451#M216581 lambert 2011-10-14T07:02:38Z