I wrote a quick sample console application to show how to use the SDK to access the history information about objects. The output looks like this:
In this example, I created an incident and then changed the title on it. That created two “transactions”. Each transaction has its own date/time stamp and an indication of which user initiated the transaction (FABRIKAM\Administrator). Then each of the property value changes are listed and then the relationship add/remove actions that happened.
The code itself is a little bit tricky to figure out on your own, but with the example below it should be pretty easy to figure out:
I’ve attached the code project as an attachment to this blog post.
I am curious as to how to do this in SQL. I am aware of the transaction tables, but have had trouble getting all history for an incident.
How to get the history for the object loaded via a custom connector on the "History" Tab?
your blog is nice..
Aries Tech Soft.
<a href="http://www.ariestechsoft.net">MLM software noida</a>
your blog is very Informative.
<a href="http://www.finnjobs.com">Seo training Noida</a>