Custom fileds comments search

[Dov]

Would love to see the search function pull up / search information in the custom field's comments section; we use the comments extensively and would love to have the ability to search all devices for certain words typed in the comments.

[Susan_A]

FYI: you can filter pjbate's report within the report results to perform a "search".

[pjbate · Accepted solution]

HI, I worked on this report SQL to list all comments that have not been added by the Lansweeper service.

Enjoy

Peter

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssetComments.Comment,
tblAssetComments.AddedBy,
tblAssetComments.Added
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Right Join tblAssetComments On tblAssetComments.AssetID = tblAssets.AssetID
Where tblAssetComments.AddedBy <> 'Lansweeper'

[Hemoco]

This is not currently on our to do list. The custom fields themselves are searchable though.