+1-888-365-2779
Try Now
More in this section

Forums / General Discussions / Sitefinity FileName

Sitefinity FileName

2 posts, 0 answered
  1. Paolo
    Paolo avatar
    147 posts
    Registered:
    11 Jun 2009
    18 Oct 2012
    Link to this post
    Hello,
    our customer have an enterprise license of sitefinity 4.1 (don't know if they've updated it) I need to integrate with our services on which file has been showed most joining with IIS logs...

    I'm able to match the major part of the files since I access to

    SELECT TOP 1000*
      FROM [xxx].[dbo].[sf_url_data] a
      left join xxx.dbo.sf_media_content b on  a.content_id = b.content_id
      where url like '%filenameE7EADA3571C331650%'

    but for some files I can't...when a file is deleted it's also removed here or just flagged as deleted?
    Why some filename are correct and other are as long as

    file8AE2C8C758E08452A18F3C2B91DBEF8938CA18E752FD0F7C81EEA8B8C233D786378C355D3F7944A3460FF2C207C418168777E154637FB84E8149B1F011F1E147D8009666E6A117B8E66E548A2ABC9A97A7314800DFA46B1AE4B10BC012BC6EE168F37C4ADDE97F345C8422DCDB2A06E7262E.pdf?

    Thanks
    Paolo
  2. Paolo
    Paolo avatar
    147 posts
    Registered:
    11 Jun 2009
    29 Oct 2012
    Link to this post
    anyone on this?
2 posts, 0 answered