Good Evening,
I am currently working with the below report, I am trying to fine tune the report as we have multiple "Print$" false/positives as well as trying to remove 'Brother' 'HP' 'RICOH' 'Epson' and other lines that are not needed. I am stumped quite frankly as I can't get rid of these to clean up the report.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain As Domain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tsysOS.OSname As [Operating System],
tblSharesUni.Name As [Share Name],
tblSharesUni.Path,
tblShares.Lastchanged,
tblSharePermissions.trustee As [Security Group or User],
tblSharePermissions.readAccess As [Read],
tblSharePermissions.writeAccess As Write,
tblSharePermissions.fullAccess As [Full],
tblSharePermissions.denyAccess As [Deny]
From tblShares
Inner Join tblAssets On tblShares.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblSharesUni On tblShares.ShareUniqueID =
tblSharesUni.ShareUniqueID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblstate On tblstate.State = tblAssetCustom.State
Inner Join tblSharePermissions On
tblShares.ShareID = tblSharePermissions.ShareID
Where (tsysOS.OSname Like 'Win 10' And tblSharesUni.Name Not Like N'%$' And
(Case
When tblSharesUni.Type = 0 Then 'Disk Drive'
Else 'Not a regular Disk Drive'
End) = 'Disk Drive') Or
(tsysOS.OSname Like 'Win 7')
Order By Domain,
tblAssets.AssetName,
[Share Name]
