03-05-2013 07:58 AM
Hi,
I have written this SQL query to display UNC Name, Volume Name and Policy associated with the volume.
Solved! Go to Solution.
03-05-2013 08:40 AM
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
03-05-2013 08:40 AM
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