How to run a Report that shows the changes in status on SCTASKS

michelle kirk
Kilo Guru

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 

 

 

 

 

1 REPLY 1

michelle kirk
Kilo Guru

 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 ?