How to using SQL status to search the alert mail's content
V7.1.2.67<p>
<b>my question is: How to using SQL status to search the alert mail's content?</b><p>
<p><p><p>
<b>The alert mail content sample:<b><p>
sample:</b><p>
10 Dec 2018 10:26:59 AM
Computer: [TPEFS]
Monitor: [Watch P:\Public\]
Description:
The following users have exceeded monitoring thresholds:
COMPAL\EmilySC_Huang read (and possibly copied) 130 files under P:\Public\ in 1m 49s from 10.110.24.63. The alert threshold is 30 files in 2m 0s. <br />
Read files include: include:<br />
P:\Public\Logistics\Sourcing\EE\2nd Source Tracking\A39\A39 Asahi 15 PCE action format.xls <br />
P:\Public\Logistics\Sourcing\EE\2nd Source Tracking\A39\A39 Asahi ZIUS1 EE EVT BOM LIST and action 2014-03-28.xlsx <br />
P:\Public\Logistics\Sourcing\EE\2nd Source Tracking\A39\action\A39 AIVS1 Storm EE BOM List v0116.xlsx <br />
P:\Public\Logistics\Sourcing\EE\2nd Source Tracking\A39\action\A39 LIN_Storm_Ella2_0304_EE.xlsx <br />
P:\Public\Logistics\Sourcing\EE\2nd Source Tracking\A39\action\AIVS1.xlsx <br />
P:\Public\Logistics\Sourcing\EE\2nd Source Tracking\A39\action\LIN_New Action Table.xlsx <br />
P:\Public\Logistics\Sourcing\EE\2nd Source Tracking\A39\AILL1_AILL2 2nd source.xlsx source.xlsx<br />
P:\Public\Logistics\Sourcing\EE\2nd Source Tracking\A39\Merlyn2 0 SDV 2nd source coverage--0628.xlsx
<br />
<br />
Sent from PA File Sight on TPEISMS01
TPEISMS01<br />
