→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper
We have a server named SERVER2 and we are getting critical (error) reports about it. Is there a way to delete it from database (just those reports for particular server.) (Dashboard->Server->server errors->eventtype->error)

Delete FROM tblAssets
WHERE tblAssets.IPAddress = '' AND tblAssets.eventtype = 'error'

eventtype is not recognized in SQL query, but something like that. This query will remove asset from inventory I believe, but we need to delete just error information. But since we need to remove just events from DB, maybe query will be similar to

Delete FROM tblAssets.events
WHERE tblAssets.IPAddress = '' AND tblAssets.eventtype = 'error'
Lansweeper Tech Support
Lansweeper Tech Support

Events are stored in tblNtlog. Based upon the AssetID and then the event message that you can find in tblNtlogMessage, you should delete the message in tblNtlog.

You can also consult the database documentation that you can find under the Reports section.