08-16-2017 06:14 PM
08-21-2017 08:26 AM
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
08-21-2017 07:33 AM
08-21-2017 08:26 AM
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
08-21-2017 09:53 PM
Hi Chris,
This worked! Thank you so much! Much appreciated.