Sending email through mid server/powershell

Community Alums
Not applicable

Hi folks,

 

we’ve requirement,

we need to process User Roles table data(new roles created, roles added to users over the month) and we want to save this data as a file in MID server and need to send an email along with attachment.

 

how can we achieve this functionality ?

4 REPLIES 4

Ankur Bawiskar
Tera Patron
Tera Patron

@Community Alums 

you can leverage export set capability which pushes files to mid server folder location

Export sets 

You can also send email using the Post-export script in scheduled export set

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Community Alums 

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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi @Ankur Bawiskar ,

thanks for your reply.

 

can we export 50K+ records using this process?

@KhasimKhanP 

export sets uses OOB export properties for excel. check the limit in that.

If it is within that range then it will export.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader