Reports -> Scheduled Reports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-20-2023 01:38 AM
Hello everyone !
Using 'Scheduled Reports' feature for the first time in ServiceNow 🙂
Scenario:
Built a Report with some conditions and to run daily at a given time, send an email to a shared mailbox
(Condition is basically a CI created with some specific attributes AND 'Created' on 'Yesterday')
Am expecting that report to fetch records only once in a week.
So, figured out a way to send an email ONLY if there are any records in the report (using the 'Omit if no records' flag available in the Schedule)
Query:
Now, what I really want is to embed the CI link(s) from the report output in the email body itself.
I understand that the report output can be attached in the email as a pdf/excel/csv but i was hoping to provide a clickable link in the body itself.