Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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 ?