You can look at the work item forms History tab. If you want to get it programmatically you can use the SDK: http://blogs.technet.com/b/servicemanager/archive/2011/09/16/accessing-object-history-programmatically-using-the-sdk.aspx
If you want to try to figure it out using SQL queries (last part of blog post): http://blogs.technet.com/b/servicemanager/archive/2009/12/31/service-manager-database-tour-useful-queries.aspx BTW - this is also useful information http://blogs.technet.com/b/servicemanager/archive/2010/02/04/action-log-history-and-auditing-in-service-manager.aspx From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Pedro Henrique Sent: Thursday, December 19, 2013 2:57 PM To: servman@lists.myitforum.com Subject: Re: [servman] Incident History Nice to know so can I get this info from SERVICEMANAGER DB? Can you tell me what table handle this data? Please... 2013/12/19 Travis Wright <travis.wri...@cireson.com<mailto:travis.wri...@cireson.com>> The detailed history is stored in the SCSM database for a configurable period of time. Beyond that the idea is that the detailed history data is not worth the storage cost to keep in the data warehouse long term. If you want to keep detailed history for a long period of time then you can change the data retention/grooming settings in SCSM to keep the data in SCSM for longer. Depending on the size of your deployment this may or may not affect performance. From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>] On Behalf Of Pedro Henrique Sent: Thursday, December 19, 2013 2:48 PM To: servman@lists.myitforum.com<mailto:servman@lists.myitforum.com> Subject: Re: [servman] Incident History Why Microsoft does not offer this by design? Not make sense, all Service Desk needs this kind of stuff :( 2013/12/19 Travis Wright <travis.wri...@cireson.com<mailto:travis.wri...@cireson.com>> If there are certain properties you want to track the changes for you can create a Fact about them in the DW. It's not easy but it can be done. All XML, no tools. Check out the reporting/DW presentations I've done on the Microsoft Virtual Academy for the details. From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>] On Behalf Of Pedro Henrique Sent: Thursday, December 19, 2013 2:33 PM To: servman@lists.myitforum.com<mailto:servman@lists.myitforum.com> Subject: Re: [servman] Incident History Really? :( But, how can I track my Incident changes? 2013/12/19 Travis Wright <travis.wri...@cireson.com<mailto:travis.wri...@cireson.com>> Not really. Some property history is recorded in the DW like Status, Assigned to, etc. but not every property value change. From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>] On Behalf Of Pedro Henrique Sent: Thursday, December 19, 2013 2:22 PM To: servman@lists.myitforum.com<mailto:servman@lists.myitforum.com> Subject: [servman] Incident History Where in SCSM 2012 Database can I make a report to get all History changes for an Incident? I need to create a Report that show the Incident change log in the time. Thank you,
