database view for history and record history table and task table

snehalkhare
Kilo Guru

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

3 REPLIES 3

antin_s
ServiceNow Employee
ServiceNow Employee

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


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


antin_s
ServiceNow Employee
ServiceNow Employee

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