→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎01-05-2015 06:33 PM
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
‎03-02-2021 04:51 PM
‎03-02-2021 10:02 AM
‎10-10-2016 06:43 PM
‎02-02-2016 12:41 PM
‎02-04-2016 02:16 PM
Reen87 wrote:
Is it posible for this report to only show computer with server OS?
‎01-22-2016 03:41 PM
‎01-30-2016 04:10 PM
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.
‎01-21-2016 08:58 PM
‎01-22-2016 12:12 PM
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 ?
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now