11 Jun 2009
18 Oct 2012
Link to this post
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