When working within a DXP environment it can be valuable to confirm if an asset exist within blob storage. Blob storage will typically use GUIDs for storing the assets, which can make it difficult to find a specific asset within a blob.
The following query can be used to find the GUID for an asset within an Episerver site. If the site in question is hosted in a DXP environment then a ticket can be submitted to one of our hosting teams to run the query against the site in question. Typically this would be the service desk team for non production sites and the incident management team for production sites.
select ContentGUID from tblContent where pkID in (
select fkContentID from tblworkcontent
where Name like '%helloworld.png%'