How to generate history set via API
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-06-2019 03:00 PM
I'm analyzing incidents for the last few months and I want to look at state and assignment group. For any of them that have been recently browsed by a user the data is in sys_history_line. The problem is that for ones that have not been viewed, there is no data. This seems pretty consistent with the documentation.
I don't want to pull from the sys_audit table, as that would be impactful and i've tried everything I can think of to trigger the history set to be built. Finally i just wrote a script that opens them all in chrome. There has to be a better way.
Any advice much appreciated!
- Labels:
-
Integrations
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-06-2019 08:45 PM
Ideally these kind data should never be pulled from ServiceNow. It can impact the performance. You should always copy your data in a data warehouse and do the reporting.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2019 05:13 AM
I appreciate that and thanks for the wisdom, but this is a one time analysis to look for some behavior patterns in our service desk and engineering teams. I'm not looking for a perpetual solution.
