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: [email protected] [mailto:[email protected]] On Behalf Of Pedro Henrique Sent: Thursday, December 19, 2013 2:57 PM To: [email protected] 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 <[email protected]<mailto:[email protected]>> 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: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Pedro Henrique Sent: Thursday, December 19, 2013 2:48 PM To: [email protected]<mailto:[email protected]> 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 <[email protected]<mailto:[email protected]>> 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: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Pedro Henrique Sent: Thursday, December 19, 2013 2:33 PM To: [email protected]<mailto:[email protected]> Subject: Re: [servman] Incident History Really? :( But, how can I track my Incident changes? 2013/12/19 Travis Wright <[email protected]<mailto:[email protected]>> Not really. Some property history is recorded in the DW like Status, Assigned to, etc. but not every property value change. From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Pedro Henrique Sent: Thursday, December 19, 2013 2:22 PM To: [email protected]<mailto:[email protected]> 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,
