I am looking for a way to generate a monthly report of alerts on a per host basis. The alerts will need to be seperated into type (ie: cpu, etc.). I have iReport, but i am just learning the database schema and trying to figure out iReport. Does anyone know how to pull this data or can you provide an SQL statement that I can use at the DB level to get this info?
Thanks!
Craig
Thanks!
Craig