Need to automate the scheduled report generation and attach it with email to share as an attachment

[nupur_goswami]

I have a requirement from the client where I need first apply some filters and then need to generate a report from a custom table. After the report is generated, it should be shared as an attachment on email. Additionally, this whole process should be automated and should run automatically every 3 months.

Any advice would be highly appreciated.

Many thanks

[Dr Atul G- LNG]

Hi @nupur_goswami 

What you asked in the question has been answered, and that fulfils the statement. If you have additional requirements, you should include them in the question. If you look at the responses from @AndersBGS and @Robert H, you'll see that all of them are correct, but you didn't accept the answer, which is my point.

[nupur_goswami]

Yes my bad I should have mentioned the whole scenario in my question. As per my question posted the response was correct. Thanks for your help 

[Dr Atul G- LNG]

So, Technically, all answers are correct, including @AndersBGS  @Robert H  and myself.

As per the community feature, you can accept more than one answer as the accepted solution.

[Ankur Bawiskar · Accepted solution]

@nupur_goswami 

You can have report with static filter and then create scheduled report and link the report here.

Have the scheduled report to run Periodically every 90 days and then include users and groups to whom email has to be sent.

The email sent will have the report attached as well.

these links should help you get started

Scheduled Reports 

Creating a Scheduled Report in ServiceNow 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@nupur_goswami 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.