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