Need help with reporting on system log

[saini]

There is some transform script that runs everyday and create system logs, can I create report on this everyday?is it possible to automate this process anyhow? any direction would be appreciated. Thanks

[Community Alums]

Can you share more details on what you want to report on? Details of the transform? What has changed?

[saini]

so the whole idea here is to point out the fields which are updated during transform which they do everyday.

So they wrote a tranform onAfter script which logs the updated field and they ask me to create a report on this logs which contains the updated field.

So we need to find out the updated fields everyday, do you think there is any other alternative?

Thanks

[Logan Poynter]

Hello saini,

You cannot report on the syslog table by default. Please see https://docs.servicenow.com/bundle/sandiego-now-intelligence/page/use/reporting/concept/c_ReportOnSy...

If you must report on a system table, you can add it to the glide.ui.permitted_tables property. Navigate to System Properties > UI Properties and locate the property labeled List of system tables (beginning with "sys_", comma separated), that are reportable. By default, system tables are not reportable. Proceed with caution.

Please mark my answer as correct/helpful if it has helped you.

Thanks,
Logan