![arupert arupert](https://community.lansweeper.com/html/assets/User_Avatar.png)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-07-2018 07:25 PM
Occasionally we have to trackdown computers that have been renamed, but only have the old computer name to search from(do not know the new name). Lansweeper will nicely add a comment that the computer was renamed etc.. Unfortunately search results for the old computer name do not return the new asset name. I'm guessing this is not possible? If not, does anyone know the table and field where the comments data is stored? May be able to query it..
thanks
thanks
Labels:
- Labels:
-
General Discussion
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-08-2018 12:09 AM
According to the database documentation (View Database Documentation on the report editor), you want to link in tblAssetComments. The field tblAssetComments.Comment contains the "Renamed xxx to yyy" comments. If you add
WHEREto your report, you should find what you're looking for. Or it's something you need once-in-a-while, don't bother with the WHERE condition and just type the old machine name in the tblAssetComments.Comment filter box at the top of the report column.
tblAssetComments.Comment LIKE '%oldname%'
![](/skins/images/0DB7630AB1C6BBE7D93A05B2832E6E89/responsive_peak/images/icon_anonymous_message.png)