Query Events HPSIM

Jose Antonio_5 — Mon, 24 Jan 2005 11:57:41 GMT

Hi,
I need to obtain the HPSIM events.
I have relationated those tables: "notices", "noticeType", and "device", but I need to know the "Description" field. I think this field is in "stringResource" with "stringTableLarge", but I don´t know how to obtain this field.
Do you know how to do it???

Thanks in advance,

Jose

Re: Query Events HPSIM

Jose Antonio_5 — Tue, 25 Jan 2005 07:30:31 GMT

Hi,

I have made this query (what do you think about it???)

select notices.NoticeId, notices.NoticeSeverity, notices.Generated, devices.FullDNSName, devices.Name, devices.ProductName, devices.ProductSubType, devices.ProductTypeStr, notices.AssignedTo, notices.Comments, noticeType.TypeIdStr, noticeType.Category, noticeType.DispHandler, stringTableLarge.largeValue
from notices, noticeType, devices, stringResource, stringTableLarge
where ((notices.DeviceKey = devices.Devicekey)
and (notices.NoticeType = noticeType.NoticeType)
and (notices.NoticeSeverity<>100)
and (notices.State=2)
and (stringTableLarge.Language = 'en')
and stringResource.SubClass='description'
and cast(notices.NoticeType as varchar)=stringResource.ResourceName
and (stringTableLarge.id = stringResource.id))
order by generated ASC

topic Query Events HPSIM in Server Management - Systems Insight Manager

Query Events HPSIM

Re: Query Events HPSIM