martinjt / elmah

Automatically exported from code.google.com/p/elmah
Apache License 2.0
0 stars 0 forks source link

Show errors with SSRS #345

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
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

GoogleCodeExporter commented 9 years ago
>>
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

GoogleCodeExporter commented 9 years ago
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

GoogleCodeExporter commented 9 years ago
Closing based on comment #2

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