database view for history and record history table and task table

snehalkhare
Kilo Guru

‎08-05-2017 08:46 AM

Hi,

I have created database view for the sys_history_set and sys_history_line. After try it , it doesn't show the records. ''No records found" . How to get the records for this database view?

find_real_file.png

Thanks & Regards,

Snehal Khare

Preview file
43 KB
0 Helpfuls
  • 1,904 Views
3 REPLIES 3

antin_s
ServiceNow Employee
ServiceNow Employee

‎08-05-2017 09:18 AM

Hi Snehal,



Whats the use case here? What do you want to see in the Database view?



Also, before building your use case around these tables, please have a look at the below links of what these tables contain and they records get removed from these tables.



http://wiki.servicenow.com/index.php?title=History_Sets#gsc.tab=0



Hope this helps. Mark the answer as correct/helpful based on impact.



Thanks


Antin


0 Helpfuls

snehalkhare
Kilo Guru
In response to antin_s

‎08-05-2017 11:04 AM

Hi Antin,



I want all the fields available on the three tables... so that I can display old value, new value,task type , update date time ,etc.. all on one.


Is this possible?



Thanks & Regards,


Snehal Khare


0 Helpfuls

antin_s
ServiceNow Employee
ServiceNow Employee
In response to snehalkhare

‎08-05-2017 11:08 AM

You can get all those fields from 'sys_audit' table itself? Also, please check the below URL which explains how the data get removed from history set tables.



http://wiki.servicenow.com/index.php?title=History_Sets#gsc.tab=0



Hope this helps. Mark the answer as correct/helpful based on impact.



Thanks


Antin


0 Helpfuls