How to using SQL status to search the alert mail's content

Dennis_Lee 26
Viewed 0

V7.1.2.67

my question is: How to using SQL status to search the alert mail's content?

The alert mail content sample:

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.
Read files include:
P:\Public\Logistics\Sourcing\EE\2nd Source Tracking\A39\A39 Asahi 15 PCE action format.xls
P:\Public\Logistics\Sourcing\EE\2nd Source Tracking\A39\A39 Asahi ZIUS1 EE EVT BOM LIST and action 2014-03-28.xlsx
P:\Public\Logistics\Sourcing\EE\2nd Source Tracking\A39\action\A39 AIVS1 Storm EE BOM List v0116.xlsx
P:\Public\Logistics\Sourcing\EE\2nd Source Tracking\A39\action\A39 LIN_Storm_Ella2_0304_EE.xlsx
P:\Public\Logistics\Sourcing\EE\2nd Source Tracking\A39\action\AIVS1.xlsx
P:\Public\Logistics\Sourcing\EE\2nd Source Tracking\A39\action\LIN_New Action Table.xlsx
P:\Public\Logistics\Sourcing\EE\2nd Source Tracking\A39\AILL1_AILL2 2nd source.xlsx
P:\Public\Logistics\Sourcing\EE\2nd Source Tracking\A39\Merlyn2 0 SDV 2nd source coverage--0628.xlsx

Sent from PA File Sight on TPEISMS01

statement sql

typing error. How to using SQL statement to search the alert mail's content?

Dennis_Lee•
1 Answers

Hi Dennis_Lee,

I'm not sure why you need to run SQL code to search emails. If you want to get the information about a users activities in PA File Sight you should run a Custom Data Set report to the get the information you are looking for.

Thanks
Quinn

Please make sure to mark your questions accepted when you have your answer by clicking the gray check mark to the left of the answer.

Quinn2713
Related