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:
Discussion Filed Under:
Comments 1 Comment • Jump to latest comment
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
Would you like to reply?
Login or Register to post your comment.