Data Loss Prevention

The question is for the Mail Monirtor instance.

I am trying to programatially extract the Messages and Incidents count from the Database. I was able to get the incidents count by using combination of incident and message tables.

The question is how we'd get the count of all email messages scanned by a particular monitor, as shown on the System -> Overview screen as Messages (Today)?

Is this statisctic stored someplace in the oracle?

Thank you!

Alex

Hello,

You could use the Reporting API to run a report that would give you incidents by server, and then in your script that calls the API, you could count the incidents in the report. Or, you could query the database directly. However, we don't publish the schema as we consider it Intellectual Property. You might be able to find the tables in the DB that correlate to the information you are looking for, but you would need to find those on your own. If you really need a SQL solution for this, you would need to contact Professional Services to assist you.

What is the end goal of your program/script for collecting this information? Perhaps there is another way to get your answer?

I hope this helps.
Best,

Ryan

Hy Ryan,

Thanks for the reply.

I am looking for the total messages, not incdents processed by the system in a given time. In this case it would be email messages. The goal is compare this number with the number of outbound emails sent by perimiter MTAs we are monitroing. 

I do not think the API exposes this information.

Thanks,

Alex