ARKES Reports Primer


ARKES reports about various objects in Microsoft Exchange architecture such as organization, administrative group, routing group, servers, connectors, protocols, information stores and recipients. ARKES provides several out-of-the-box reports about Exchange Server objects' configuration, security and usage. The information about the organization’s administrative groups, routing groups, storage groups, mailbox stores, public folder stores, system & recipient policies, protocols settings and various connectors, mailbox users, mail-enabled users and distribution groups/lists are available across all Exchange Servers in the Exchange Organization.
 

ARKES provides the following major reporting features to address different users' reporting requirements - Built-in Reports, Power Reports, and Traffic Reports.
 

Built-in Reports: Presents a set of pre-canned reports classified based on Exchange objects for each viewing,exporting and e-mail.

Power Reports: Powerful tool to generate multiple reports at periodic intervals in a single task. Create a scheduled task to export multiple reports from ARKES to MS-Excel (XLSX), HTML and Comma Separated Values (CSV) file formats. Power Reports internally uses the familiar Windows task scheduler for generating reports at different time intervals - daily, monthly, weekly etc. Export multiple reports in four simple steps:

  1. Select Directory Server to generate the reports on
  2. Select the Reports
  3. Specify Scope and Delivery Options and
  4. Schedule the Export Task.

Traffic Reports is an Exchange Server Message Tracking Log Management and Reporting solution that address all types of mail transaction details, and reporting the Exchange Mail transaction information and mail status details. Our Solution allows you to track and import from Exchange Message Tracking Log data to application database and reports several types of mail transaction in your Exchange Server.
 

Traffic Reports provides the following major reporting features to address different users' reporting requirements - Data Collector, Mail Traffic Reports, Mail Traffic Statistics and Scheduled Reports.


Data Collector

Collect Now : Provides the facility to import data from Exchange Server Message Tracking Transport Log to the Application database based on Exchange mail transaction.

Please refer to the section Collect Now  for more information.

 

Collect at Scheduled intervals : Provides the facility to import data from Exchange Server Message Tracking Transport Log to the Application database, at scheduled intervals, which is recommended for regular automatic data Collection and importing to the Application database.

Please refer to the section Collect at Scheduled intervals  for more information.


Data Collection History: Presents data collection details from the time you started using this application. Data Collection History maintains the Data Collector details separately for each Exchange Server. 

Please refer to the section Data Collection History  for more information.


Mail Traffic Reports: Provides all mail transaction reports and status reports based on Exchange mail transaction for viewing, exporting and e-mailing the reports.

Please refer to the section Mail Traffic for more information.


Mail Traffic Statistics: Provides various text and graphical (chart) reports based on the e-mail transaction information. This info include number of e-mails sent, e-mail size, number of senders, number of recipients, subject, etc.

Please refer to the section Mail Traffic Statistics for more information.

Scheduled Reports: All Traffic Reports operations can be easily automated, scheduled and published to various destinations in different formats.

Please refer to the section Scheduled Reports for more information.


ARKES reports configuration information of all directory objects (Policy, Mailbox and Public Folder Store, Mailbox, Distribution Group, Contact, Public Folder, etc) under the respective objects in the Built-in Reports structure.
 

ARKES Built-in Reports
 

ARKES Built-in Reports features reports about the following Exchange objects:

  1. Policy

  2. Storage Group

  3. Server

  4. Mailbox and Public Folder Store 

  5. Mailbox 

  6. Distribution Group 

  7. Contact 

  8. Public Folder.

  9. Mail Item.

Please refer to the section Built-in Reports for more information.
 

Permissions required to generate Built-in Reports in ARKES
 
The currently logged-on user or the user-credentials entered for Exchange Server login should have:
 
  • Exchange View Only Administrator role in the Exchange Organization
  • For Security reports:

    • 'Exchange Administrator' role in the Organization container/respective object
  • To include Hidden recipient in any report - Connect using "Specify user account" option with Exchange Server admin credentials

ARKES reports about Mailbox and Public Folder resources (including Size, Number of mail items, Storage limits, Mailbox Folder Activity, Client Permissions, etc) as part of Recipient Reports. The following reports about mailbox and public folder resources have additional requirements to generate the reports:
 

  1. Mailboxes - Size
  2. Mailbox - First activity and last activity
  3. Mailbox Default Folder Security Report
  4. Mailbox Folders Properties
  5. Mailbox Attachments Summary
  6. Mailboxes exceeding quota limits
  7. Public Folders Size
  8. Public Folder Client Permissions
  9. Mailbox Store Resource Utilization
  10. Public Folder Store Resource Utilization

The above mentioned reports use a combination of user credentials to deliver the reports containing directory configuration information such as Alias Name, First Name, Last Name, E-mail Address, etc and Information Store (Mailbox & Public Folder Store) information such as Size, Total Number of Items, etc. For these specific set of reports, the 'specified credential during Connect' will be used to retrieve Directory Service information and 'currently logged on user' will be used to retrieve Information Store information. These reports additionally require a Mailbox Profile or (Exchange Servername, Impersonated Mailbox Username and Password) to retrieve the Information Store information.
 

