topic Re: Exporting events from SIM in Server Management - Systems Insight Manager

Exporting events from SIM

Steve Kadish — Thu, 12 May 2005 16:30:57 GMT

Hi,

Is there ANY way, either using the GUI or the CLI, to export events out of SIM?

Thanks,
- Steve

Re: Exporting events from SIM

NJK-Work — Thu, 12 May 2005 17:09:54 GMT

Hi Steve,

Assuming you are using SQL server (MSDE or 2000) as your DB, you should be able to use any reporting tool such as Access or Crystal reports.

Personally, I use SQL 2000 DTS (Data Transformation Services) to schedule exports from SIM of useful data to another SQL database used as a Server Inventory application. However, you should be able to export using DTS to various formats including XLS, CVS or Oracle tables.

Nelson

Re: Exporting events from SIM

Steve Kadish — Thu, 12 May 2005 17:12:41 GMT

Thanks. In that case, can anyone point me towards a document which lays out the database structure?

Thanks,
- Steve

Re: Exporting events from SIM

Aravindh Rajaram — Fri, 13 May 2005 02:08:59 GMT

These are the tables that might help you in getting the events.

notices
devices

Note: The The time the event was received is recorded in EPOCH format. You'll have to convert them in order to get a good report. Also Notice severity also has to be converted.
100 - Informational
5 - Critical
1 - Normal
3 - Minor
4 - Major

Re: Exporting events from SIM

Steve Kadish — Fri, 13 May 2005 09:49:47 GMT

Thanks! That's very helpful.

- Steve

Re: Exporting events from SIM

Steve Kadish — Tue, 17 May 2005 11:23:35 GMT

The information was helpful but has not enabled me to get meaningful reports of events out of SIM. I'm going to open another thread.