Comments field is a great feature.
Currently if the text length exceeds a certain length, it overlaps the Added By field.
I've been using that field as a ToDo feature and printing the page.
It would nice, if not for printing, but for readability, to have the Comment field wrap in the Web Interface.
Also a built in way to run a report on Comments of a given PC. I've found a way to run a report for Asset Comments (tblAssetsComments), but can't find the table with PC Comments to create my own for PC Comments.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssetComments.CommentID,
tblAssetComments.Comment,
tblAssetComments.AddedBy,
tblAssetComments.Added
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetComments On tblAssets.AssetID = tblAssetComments.AssetID
Where tblAssetCustom.State = 1