ALL Events

[HJAKOBI]

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

[Aravindh Rajaram]

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

[NJK-Work]

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

[HJAKOBI]

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