Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

System Event Types

SOLVED
Go to solution
mwalders
Occasional Advisor

System Event Types

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.
2 REPLIES
Rob Buxton
Honored Contributor

Re: System Event Types

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

Re: System Event Types

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