topic Re: Create a collection or report based on a hardware failure? in Server Management - Systems Insight Manager

Create a collection or report based on a hardware failure?

Dana Swanson — Wed, 30 Jan 2008 17:28:48 GMT

Hi Everyone,

Would there be a way to create a collection, report or query using the command line mx tools to list current known hardware failures? For example a server with a bad hard drive?

I'm looking to send repeat email alerts on these issues via a vbscript if possible.

I took a look and can't see a way to do this besides based on a event which would not work out very easily in a vbscript at my knowledge since I'll have to check another event for when it was fixed.

I have been able to send multiple alerts based on critical servers in a collection but would like to warn every so many hours on failed hardware.

Has anyone been able to query the SQL database for this type of information from vbscript or wsh?

Thanks!

Dana

Re: Create a collection or report based on a hardware failure?

David Claypool — Wed, 30 Jan 2008 19:02:46 GMT

If you have a good discipline about marking events cleared when the issue is corrected, the easiest way would be to run a report on all the non-informational, uncleared events. You could use 'mxreport' to run it and dump it to a file and then email the file to one or more people at some frequency. Further, you could use the 'Assign to:' field to identify that someone is actively working an issue to resolution to flag it in process before it's cleared.

Re: Create a collection or report based on a hardware failure?

Dana Swanson — Thu, 31 Jan 2008 15:02:45 GMT

Thanks Dave,

If I limit the event types to only a few critical issues the emails can state if the problem has been resolved to clear the event in hpsim as reminder.

I'll give this a try.

Thanks again,

Dana