In order to run the mailbox and public folder resource reports successfully, the user credential, mailbox profile and exchange server credentials should meet the following requirements, over and above the permission requirements stated before:
 

  1. The mailbox profile used to generate the reports must be created in the user context in which the application is to run. In other words, the currently logged on user context should be able to use that mailbox profile and launch Microsoft Outlook or any other MAPI client application to view the mailboxes' contents.

  2. Currently logged on user has must have 'Full mailbox access' right for the mailbox associated with the given profile for Exchange Server.

  3. The user account that you specify in the mailbox profile should have Admin permissions in the Mailbox / Public Folder Store object in Exchange Server.

  4. The user context in which ARKES application is run should have Admin permissions in the Mailbox / Public Folder Store object in Exchange Server.

  5. The Exchange Server credentials used to generate the reports must be least any one member of  the following groups.

  • For Exchange Server 2013

    • Organization Management( Microsoft Exchange Security Groups)
    • Hygiene Management (Microsoft Exchange Security Groups)
    • Recipient Management (Microsoft Exchange Security Groups)
    • Records Management (Microsoft Exchange Security Groups)
    • View-Only Organization Management (Microsoft Exchange Security Groups)
  • For Exchange Server 2010

    • Organization Management( Microsoft Exchange Security Groups)
    • Hygiene Management (Microsoft Exchange Security Groups)
    • Recipient Management (Microsoft Exchange Security Groups)
    • Records Management (Microsoft Exchange Security Groups)
    • View-Only Organization Management (Microsoft Exchange Security Groups)
  • For Exchange Server 2003

    • Domain Administrators (Designated administrators of the domain)
    Read more info about,

    Configuring mailbox rights and public folder permissions

ARKES reports about Mail Item(Read, Unread, Deleted, High Importance, Normal Importance, Low Importance and Junk Mails.). The following reports about mail item have additional requirements to generate the reports:

  • The Exchange Server credentials used to generate the reports must have impersonation permission.

    Read more info about,

    Configuring impersonation rights to a mailbox user

Apart from the above, other basic checks include:
 

  • Information Store service is started
  • Mailbox/Public Folder Store is mounted

Hence, in order to generate the mailbox and public folder resource reports successfully, login as any user say 'DOMAIN \ USER NAME', create a mailbox profile using that account and enter the exchange server credentials and run ARKES by specifying the relevant profile and generate the reports.
 

If you have any restrictions in logging in with a different user account to generate these reports, you can use the Power Reports feature in ARKES to create multiple scheduled tasks and have it to run under corresponding user contexts. Using the Power Reports you can create a scheduled task and specify the user account in 'Run As' parameter of scheduled task to generate the reports for the selected Directory Server.


Permissions required for Data Collector in ARKES - Traffic Reports

The currently logged-on user, or the user-credentials entered for the Exchange Server login should have:
The user at least any one member of  the following groups for collect the data in ARKES - Traffic Reports
  • For Exchange Server 2013

    • Organization Management( Microsoft Exchange Security Groups)
    • Hygiene Management (Microsoft Exchange Security Groups)
    • Recipient Management (Microsoft Exchange Security Groups)
    • Records Management (Microsoft Exchange Security Groups)
    • View-Only Organization Management (Microsoft Exchange Security Groups)
  • For Exchange Server 2010

    • Organization Management( Microsoft Exchange Security Groups)
    • Hygiene Management (Microsoft Exchange Security Groups)
    • Recipient Management (Microsoft Exchange Security Groups)
    • Records Management (Microsoft Exchange Security Groups)
    • View-Only Organization Management (Microsoft Exchange Security Groups)
  • For Exchange Server 2007

    • Exchange Organization Administrators
    • Exchange Public Folder Administrators
    • Exchange Recipient Administrators
    • Exchange View-Only Administrators
  • For Exchange Server 2003

    • Domain Administrators (Designated administrators of the domain)
Important: The client computer should have installed the Exchange Server 2007 Management Tool, and it should be the member of the same domain as the Exchange Server 2007, or a trusted domain, for to collect the data from the Exchange Server 2007. Without installing the Exchange 2007 Management tool, and Exchange 2007 credentials, it cannot collect data from the Exchange Server 2007 by using the other computers.

Mail Traffic Reports 

Mail Traffic Reports features reports the following types of mail transactions:

  1. All mail transactions
  2. DELIVER Mail Report
  3. DEFER Mail Report
  4. DSN Mail Report
  5. DUPLICATEDELIVER Mail Report
  6. EXPAND Mail Report
  7. FAIL Mail Report
  8. POISONMESSAGE Mail Report
  9. RECEIVE Mail Report
  10. REDIRECT Mail Report
  11. RESOLVE Mail Report
  12. SEND Mail Report
  13. SUBMIT Mail Report
  14. TRANSFER Mail Report

Please refer to the section Mail Traffic Reports for more information.
 

Mail Traffic Statistics

Mail Traffic Statistics feature reports the following E-Mail Traffic Reports and Exchange Server Mail Traffic Statistics reports:

  1. Top Senders by Mail Count
  2. Top Senders by Mail Size
  3. Top Senders by Recipient Count
  4. Top Senders to Groups by Mail Count
  5. Top Senders to Groups by Mail Size
  6. Top Recipients by Mail Count
  7. Top Recipients by Mail Size
  8. Top Groups by Received Mail Count
  9. Top Groups by Received Mail Size
  10. Mail Count by Client IP
  11. Mail Count by Server Host Name
  12. Mail Count by Subject
  13. Mail Count by Size Range
  14. Mail Count by Custom Size Range
  15. Mail Size by Client IP
  16. Mail Size by Subject
  17. Recipient Sent and Received Mail Count

Please refer to the section Mail Traffic Statistics for more information.
 

ARKES Export, E-mail
 

ARKES allows users to export and e-mail the reports from its various features.
 

ARKES facilitates export / e-mail of available reports in MS-Excel (XLSX), HTML and Comma Separated Values (CSV) file formats.

Using Export feature, the generated reports can be saved in the respective file formats in the default export folder ('Export' folder in the application data path of ARKES). The export folder can be modified to a local folder or remote shared folder as desired.
 

Using E-mail feature, the generated reports can be e-mailed in the respective file formats to different mail-enabled recipient objects in the organization.
 

See Also
Configuring mailbox rights and public folder permissions