Windows Shares and Their Share Permissions

Find Windows Shared Folders and Permissions in Your Network

List all the configured share folders including the share permissions set on each folder with the report below. Find the shared folders in your environment as well as their complete permission set. Don’t be left in the dark and get complete visibility of all the shared folders in your network.

Windows Shares and Their Share Permissions Query

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tblAssets.Description,
  tsysOS.OSname,
  tblSharesUni.Name,
  tblSharesUni.Path,
  tsysOS.Image As icon,
  tblSharePermissions.trustee As [for user/group],
  tblADusers.Username,
  tblADusers.Userdomain,
  tblADusers.Displayname,
  tblADusers.Department,
  tblADusers.Title,
  tblADObjects.sAMAccountName As Manager,
  Case When tblSharePermissions.readAccess = 1 Then 'y' Else 'n' End As [Read],
  Case When tblSharePermissions.writeAccess = 1 Then 'y' Else 'n' End As Write,
  Case When tblSharePermissions.fullAccess = 1 Then 'y' Else 'n' End As [Full],
  Case When tblSharePermissions.denyAccess = 1 Then 'y' Else 'n' End As Denied,
  tblShares.Lastchanged
From tblShares
  Inner Join tblAssets On tblShares.AssetID = tblAssets.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tblSharesUni On tblShares.ShareUniqueID =
    tblSharesUni.ShareUniqueID
  Inner Join tblSharePermissions
    On tblShares.ShareID = tblSharePermissions.ShareID
  Left Join tblADusers On tblADusers.Userdomain + '\' + tblADusers.Username =
    tblSharePermissions.trustee
  Left Join tblADObjects On tblADObjects.ADObjectID =
    tblADusers.ManagerADObjectId
Where tblAssetCustom.State = 1 And tblSharesUni.Type = 0
Order By tblAssets.AssetName

Show

Hide