Reputation: 565

Which Table in DNN will contain Admin Logs?

I need to export Admin Alerts from DNN's database.

Which table contains this?

Upvotes: 1

Answers (4)

DotnetDev

Reputation: 21

All the logs for DNN are placed in EventLog table, you need to run a direct database query to access eventlog records

Upvotes: 2

Sanket Patil

Reputation: 21

Its "EventLog" table from DNN database

Upvotes: 0

VDWWD

Reputation: 35514

It is the table EventLog. But keep in mind that since DNN 7 (I think) the logs are automatically removed. In earlier versions the default settings would be to keep all log items, so the table EventLog would sometimes contain millions of records.

So if you want to keep certain logitems for export you need to modify the settings in "Admin > Log Viewer > Edit Log Settings". You'll see a row of log types. You can edit the one you need to change the settings.

Upvotes: 1

Joffies

Reputation: 38

SELECT * FROM [dbo].[EventLog] WHERE LogTypeKey = 'ADMIN_ALERT'

Upvotes: 1

Which Table in DNN will contain Admin Logs?

Answers (4)

Related Questions