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'