Report on Audit(sys_audit) table through Database View..?

[m_servicenow]

Hi Everyone,

I want to create one report through Database view on 1) sys_audit table and 2) Server table joins.

I need one suggestion from everybody that is it make sense to create report on sys_audit table? if Yes then

I m facing one issue that i want to show report on the basis of server_sys_id = audit_documentkey

Please see screenshot for more info.

Where i am doing mistake no audit record is coming in report... Any help will be more appreciated.

[lbodeen]

I am reading that you can't do views on sys_audit table. Have not confirmed with service now support though.

[sarazona1]

Are there any updates on this?   Has anyone tried this yet?

[lbodeen]

I could not get a view against this table to work. Although support said you could they just would not support it