Red Gate forums :: View topic - decrypting error report data in SQL
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SmartAssembly 6
SmartAssembly 6 forum

decrypting error report data in SQL

Search in SmartAssembly 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
nate@climark.com



Joined: 10 Dec 2013
Posts: 2

PostPosted: Tue Dec 10, 2013 1:39 am    Post subject: decrypting error report data in SQL Reply with quote

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.
Back to top
View user's profile Send private message
Chris.Allen



Joined: 12 Mar 2009
Posts: 546

PostPosted: Wed Dec 18, 2013 5:15 pm    Post subject: Reply with quote

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/Smart_Assembly/SmartAssembly.Database.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
Back to top
View user's profile Send private message
nate@climark.com



Joined: 10 Dec 2013
Posts: 2

PostPosted: Thu Dec 19, 2013 6:04 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group