→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Tczadzeck
Engaged Sweeper II
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]
1 REPLY 1
JacobH
Champion Sweeper III
try adding

Where Not (tblSharesUni.Name Like N'%$')

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now