Forum Discussion
3 Replies
Sort By
- MarianneLevel 6
I have moved your post from 'General Veritas' to EV forum.
- ChrisLangevinLevel 6
Does this suit you?
SELECT av.ArchiveName ,fsve.VolumeName ,fse.DnsName AS FileServerFQDN ,fse.UncName AS FileServerNETBIOSName FROM ArchiveView AS av JOIN FileServerVolumeArchiveEntry AS fsvae ON fsvae.ArchiveVEID = av.VaultEntryId JOIN FileServerVolumeEntry AS fsve ON fsve.VolumeEntryId = fsvae.VolumeEntryId JOIN FileServerEntry AS fse ON fse.FileServerEntryId = fsve.FileServerEntryId WHERE Type = 129 --Type 129 = FileSystem Archives only
Example results from lab:
--Chris
- Will_Moulic1Level 3
Hi Chris,
This worked! Thank you so much! Much appreciated.
Related Content
- 5 years ago
- 11 years ago
- 11 years ago
- 15 years ago