CSA csamc45 db - where are the agent events stored?

[RichardSW]

I need to know which table in the csamc45 db stores all of the events/alerts that the CSA agents send back to the server.

[tsteger1]

Richard, EventListView gives the comprehensive list and ties it to hosts.

The EventText field has the text sent back to the server.

Tom S

[RichardSW]

At first I couldn't find this in the Tables, but now I see you're refering to a View. Do you know what table stores this data? At least with the View I can pick apart the query and find the relevent tables. Thanks very much!

[tsteger1]

The table with event text is formatted_event_log.

Please rate posts if you find them helpful so others may benefit.

Thanks

Tom S