System Event Types

mwalders — Tue, 16 Oct 2007 07:59:59 GMT

Is there a searchable spreadsheet for sytem event types. When setting up auto event handling it can be hard to find the event I am looking for buried in several dropdown boxes.

Re: System Event Types

Rob Buxton — Tue, 16 Oct 2007 14:49:22 GMT

That would be nice!
It'll be in the database but I've never gone looking for it.

Re: System Event Types

David Claypool — Tue, 16 Oct 2007 15:13:07 GMT

Completely unsupported, but here's some SQL for your fun and education. Requires HP SIM 5.1 at minimum for database compatibility. Please note that I have not personally tried it.

drop view noticeDesc

create view noticeDesc as (

select typeIdStr, N'Severity' = CASE WHEN defaultSeverity = 100 THEN N'Informational' WHEN defaultSeverity = 1 THEN N'Normal' WHEN defaultSeverity = 2 THEN N'Warning'

WHEN defaultSeverity = 3 THEN N'Minor' WHEN defaultSeverity = 4 THEN N'Major' WHEN defaultSeverity = 5 THEN N'Critical' ELSE CONVERT(char(10),

defaultSeverity) END,

category, largeValue as description from noticeType, stringresource, stringtablelarge

WHERE stringresource.resourceclassname = N'Alerttype' AND

stringresource.subclass = N'description' AND noticeType.typeIdStr = stringresource.resourceName AND

stringtablelarge.id = stringresource.id)

drop view noticeCorr

create view noticeCorr as (

select typeIdStr, largeValue as correction from noticeType, stringresource, stringtablelarge

WHERE stringresource.resourceclassname = N'Alerttype' AND

stringresource.subclass = N'correctiveAction' AND noticeType.typeIdStr = stringresource.resourceName AND

stringtablelarge.id = stringresource.id)

drop view noticemsgFmt

create view noticemsgFmt as (

select typeIdStr, largeValue as messageFormat from noticeType, stringresource, stringtablelarge

WHERE stringresource.resourceclassname = N'Alerttype' AND

stringresource.subclass = N'msgFormatString' AND noticeType.typeIdStr = stringresource.resourceName AND

stringtablelarge.id = stringresource.id)

select noticeDesc.typeIdStr, Severity, category, description, noticemsgFmt.messageFormat, noticeCorr.correction from noticeDesc

left outer join noticemsgFmt on noticemsgFmt.typeIdStr = noticeDesc.typeIdStr

left outer join noticeCorr on noticeCorr.typeIdStr = noticeDesc.typeIdStr

topic Re: System Event Types in Server Management - Systems Insight Manager

System Event Types

Re: System Event Types

Re: System Event Types