Petter Klang
Apr 12, 2011
  5600
(4 votes)

Finding your Versioned files on disk

When you add a file in EPiServer using the versioning provider you will find that the file is named to a Guid in Windows file system. So finding a particular file could be troublesome.

One way of getting the connection between file name and Guid that I find myself using a lot when troubleshooting is the use of these SPs.

select pkID from tblItem where Name like 'filename'

Then use that (those) pkID in this one:

exec RelationListFrom @FromId=N'pkID',@SchemaId=0

The Guid you receive is the name the file will have on disk. If you get more than one Guid then you have more than one version of the file.

If you wish to go the other way around. From filename on disk to pkID in tblItem. Run this:

exec RelationListTo @ToId=N'GuidOnFileName',@SchemaId=0

 

Thanks for Greger for giving me the first part and to Shahid for answering the same question over and over (I should be able to look it up myself from now on =) )

Apr 12, 2011

Comments

Apr 12, 2011 01:56 PM

Good work Petter and keep it up ;)

Jan 12, 2012 07:48 AM

Thanks for this .. Nice!

Feb 4, 2014 02:30 PM

Thanks!

Please login to comment.
Latest blogs
UrlResolver Bug in Optimizely DXP: Troubleshooting Inconsistent URLs in Scaled-Out Apps

A while back, our team encountered a puzzling production bug: URLs generated by the UrlResolver would randomly differ depending on who accessed the...

David Drouin-Prince | Jun 18, 2025 |

Optimizely Commerce Connect: Enabling content-driven ecommerce experiences

The world of ecommerce today is a rapidly evolving field. No longer are customers satisfied with a long list of products that they have no idea how...

Shahrukh Ikhtear | Jun 16, 2025

Create a multi-site aware custom search provider using Search & Navigation

In a multisite setup using Optimizely CMS, searching for pages can be confusing. The default CMS search regardless of search provider does not...

dada | Jun 12, 2025

Tunning Application Insights telemetry filtering in Optimizely

Application Insights is a cloud-based service designed to monitor web applications, providing insights into performance, errors, and user behavior,...

Stanisław Szołkowski | Jun 12, 2025 |

JavaScript SDK v6: Lightest, Most Efficient SDK Yet

Need a faster site and less frontend bloat? JavaScript SDK v6 is here —and it’s the lightest, smartest SDK we’ve ever released for Optimizely Featu...

Sarah Ager | Jun 11, 2025

Boosting Indexing Efficiency: Reindex Pages Directly from Optimizely’s Navigation Pane

There can be various reasons why you might want to trigger indexing or reindexing of a page/node directly from the navigation pane. In my case, we...

Praful Jangid | Jun 11, 2025