Forum Discussion

CSathiya's avatar
CSathiya
Level 3
11 years ago

Report

We are working on creating a custom report that will help us determine the following per Employee in a Department in Compliance Accelerator. 1) Total Number of Lexicon Items Flagged 2) Total Numb...
Compliance Accelerator
Information Governance
Reporting
Windows Server (2003-2008)
  • Kenneth_Adams's avatar
    Kenneth_Adams
    11 years ago
    Table tblPrincipal contains the PrincipalName - which is the Display Name - of each Monitored Employee. Each Monitored Employee has an AddressOwnerID in that table that relates to the employee's SMTP address or addresses in the tblAddress table. The Display Name or SMTP address(es) for each Monitored Employee can be used to look in the tblIntDiscoveredItems table's Author or Recipient columns to locate messages to or from each Monitored Employee. Does that help?
Kenneth_Adams's avatar
Kenneth_Adams
Level 6
11 years ago
Table tblPrincipal contains the PrincipalName - which is the Display Name - of each Monitored Employee. Each Monitored Employee has an AddressOwnerID in that table that relates to the employee's SMTP address or addresses in the tblAddress table. The Display Name or SMTP address(es) for each Monitored Employee can be used to look in the tblIntDiscoveredItems table's Author or Recipient columns to locate messages to or from each Monitored Employee. Does that help?