Mailbox Details Report

This report shows some basic details about users' mailboxes and is easily extensible to provide additional fields.

NOTE: This report requires version 3.3.11 as configured. To run on older versions of Identity Panel remove the percentage column.

{
  "Data": [
    {
      "$type": "SoftwareIDM.ReportingModule.Models.Report, SoftwareIDM.ReportingModule",
      "Id": "7e3860c6-0a5d-439d-b0fe-c844bb77f905",
      "Name": "Mailbox Details",
      "UserId": "b5b780d0-b05a-49a4-9835-8545c24a5664",
      "UserProfile": false,
      "Tags": null,
      "Roles": null,
      "CacheExpiration": "12:00:00",
      "Description": null,
      "Parameters": [],
      "DataSets": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
          "Aliases": null,
          "MapRule": "",
          "Name": "Mailbox",
          "Type": "SoftwareIDM.AzureModel.AzureRecord, SoftwareIDM.AzureModel",
          "Clauses": [
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "Silo",
              "Operation": "Eq",
              "Value": "special.Identity Silo.Office 365: Exchange"
            },
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "ObjectType",
              "Operation": "Eq",
              "Value": "\"Mailbox\""
            }
          ],
          "SubQueries": []
        }
      ],
      "ReportSets": [],
      "Relations": [],
      "FieldProjections": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Account",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "$\"{WebHost()}|{DN}\""
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "DisplayName",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "Attributes.DisplayName"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Mail",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "Attributes.UserPrincipalName"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Total Item Size",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "Attributes.Total Item Size"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Issue Warning Quota",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "Attributes.Issue Warning Quota"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Archive Quota",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "Attributes.Archive Quota"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Percent Used",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "CoerceLong(MultiplyDouble(DivideDouble(Join(\"\", RegexMatch(Attributes.Total Item Size, \"\\d+\", 0, true)), Join(\"\", RegexMatch(Attributes.Issue Warning Quota, \"\\d+\", 0, true))), 100)) + \"%\""
        }
      ],
      "Transformations": [],
      "Styles": [],
      "Sort": {
        "Field": "EmployeeID",
        "Direction": "Descending"
      }
    }
  ],
  "Count": 1
}