Delete one server logs

[eXPlosion]

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 = '192.168.4.5' 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 = '192.168.4.5' AND tblAssets.eventtype = 'error'

[FrankSc]

Hello,

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.