helpdesk - PG91 Useful queries : Ideas forum

New Suggested 2/16/2023 by Rishikesh Somshetti

3

votes

Dear Team,

You can use following simple queries to get data from PG91

Daywise Summary for Specific SASL for Specific Month.
Please use following query on PG91 and you will see number of mails sent by specific SASL daywise for Feb 2023.

select ts_msgsasl, ts_distcol, count(*) as msgTotal from trafficsummary where ts_distcol >= '2023-02-01 00:00:00' and ts_distcol < '2023-03-01 00:00:00' and ts_msgsasl = '[email protected]' group by ts_msgsasl, ts_distcol order by ts_distcol desc;
Monthwise TrafficSummary Report for Specific SASL for Specific Month.
Use following query to extract Feb 2023 data for Rikhav. You can use same query and change SASL for other customers.. select ts_msgto, ts_msgsubject, ts_msgaction from trafficsummary where ts_distcol >= '2023-02-01 00:00:00' and ts_distcol < '2023-03-01 00:00:00' and ts_msgsasl = '[email protected]' order by ts_distcol desc;

pg91