Implementing an alert dashboard

[Split71]

So i'm trying to setup an alert system in which i can display alerts on a quick to read dashboard built within a custom CMDB. Now i'm trying to gather hardware only alerts per each server. Is it possible to pull this information from the Insight database?

Lets say from this table:

dbo.notices

or these views:

R_topHardwareEvents
R_EventSummary

I'm having a hard time finding how to pull that data out of HP SIM to in order to utilize a fully functional real time dashboard.

Im trying to pretty much get like servername and what has failed or is throwing an alert (HDD, memory, cpu, power supply, etc..)

[Darrin Rawls]

If you pull up SQL Console tools and look at the db, there are several 'views' that are created around inventory, events, etc. I would use those views to pull back data for your reports. That does the joins across tables, etc.

The schema is populated in the index of the online help file for SIM. Did you happen to look at that yet? If not, maybe look there, if so, then can you say what information is missing?

thanks.