HPE Community
Server Management - Systems Insight Manager
1832994 Members
2780 Online
110048 Solutions
New Discussion

Re: SIM DB Query

 
Seth Adams
Frequent Advisor

‎04-30-2008 10:51 AM

‎04-30-2008 10:51 AM

SIM DB Query

I have looked around, but am not finding what I am looking for. So... where in the DB can I find the event text for events generated within SIM? I see the varbinds, but is the compiled text able to be queried?
0 Kudos
Reply
2 REPLIES 2
Aravindh Rajaram
Honored Contributor

‎04-30-2008 12:14 PM

‎04-30-2008 12:14 PM

Re: SIM DB Query

You'll have to create a SQL view between the tables "notices" and "noticeType" to get the desired descriptive data. Or, you can pull out the SQL Query using any of the event reports in SIM.
0 Kudos
Reply
Joel Rubenstein
Honored Contributor

‎04-30-2008 12:22 PM

‎04-30-2008 12:22 PM

Re: SIM DB Query

The SIM DB already includes a view dbo.notices_view which contains the data you are looking for.
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.