Exporting events from SIM

[Steve Kadish]

Hi,

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

Thanks,
- Steve

[NJK-Work · Accepted solution]

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

[Steve Kadish]

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

Thanks,
- Steve

[Aravindh Rajaram]

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

[Steve Kadish]

Thanks! That's very helpful.

- Steve

[Steve Kadish]

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.