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.commailto: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.commailto:listsad...@lists.myitforum.com
[mailto:listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com]
On Behalf Of Pedro Henrique
Sent: Thursday, December 19, 2013 2:48 PM
To: servman@lists.myitforum.commailto: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.commailto: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.commailto:listsad...@lists.myitforum.com
[mailto:listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com]
On Behalf Of Pedro Henrique
Sent: Thursday, December 19, 2013 2:33 PM
To: servman@lists.myitforum.commailto: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.commailto: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.commailto:listsad...@lists.myitforum.com
[mailto:listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com]
On Behalf Of Pedro Henrique
Sent: Thursday, December 19, 2013 2:22 PM
To: servman@lists.myitforum.commailto: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,