Shares on Windows computers and their share permissions

[Daniel_B]

List of all configured Share folders, including the share permissions set on each folder


Meets all the following criteria:
- Active Asset
- Windows Asset
- Network Share folders configured

Sorted on:
- Asset name

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],
  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
Where tblAssetCustom.State = 1 And tblSharesUni.Type = 0
Order By tblAssets.AssetName

[RCorbeil]

Recording/reporting NTFS permissions is out of scope for LANSweeper. See here for examples. (Not an endorsement, just one of many Google results.)

[simon_wilks]

Morning

any variations of this reporting NTFS permissions?

( I cant see a table with anything link ntfs in)

[jlennon101]

Hi I tried using the script at the top of this post but I always get the following error:


Invalid SELECT statement. Unexpected token "When" at line 10, pos 8.: Unexpected token "When" at line 10, column 8


Just for arguments sake the script is:


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],
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
Where tblAssetCustom.State = 1 And tblSharesUni.Type = 0
Order By tblAssets.AssetName

[Reen87]

Is it posible for this report to only show computer with server OS?

[Jeremy_D]

Reen87 wrote:
Is it posible for this report to only show computer with server OS?

You can limit any report, including the one in this forum topic, to servers by following the instructions in this thread.

[echernov]

thanks.
sorry maybe I was not clear .
the report is scanning all assets for the network shares.
the report is working just fine .
how I specify specific asset with specific share name ?
I need to scan one server(one asset ) and all shares that in that server.

I hope I was clear.

thanks

Ed

[Susan_A]

echernov wrote:
how I specify specific asset with specific share name ?
I need to scan one server(one asset ) and all shares that in that server.

You can filter the Assetname column within the report results to only list shares on a specific computer. There are search boxes in the report output, at the top of every column.

[echernov]

Hi All,

can you please explain if I can run this report and how on the network share ?

example: I have network share \\domain\department with many subfolders .
I need to know who has an access to the \\domain\department\xxxxx folder ?

can I use this report ?

thanks

[Susan_A]

echernov wrote:
can you please explain if I can run this report and how on the network share ?

example: I have network share \\domain\department with many subfolders .
I need to know who has an access to the \\domain\department\xxxxx folder ?

can I use this report ?

Lansweeper only scans share permissions, not folder permissions. Reporting on folder permissions is not currently possible. This feature is on our customer wish list, but we do not have a release date for it at this time.