How to find actual file name

[asahublr]

Hi All,

   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 & MIME type in the table "alf_node_properties" in attribute String_Value as below:

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_
{http://www.alfresco.org/model/content/1.0}content

   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.

select docid.string_value, url.content_url
from
alf_node_properties np
inner join alf_content_data acd on np.long_value = acd.id
inner join alf_content_url url on acd.content_url_id=url.id
INNER JOIN alf_node_properties docid on docid.node_id=np.node_id
where
np.actual_type_n = 3 and np.persisted_type_n = 3 and docid.string_value='509a52de-8606-40dc-93a9-b770bc9db62c'

  Please help to find out the details.

Thanks,
Ashok

[mrogers]

As I said in another thread.   Your best bet will be to get Alfresco up and running again rather than trying to access data directly.  

What do you mean by "alfresco is corrupted"?  You seem to have a content store and a matching database, that's all that matters.

[samsam]

Hi,

I wanted to know where exactly the filename and metadata gets stored in the alfresco database.

[lambert]

I'm +1 who is interested in it… I have checked all known to me ways, but I can't find it..