How to create a report on sys_journal_field table

[____39]

How to create a report on sys_journal_field table

[Harish KM]

Hi sys_journal_field is not reportable.  Go thru the below links 

https://community.servicenow.com/community?id=community_question&sys_id=814465e4db396700107d5583ca961919

https://community.servicenow.com/community?id=community_question&sys_id=df0f8fa1dbdcdbc01dcaf3231f961913

[____39]

Hi, thank you for responsing, I can not visit this site, Is there a document about database view?

http://wiki.servicenow.com/index.php?title=Database_Views

[Jaspal Singh]

Hi,

Can you confirm your exact Business need?

You might want to create a database view required table (incident, change, etc.) & sys_journal_field that holds sys_id of record in Element field.

You can check on existing Incident SLA database view by navigating to System Definition >>Database Views