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 }
Comments
0 comments
Please sign in to leave a comment.