I'm having an issue trying to correlate the blob GUID of a newly uploaded image in media panel with the url of the uploaded image. I didn't find anything so far. Do you think you can help me? Is there some table in the DB maybe where I can find the connection between the two? I mean, I'm uploading an image under media panel and I get a new folder under App_Data/blobs. What's the connection between that GUID (of the folder or of the file) and the url/filename from EPI?
Please advise. Thanks in advance.
Question what comes in my mind - is what do you want to do with that information? Do you want to use it somehow in the site?
This should give you full overview of images saved in blob:
SELECT * FROM [dbo].[tblContent] c inner join tblContentProperty p on c.pkID = p.fkContentID inner join [dbo].[tblContentLanguage] cl on c.pkID = cl.fkContentID
where c.fkContentTypeID in (select pkid from [dbo].[tblContentType] where name = 'NAME OF YOUR CONTENT TYPE FOR IMAGE')
A media item has a reference to its blob in column BlobUri in tblContentLanguage. The reference is in format of an Uri where the segments of the URI describes how to locate the blob.