All files in a PDMWorks Enterprise file vault have their own file archive folder that is managed by the
archive server. Inside each archive folder, all versions of a file are stored. The files are not stored using
the same folder structure as seen by a user in a file vault view, but instead uses hexadecimal ID names
that are maintained in the file vault database.
My question is, in which DB table the hexadecimal ID name is avilable?
To expand on what Wayne explained:
DECLARE @VaultName NVARCHAR(256) SELECT @VaultName = VaultName FROM dbo.SystemInfo ; WITH Docs ( DocumentID, Filename, HexID ) AS ( SELECT DocumentID , Filename , dbo.fnHexNumber(DocumentID, 8, 1) AS HexId FROM Documents ) SELECT Docs.DocumentID , Docs.Filename , @VaultName + '\' + RIGHT(Docs.HexID, 1) + '\' + Docs.HexID AS ArchivePath FROM Docs ORDER BY ArchivePath
dbo.fnHexNumber() is a function already in the vault databases. It converts an integer to hex.
Lee,
The stored procedures are all locked when ever I create a vault. How can I unlock them and see what they do. I've had to write my own procedures that probably all ready exists but I can't see them an the names are some what confusing. Also would there be any documentation to say what eacj stored procedures does?
Thanks
Frank
Anand -
The answer is no.
Regards,
Joy