Petter Klang
Apr 12, 2011
  4848
(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
Optimizely SendGrid SMTP host is deprecated

SendGrid is a services for sending email that is included in Optimizely DXP. Previously smtp.episerver.net was the recommended SMTP server to use,...

Tomas Hensrud Gulla | Dec 4, 2022 | Syndicated blog

Hosting Optimizely CMS 12 on Docker Engine

Since Optimizely CMS can now be deployed as a Docker container, here is a demonstration of building, running and scaling an Optimizely CMS 12 site ...

Stefan Holm Olsen | Dec 4, 2022 | Syndicated blog

How to use CacheTagHelper with content areas in Optimizely CMS 12

I might be going out on a limb here - if you have a better solution, feel very free to share it!  Upgrading your Optimizely web application from .N...

Andreas J | Dec 2, 2022

The 1001st Piece in your 1000 Piece Puzzle: .NET Default Interface Functions

I was recently working with a client who wanted a reasonably large subsystem added to Optimizely that would add automated management to their...

Greg J | Nov 28, 2022 | Syndicated blog