Server Management - Systems Insight Manager
1829962 Members
2028 Online
109998 Solutions
New Discussion

Integrate SIM 4.2 with Mercury SiteScope

 
SOLVED
Go to solution
Scott Sievers
Frequent Advisor

Integrate SIM 4.2 with Mercury SiteScope

In order to integrate the alerts SIM receives into Mecury SiteScope I need to come up with a query that searches the SQL database. Here is the first stab at it.

SELECT
devices.DeviceKey,
devices.Name,
devices.ProductTypeStr,
devices.ProductName,
notices.NoticeId,
notices.NoticeSeverity,
notices. State,
notices.NoticePriority,
notices.Generated,
notices.LastModified ,
noticeType.typeIdStr,
alertTypesDescrEnum.displayString,
IPAddress.IPAddress,
IPAddress.IPsubnetMask
FROM
devices, notices, noticeType, alertTypesDescrEnum, IPAddress
WHERE
noticeType.noticeType=notices.noticeType and devices.DeviceKey=notices.DeviceKey and alertTypesDescrEnum.enumId=noticeType.noticeType and IPAddress.DeviceKey=devices.DeviceKey and IPAddress.ipindex=0 AND LastModified > ?

Of course this doesn’t work, yet. Does anyone have a ready-made query for SIM 4.2 that would accomplish this task?

Does HP produce a list of the table names and what fields they contain and how to interpret them? In particular, I would like to know how to interpret the values in the Severity field and the State field from the “notices” table.
3 REPLIES 3
fred Passeron
HPE Pro
Solution

Re: Integrate SIM 4.2 with Mercury SiteScope

Hi

Did you take a look at the tables info on the online help of HP SIM itself.
From the web interface, clik on the question mark in the top right hand corner, then search for tables, the first result will drive you to the info you look for.

Hope it helps

fred
“Life is pleasant. Death is peaceful. It's the transition that's troublesome.” Isaac Asimov
Mark Kieselburg
New Member

Re: Integrate SIM 4.2 with Mercury SiteScope

Scott,

See attached and see if this helps - it is a bit dated and I am not sure what SIM rev it covers.

Mark
Scott Sievers
Frequent Advisor

Re: Integrate SIM 4.2 with Mercury SiteScope

Mark,

When I opened the zip file it was empty. There was a pop-up that recommended I download it again, but that didn't help.