EV possible to check archive path of archive point through SQL?

[RASHIAN]

Hi,

I have an EV archivepoint but for some reason I have no idea about the archive volume or archive path information. Tried to guss by using ArchivePoints.exe find or read UNC path at command prompt but no luck. I have the ArchiveID through the Enterprise Vault Console. Is it possible to get this through SQL query?

Thanks

[JesusWept3 · Accepted solution]

Something like SELECT a.archivename "Archive Name", REPLACE(CAST(AF.Folderpath AS varchar(max)), '?', '\') "Folder Path" FROM Archive A, Root R, ArchiveFolder AF WHERE A.RootIdentity = AF.ContainerRootIdentity AND AF.RootIdentity = R.RootIdentity AND R.VaultEntryId = 'myArchiveID' Really though. Easiest thing to do is go to the VAC, hold ctrl+shift and right click Archives and select find archive or folder by ID and paste in the ID you have and hit search