In this video, I go through this cool API, which is really there for you when you need to look at a record's history. And to avoid digging into sys_audit and all other fun stuff, it does the work for you.
I also show you how to build your own related list that you can use on a record form.
Video record in Paris release.
HistoryWalker API Docs: https://developer.servicenow.com/dev.do#!/reference/api/paris/server/sn_hw-namespace/c_HistoryWalkerScopedGlobal
Github for the Code: http://github.servicenowwitchdoctor.com
In your Twittter (tweet?) for this, you mentioned that you found an easier way to do what you wanted with Condition Builder... would you mind sharing share that with us here? (I can't find it).
(I have a need to report on Assignment Group changes, to/from particular groups. Thought I had that solved using the History table, then found that THAT table both clears out after 30 days or so, AND has duplicates if someone with a different time zone setting views the incident/case).
I'm hopeful that your Condition Builder approach MIGHT be helpful, or I might attempt to build a script using HistoryWalker for this (but I'd prefer not to do that). (the other approach, creating a Metric for Assignment Group change, is less desirable because I don' t see how to report both Old and New Assignment Group without adding a field to the table capturing the metric...)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
