How to clear history of one trigger....

[mafa]

How to clear history of one trigger....

I created one trigger and tested it several times, before switch to production I would like to clear all historical data for this trigger (I would like to have a clear Availability report) before start production monitoring – how to do it?

[madutis]

Same question here.

Thanks.

[untergeek]

Even if this is a complicated SQL query I have to run manually, I'd like to know a way to do this also.

[madutis]

I have found a way to do this in SQL.

DISCLAIMER: Use at your own risk, these are just guidelines, you will have to adjust values for your situation.

Basically you need to erase all rows from service_alarms with serviceid that you need.

You can look up serviceid's in table 'services'.

delete from service_alarms where serviceid=2 and servicealarmid > 10;

I have added 'servicealarmid > 10' as top rows contain '0' values for each service apparently for a calculation to be correct.

Do this for a service and every parent IT service.

Hope this helps,
Darius