Server Management - Systems Insight Manager
1752615 Members
4756 Online
108788 Solutions
New Discussion

HP SIM Event Log location

 
altafhussian1
Occasional Contributor

HP SIM Event Log location

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

2 REPLIES 2
n0kia
Valued Contributor

Re: HP SIM Event Log location

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
Occasional Contributor

Re: HP SIM Event Log location

Thanks for the reply,

 

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