cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Daniel_B
Lansweeper Alumni
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
18 REPLIES 18
RCorbeil
Honored Sweeper II
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
Engaged Sweeper
Morning

any variations of this reporting NTFS permissions?

( I cant see a table with anything link ntfs in)
jlennon101
Engaged Sweeper
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
Engaged Sweeper II
Is it posible for this report to only show computer with server OS?
Jeremy_D
Champion Sweeper
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
Engaged Sweeper
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
Lansweeper Alumni
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
Engaged Sweeper
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
Lansweeper Alumni
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.