Hello everybody.
I made a migration from version 1.6.x to 1.8.6. After that I disabled all items that had the status "not supported".
But now I have the problem that I have more than 200 triggers which are in status "unknown" and I want to find out which triggers these are.
If I try a "select count(*) from triggers", I get much more than the Dashboard shows.
Does anyone of you know how to write a sql query which shows these triggers with the responsible item and host?
many thanks!
regards
I made a migration from version 1.6.x to 1.8.6. After that I disabled all items that had the status "not supported".
But now I have the problem that I have more than 200 triggers which are in status "unknown" and I want to find out which triggers these are.
If I try a "select count(*) from triggers", I get much more than the Dashboard shows.
Does anyone of you know how to write a sql query which shows these triggers with the responsible item and host?
many thanks!
regards