cancel
Showing results for 
Search instead for 
Did you mean: 

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

Will_Moulic1
Level 3

Hello Experts,

Need help on the above subject. Is that possible? Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions

ChrisLangevin
Level 6
Employee

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:

 Capture.JPG

 

--Chris

View solution in original post

3 REPLIES 3

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@Will_Moulic1

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

ChrisLangevin
Level 6
Employee

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:

 Capture.JPG

 

--Chris

Hi Chris,

This worked! Thank you so much! Much appreciated.