topic ALL Events in Server Management - Systems Insight Manager

ALL Events

HJAKOBI — Fri, 26 Aug 2005 04:12:48 GMT

Hi,

where are all these events stored ?

I need a select statement to get these data or the tablename where to find these data.

Kind regards.

Henry

Re: ALL Events

Aravindh Rajaram — Mon, 29 Aug 2005 11:13:24 GMT

You can query it from the view named "notices_view".

Re: ALL Events

NJK-Work — Tue, 30 Aug 2005 10:55:59 GMT

That view fails for me - using both SQL Query Analyzer or connecting with an Access ADP front end.

Does it bomb out for other people as well?

Nelson

Re: ALL Events

HJAKOBI — Thu, 01 Sep 2005 04:26:26 GMT

i have found the error:

CREATE VIEW notices_view AS ( select distinct devices.Name as 'Device Name', 'Severity' = case when noticeSeverity=100 then 'Informational' when noticeSeverity = 1 then 'Normal' when noticeSeverity=2 then 'Warning' when noticeSeverity=3 then 'Minor' when noticeSeverity=4 then 'Major' when noticeSeverity=5 then 'Critical' else convert(char(10), noticeSeverity) end, 'state' = case when state=1 then 'Discovered' when state=2 then 'Not Cleared' when state = 5 then 'Cleared' when state = 6 then 'IN Progress' end, generated, cleared, largeValue as Description from notices, noticeType, devices, stringresource, stringtablelarge where notices.noticeType = noticeType.noticeType and notices.deviceKey = devices.deviceKey and stringresource.resourceclassname='Alerttype' and stringresource.subclass='description' and noticeType.typeidstr=stringresource.resourcename and stringtablelarge.id = stringresource.id and stringtablelarge.language='en' )

this view is working now