Petter Klang
Apr 12, 2011
  5200
(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 ;)

Atul Kumar
Atul Kumar Jan 12, 2012 07:48 AM

Thanks for this .. Nice!

Feb 4, 2014 02:30 PM

Thanks!

Please login to comment.
Latest blogs
Configured Commerce - Introduction to Long-Term Support (LTS) Releases

First off, for those who have not had a chance to meet me yet, my name is John McCarroll, and I am the Technical Product Manager for the Optimizely...

John McCarroll | Sep 29, 2023

Auto-translate with OpenAI in Optimizely CMS

You can now auto-translate content using your favorite online AI service, inside the old trustworthy Episerver.Labs.LanguageManager!

Tomas Hensrud Gulla | Sep 29, 2023 | Syndicated blog

Vulnerability in CMS 12 shell module configuration

Introduction A potential security vulnerability has been identified in Optimizely CMS 12, triggered by a certain shell module configuration. To be...

Magnus Rahl | Sep 28, 2023

AI-Assistant: The 'Change Tone' Shortcut

The AI-Assistant for Optimizely is constantly evolving, adjusting, and transforming to meet your digital needs, providing a cutting-edge advantage...

Luc Gosso (MVP) | Sep 27, 2023 | Syndicated blog