Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

SQL Query Help to display all Volume and Folder Policy in FSA

Created: 05 Mar 2013 • Updated: 05 Mar 2013 | 1 comment
This issue has been solved. See solution.

Hi,

I have written this SQL query to display UNC Name, Volume Name and Policy associated with the volume.

select FileServerEntry.UncName, FileServerVolumeEntry.VolumeName, dbo.PolicyEntry.poName
from PolicyEntry
inner join VolumePolicyEntry
on PolicyEntry.poPolicyEntryId=VolumePolicyEntry.poPolicyEntryId
inner join FileServerVolumeEntry
on FileServerVolumeEntry.VolumePolicyEntryId=VolumePolicyEntry.VolumePolicyEntryId
inner join FileServerEntry
on FileServerEntry.FileServerEntryId=FileServerVolumeEntry.FileServerEntryId
order by FileServerEntry.UncName ASC
 
Can anyone please help to modify this to include Folder Path and Policy applied to a Folder as well for all Target File server?
 
 
Many Thanks
Operating Systems:

Comments 1 CommentJump to latest comment

ia01's picture

select FileServerEntry.UncName, FileServerVolumeEntry.VolumeName, FolderPath, PolicyEntry.poName

 from FileServerFolderEntry

 inner join FileServerVolumeEntry

 on FileServerFolderEntry.VolumeEntryId=FileServerVolumeEntry.VolumeEntryId

 inner join FileServerEntry

 on FileServerEntry.FileServerEntryId=FileServerVolumeEntry.FileServerEntryId

 inner join FolderPolicyEntry

 on FileServerFolderEntry.FolderPolicyEntryId=FolderPolicyEntry.FolderPolicyEntryId

 inner join PolicyEntry

 on PolicyEntry.poPolicyEntryId=FolderPolicyEntry.poPolicyEntryId

 where FileServerFolderEntry.FolderPolicyEntryId is not NULL

 order by FileServerEntry.UncName ASC

select FileServerEntry.UncName, FileServerVolumeEntry.VolumeName, FileServerFolderEntry.FolderPath, dbo.PolicyEntry.poName

from PolicyEntry

inner join VolumePolicyEntry

on PolicyEntry.poPolicyEntryId=VolumePolicyEntry.poPolicyEntryId

inner join FileServerVolumeEntry

on FileServerVolumeEntry.VolumePolicyEntryId=VolumePolicyEntry.VolumePolicyEntryId

inner join FileServerEntry

on FileServerEntry.FileServerEntryId=FileServerVolumeEntry.FileServerEntryId

inner join FileServerFolderEntry

on FileServerFolderEntry.VolumeEntryID=FileServerVolumeEntry.VolumeEntryID

order by FileServerEntry.UncName ASC

SOLUTION