decrypting error report data in SQL

.NET obfuscator and automated error reporting

Moderators: Luke Jefferson, melvyn.harbour, dom.smith

decrypting error report data in SQL

Postby nate@climark.com » Tue Dec 10, 2013 1:39 am

We have a SQL database that stores the error reports that get sent to us from the field. I need to query this information to find out pertinent patterns; (e.g. all users who received the same error in the same date range, all errors that have occurred within a given class, etc.

Is there a way to decrypt the data in the SQL tables into searchable data?

Thanks in advance.
nate@climark.com
 
Posts: 2
Joined: Tue Dec 10, 2013 1:34 am

Postby Chris.Allen » Wed Dec 18, 2013 5:15 pm

Yes, we have such an API- it comes with the full, professional, version of the product.

To give you an idea what you can build, please take a look at:

ftp://support.red-gate.com/patches/Smar ... tabase.exe

It's a lot the GUI but created entirely from the SDK- you can see how it can access the error reports using the 'Exception reports' Tab
Chris.Allen
 
Posts: 594
Joined: Thu Mar 12, 2009 4:17 pm

Postby nate@climark.com » Thu Dec 19, 2013 6:04 pm

Thanks very much for getting back to me. You pointed out the API for me and it was exactly what I needed.

I wrote an app that used your API to extract the exception report attributes and custom fields, which I then write to a separate SQL database. Then I’m about to query that separate database based on the values in the attributes and custom properties and get meaningful results, such as all errors from a specific user or office, all errors that contain a specific frame in the call stack, all errors using a specific assembly, etc.

I understand why you compress all this data when you store it in SQL, but not being able to search lessens the value of the Smart Assembly application…

Anyway, thanks for the help.
nate@climark.com
 
Posts: 2
Joined: Tue Dec 10, 2013 1:34 am


Return to SmartAssembly 6

Who is online

Users browsing this forum: No registered users and 0 guests