Server Management - Systems Insight Manager
1753962 Members
7742 Online
108811 Solutions
New Discussion юеВ

Re: SIM DB Query

 
Seth Adams
Frequent Advisor

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?
2 REPLIES 2
Aravindh Rajaram
Honored Contributor

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.
Joel Rubenstein
Honored Contributor

Re: SIM DB Query

The SIM DB already includes a view dbo.notices_view which contains the data you are looking for.