How to run a Report that shows the changes in status on SCTASKS
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-07-2025 08:27 AM
Hi
We are trying to create a report, as we have found an issue with SCTASKs, as they are re-opening after they have closed, but randomly have started a month after the initial sctask was closed.
I need to run a report that shows the following information, I have used the Catalog Task [sc_task]
SCTASK Number
Created
State
Actual End Date
Work Note that has the Field Change by System Administrator - I need this information capturing
System Administrator, Field Changes , the date of the field change and the state change
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-07-2025 08:29 AM
Its missed off some of the text - I can capture all the fields above, with the exception of the Field Change work note
Is it possible to pull that field change work note info ? if so what table do I need to use ?