Query Events HPSIM

[Jose Antonio_5]

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

[Jose Antonio_5]

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