SendEmail Script Examples - Revision history

Ollvihe at 20:50, 25 October 2021

2021-10-25T20:50:56Z

← Older revision		Revision as of 20:50, 25 October 2021
Line 1:		Line 1:
	This page contains script examples for the [[~~QPR ProcessAnalyzer~~ Scripting Commands#--.23SendEmail\|SendEmail]] script command.		This page contains script examples for the [[SQL Scripting Commands#--.23SendEmail\|SendEmail]] script command.

	The following example will send an e-mail message with two attachments to multiple recipients.		The following example will send an e-mail message with two attachments to multiple recipients.

Ollvihe at 07:43, 7 February 2018

2018-02-07T07:43:04Z

← Older revision		Revision as of 07:43, 7 February 2018
Line 1:		Line 1:
	This page contains script examples for the [[~~Supported_QPR_ProcessAnalyzer_Commands_in_Scripts~~#--.23SendEmail\|SendEmail]] script command.		This page contains script examples for the [[QPR ProcessAnalyzer Scripting Commands#--.23SendEmail\|SendEmail]] script command.

	The following example will send an e-mail message with two attachments to multiple recipients.		The following example will send an e-mail message with two attachments to multiple recipients.

TeeHiet: 306899

2016-12-12T08:28:21Z

306899

← Older revision		Revision as of 08:28, 12 December 2016
Line 1:		Line 1:
	This page contains script examples for the [[Supported_QPR_ProcessAnalyzer_Commands_in_Scripts#--.23SendEmail\|SendEmail]] script command.		This page contains script examples for the [[Supported_QPR_ProcessAnalyzer_Commands_in_Scripts#--.23SendEmail\|SendEmail]] script command.

	The following example will send an e-mail message to multiple recipients.		The following example will send an e-mail message with two attachments to multiple recipients.
	<pre>		<pre>
	(SELECT 'EmailFrom', 'example.from@address.com') UNION ALL		(SELECT 'EmailFrom', 'example.from@address.com') UNION ALL
Line 7:		Line 7:
	(SELECT 'EmailSubject', 'Example E-mail') UNION ALL		(SELECT 'EmailSubject', 'Example E-mail') UNION ALL
	(SELECT 'EmailBody', 'QPR ProcessAnalyzer example script started running.') UNION ALL		(SELECT 'EmailBody', 'QPR ProcessAnalyzer example script started running.') UNION ALL
			(SELECT ''EmailAttachmentQuery', 'SELECT * from #EmailAttachmentParameters') UNION ALL
	(SELECT 'SmtpServer', 'localhost')		(SELECT 'SmtpServer', 'localhost')
	--#SendEmail		--#SendEmail
	</pre>		</pre>

			Where the #EmailAttachmentParameters table contains following data:
			{\| class="wikitable"
			! style="text-align:left;"\| Name
			! style="text-align:left;"\| Content
			! style="text-align:left;"\| Media type
			! style="text-align:left;"\| Creation time
			\|-
			\| Example attachment picture
			\| Picture.jpg
			\| image/jpg
			\| 2016-04-22 12:00:00
			\|-
			\| Example attachment xml file
			\| Example.xml
			\| text/xml
			\| 2016-04-22 12:00:01
			\|}
	[[Category:Examples]]		[[Category:Examples]]

TeeHiet at 09:03, 20 June 2016

2016-06-20T09:03:58Z

← Older revision		Revision as of 09:03, 20 June 2016
Line 11:		Line 11:
	</pre>		</pre>

	[[~~Cateogry~~:Examples]]		[[Category:Examples]]

TeeHiet: 403051

2016-06-20T08:59:57Z

403051

New page

This page contains script examples for the [[Supported_QPR_ProcessAnalyzer_Commands_in_Scripts#--.23SendEmail|SendEmail]] script command.

The following example will send an e-mail message to multiple recipients.
<pre>
(SELECT 'EmailFrom', 'example.from@address.com') UNION ALL
(SELECT 'EmailTo', 'recipient.one@address.com,recipient.two@address.com,recipient.three@address.com') UNION ALL
(SELECT 'EmailSubject', 'Example E-mail') UNION ALL
(SELECT 'EmailBody', 'QPR ProcessAnalyzer example script started running.') UNION ALL
(SELECT 'SmtpServer', 'localhost')
--#SendEmail
</pre>

[[Cateogry:Examples]]