Forum Discussion

Will_Moulic1's avatar
Will_Moulic1
Level 3
7 years ago

Need help with SQL queries to get EV FSA ArchiveNames and its corresponding FileServer or VolumeName

Hello Experts, Need help on the above subject. Is that possible? Thanks.
  • ChrisLangevin's avatar
    ChrisLangevin
    7 years ago

    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

Marianne's avatar
Marianne
Level 6
7 years ago

Will_Moulic1

I have moved your post from 'General Veritas' to EV forum.