Hi everyone,

Is there anyone in the DNN community who had to write custom event-log reports for their portals?  While the DNN Log viewer module is a great tool, my boss wants me to take it a step further and write event-log reports where users can filter/group/sort at the property level (i.e. the .LogProperties() collections for each log entry) It appears that the log viewer module filters only by event type (and understandably so, given the dynamic nature of custom log properties - it doesn't make any sence to filter by log property).

I'm thinking of flattening the loginfo fields and custom props into a datatable e.g.
logGuid,  logUserID, logCreateDate, logType, prop1, prop2, prop3, prop4.......propN

From there I can easily bind the datatable to a datagrid or even pass it to reporting engine such as crystal or ActiveReports (any reporting product that supports datatable binding) where I can write specific reports for each log type.

It doesn't seem like a lot of work. I wrote some prototype code that I'll think will handle this. I'm just curious what others in the community have done if they were asked to write similar event-log reporting functionality.

In a future release it would be useful if the logging api could capture not just name/value pairs, but the datatype declaration of each property (it appears that the logging API stores and retrieves props as strings - which is a problem if any numerical/date sorting/filtering is needed).