- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- Re: HP SIM Event Log location
Categories
Company
Local Language
Forums
Discussions
Knowledge Base
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Knowledge Base
Forums
Discussions
- Cloud Mentoring and Education
- Software - General
- HPE OneView
- HPE Ezmeral Software platform
- HPE OpsRamp
Knowledge Base
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-11-2014 06:58 AM - edited 09-11-2014 07:03 AM
09-11-2014 06:58 AM - edited 09-11-2014 07:03 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-11-2014 09:39 AM
09-11-2014 09:39 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-11-2014 09:06 PM
09-11-2014 09:06 PM
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 ?