BCC Domino Analyser

The Challenge

The management and analysis of email and application data within HCL Domino environments pose significant challenges. Organizations struggle with oversized and ageing databases that affect system performance and compliance. The inability to effectively analyze and understand this data complicates strategic IT decisions, including crucial migrations and upgrades. Furthermore, the ever-growing demands of GDPR compliance add layers of complexity in managing sensitive information securely without compromising on data utility. 
 

Introducing the Solution: BCC Analyzer for Domino 

How Does It Work? 

These steps are performed when analysing your Domino environment.

1) Data Collection

• As a server extension, BCC Analyser automatically scans all documents within Domino Mail files and Applications.
• It collects comprehensive metadata from each document, which is crucial for detailed analysis.

2) Data Storage

• The collected data is systematically stored in an SQL database, compatible with both MS SQL and SQLite formats.
• For each document in the database, the following information is recorded:
  • Form name used.
  • Creation and modification dates.
  • State of "soft delete" indicating whether the document was temporarily removed.
  • Document size in bytes.
  • Encryption status of the document.
  • A unique identifier for each document.

 3) Attachment Details

• Detailed metadata for each attachment in the documents is also collected, including:
  • Parent document ID.
  • Attachment type (e.g., PDF, MP4, DOCX).
  • Attachment size in bytes. 
    

4) Optional Data Collection

• If enabled, additional "Names" fields such as sender email, recipient email, and cc addresses are collected in a separate table, providing even more layers of data. 

5) Data Analysis and Reporting

• Domino formulas can be evaluated for each document, and the outcomes are stored within the database.
• This data is then ready to be analyzed using SQL reporting tools or visualized through business intelligence platforms like PowerBI.
• The system supports automated FTP transfer of the database to other servers for centralized management or backup purposes. 

 6) Compliance and Security: 

• To meet GDPR requirements, BCC Analyzer can anonymize sensitive information like database names and recipient details while still retaining crucial sizing and age data for compliance reports.  

Outcome

Using BCC Analyser, all collected data is structured and stored efficiently, making it readily accessible for in-depth analysis and reporting. This streamlined workflow enables organizations to convert raw data from Domino environments into actionable insights, driving better decisions for system optimizations, migrations, and compliance strategies.