topic Re: HP SIM Event Log location in Server Management - Systems Insight Manager

HP SIM Event Log location

altafhussian1 — Thu, 11 Sep 2014 14:03:54 GMT

Hi,

I have been working in HP SIM. Is there any particular command to erase all(Critical,Major,Minor,...) event logs ???

Or Where I can find the event log , whether it is from database or it is from file?..

So that I can clear the logs without using HP SIM GUI..

Thanks in advance

n0kia — Thu, 11 Sep 2014 16:39:40 GMT

Here you go bud!

dbo.notices

1) Stop the System Insight Manager Service

Backup your SIM DB Insight_V50_XXXXX

-- Notice Severity

----- 5 = Critical

----- 4 = major

----- 3 = minor

----- 100 = information

-- Notice Type

---- 1 = Discovered System - must not delete otherwise sim won't work

2) Open in SQL Management Studio for the SQL server. Right click the SIM db -> Run Query

-- for information

delete

from notices

where (

(noticeType != 1 ) and

(noticeSeverity = 100)

)

-- for critical

delete

from notices

where (

(noticeType != 1 ) and

(noticeSeverity = 5)

)

-- for minor

delete

from notices

where (

(noticeType != 1 ) and

(noticeSeverity = 3)

)

4) Open a command prompt on the sim server and run (from any directory) : mxconfigrepo –f ( Might take a while depending on amount in DB )

5) Restart SIM service

altafhussian1 — Fri, 12 Sep 2014 04:06:09 GMT

Thanks for the reply,

Could anyone be specific to help me to clear the uncleared event status in HP SIM without GUI ?