dhont/elmah

Show errors with SSRS

Closed this issue · 3 comments

What new or enhanced feature are you proposing?
An example of viewing the errors via SSRS

What goal would this enhancement help you achieve?
The ability to view the logged reports through reporting services.

Background
Where I'm working at I've added ELMAH to an asp.net web form that uses Sql 
Server to save the errors.  This all works great and I can save errors without 
any problem.  The problem I'm having is to find an easy way to view the XML in 
a secured way.  I've looked at email, rss and viewing the errors locally, but 
they all have their problems.  It would seem to me that creating Sql Server 
Reporting Services report of the ELMAH_Error table would be an obvious 
solution.  What I don't know is how do your format the XML so that it looks 
nice (like it would if I went to elmah.axd web page locally).  Has anyone else 
arleady don this?

Original issue reported on code.google.com by JohnMars...@gmail.com on 1 Oct 2013 at 9:08

>>
What I don't know is how do your format the XML so that it looks nice (like it 
would if I went to elmah.axd web page locally).  
<<

The ELMAH_Error table has some columns that are used as a summary and then the 
AllXml columns holds the full details in XML. At run-time, the XML is loaded 
into an Error object that is then used to format the various pages. You might 
also want to check out some of the following search results for ideas on 
working with the AllXml column directly in SQL Server:
https://www.google.com/search?q=elmah+error+table+xml+query

> Has anyone else arleady don this?

No. If you plan to work on this then we can certainly link to your solution, 
whether that be in the form of an open source project, article or a blog entry.

Original comment by azizatif on 5 Oct 2013 at 8:00

  • Changed state: PatchesWelcome
  • Added labels: Component-Persistence, Component-UI, Priority-Low
  • Removed labels: Priority-Medium
Thank you for your response and your google search suggestion.

Maybe the solution to my problem is ELMAH Log Analyzer
http://code.google.com/p/elmah-loganalyzer/

I didn't know this existed before I made this feature proposal

John

Original comment by JohnMars...@gmail.com on 5 Oct 2013 at 2:42

Closing based on comment #2

Original comment by azizatif on 7 Oct 2013 at 5:31

  • Changed state: WontFix