Try our conversational search powered by Generative AI!

Petter Klang
Apr 12, 2011
  5320
(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
Fix your Search & Navigation (Find) indexing job, please

Once upon a time, a colleague asked me to look into a customer database with weird spikes in database log usage. (You might start to wonder why I a...

Quan Mai | Apr 17, 2024 | Syndicated blog

The A/A Test: What You Need to Know

Sure, we all know what an A/B test can do. But what is an A/A test? How is it different? With an A/B test, we know that we can take a webpage (our...

Lindsey Rogers | Apr 15, 2024

.Net Core Timezone ID's Windows vs Linux

Hey all, First post here and I would like to talk about Timezone ID's and How Windows and Linux systems use different IDs. We currently run a .NET...

sheider | Apr 15, 2024

What's new in Language Manager 5.3.0

In Language Manager (LM) version 5.2.0, we added an option in appsettings.json called TranslateOrCopyContentAreaChildrenBlockForTypes . It does...

Quoc Anh Nguyen | Apr 15, 2024