Servicely Capability
Reports and Dashboards
Scheduled reports
2 min
overview a scheduled report runs a report/reports regularly on a nominated day and time and send them to a pre defined list of users and groups creating a scheduled report to create a scheduled report, navigate to reporting > reports > new scheduled report navigation menu it is important to understand how the fields are used and can be used scheduled reports have the following fields field name description example name name of the scheduled report incident management snapshot description description of the scheduled report last week’s snapshot for incident management reports list of report(s) that you want run and sent schedule when the scheduled report is supposed to run every monday at 6am template reports list of template report(s) that you want run and sent active if the scheduled report is active yes run as the nominated reports and template reports will be run using this user and its permissions someone users list of servicely user accounts to receive the reports/template reports when the scheduled report runs groups list of servicely groups to receive the reports/template reports when the scheduled report runs subject subject of the email that will be sent out when the scheduled report runs and sends the nominated reports/template reports out note that you can also access the user object such as ${user name()} last week’s incident management body body of the email that will be sent out when the scheduled report runs and sends the nominated reports/template reports out note that you can also access the user object such as ${user name()} hi ${user name()}, please find attached last week’s snapshot for incident management table this is a table that can be used as a parameter whether the scheduled report should run and be sent example is a control table that can suspend particular scheduled reports if a table combined with the condition returns 0 records then the scheduled report will not run condition a condition linked to a table that can be used as a parameter whether the scheduled report should run and be sent if a table combined with the condition returns 0 records then the scheduled report will not run context script to be passed to template reports that are part of the scheduled report this is the same as when you have to provide context when previewing a template report note that the context script can be constructed to provide “default” values and an “overrides” that uses the template report key or the template report id to distinguish one override from another in this example all other reports in the scheduled report look at an incident record, while the template report with key sampletemplatereport looks at a change record instead answer = { default { table "incident", id "cc91c0bd245811eebc251e79e3c7c1bb" }, overrides { sampletemplatereport { table "change", id "4e24e07d247f11ee8bbde66d9ebc34c6" } }} answer = { table "incident", id "cc91c0bd245811eebc251e79e3c7c1bb"}; please note that if your report generated is over 50mb, it will not be sent and an error will be sent in the resulting email