Need to send a weekly report schedule

[sanga2]

Hi all, I have a requirement where in I need to send a weekly report of list of incidents which have been updated to work in progress for that week. The list should include the incident number, requestor, state and link to that incident. Please suggest on how to achieve this?

[manjusha_]

@sanga2 

Refer below screenshot for the required report

Go to system scheduler>scheduled job

Create a schedule to send  report based on duration.

If my answer solved your issue, please mark my answer as ✅Correct & 👍Helpful based on the Impact

Thanks,

Manjusha Bangale

[sanga2]

Hi Manjusha, 

This is not my requirement. The list should include the incident number, requestor, state and link to that incident in a list format.

Thanks.

[Sruthi17]

Hi,

Please try the below condition on the audit (sys_audit) table

Please accept solution or helpful, if you find it helpful.

[sanga2]

This is not my requirement. The list should include the incident number, requestor, state and link to that incident in a list format.

Thanks.