Proxy Address Collisions Report

In email environments, it is vital to know when there are more than one user with the same SMTP address.

The proxyAddressCollisionsReport finds users with colliding proxy address values in an Active Directory (AD) or Azure AD silo.

On installation to your target Identity Panel implementation, be sure to update the report parameters with the names of the AD/AAD silo(s) to match your configuration:

It does not depend on a Z-System report.

{
  "Data": [
    {
      "$type": "SoftwareIDM.ReportingModule.Models.Report, SoftwareIDM.ReportingModule",
      "Id": "4722855f-1d09-41c5-b6d5-37cc1b0b5b04",
      "Name": "AD - Proxy Address Collisions",
      "UserId": null,
      "UserProfile": false,
      "Tags": null,
      "Roles": null,
      "CacheExpiration": "12:00:00",
      "Description": "Finds users with colliding proxy address values in Active Directory. Does not depend on a Z-System report.",
      "Parameters": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.SelectReportParameter, SoftwareIDM.ReportingModule",
          "ValueChoices": [
            "AD",
            "Azure"
          ],
          "Name": "Silo",
          "Description": "Select an AD silo to query",
          "Required": true,
          "Validation": "",
          "DefaultValue": ""
        }
      ],
      "DataSets": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
          "Clauses": [
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "Silo",
              "Operation": "Eq",
              "Value": "Eval(\"special.Identity Silo.\" + Memo(\"Silo\"))",
              "ObjectValue": null
            },
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "Attribute",
              "Operation": "Eq",
              "Value": "\"proxyAddresses\"",
              "ObjectValue": null
            },
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "Deleted",
              "Operation": "Null",
              "Value": "",
              "ObjectValue": null
            }
          ],
          "SubQueries": [],
          "MapRule": "",
          "MemoRules": [],
          "Aliases": null,
          "Name": "Proxy",
          "Type": "SoftwareIDM.PanelModel.Models.MultiAttr, SoftwareIDM.PanelModel",
          "Include": null,
          "Limit": null
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
          "Clauses": [
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "Silo",
              "Operation": "Eq",
              "Value": "Eval(\"special.Identity Silo.\" + Memo(\"Silo\"))",
              "ObjectValue": null
            },
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "ObjectType",
              "Operation": "Eq",
              "Value": "\"user\"",
              "ObjectValue": null
            },
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "Deleted",
              "Operation": "Null",
              "Value": "",
              "ObjectValue": null
            }
          ],
          "SubQueries": [],
          "MapRule": "",
          "MemoRules": [],
          "Aliases": null,
          "Name": "User",
          "Type": "SoftwareIDM.PanelModel.Models.ObjectRecord, SoftwareIDM.PanelModel",
          "Include": [
            "Attributes.DN",
            "Attributes.userPrincipalName",
            "Attributes.sAMAccountName",
            "Attributes.employeeId",
            "Attributes.mail"
          ],
          "Limit": null
        }
      ],
      "ReportSets": [],
      "Relations": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Relation, SoftwareIDM.ReportingModule",
          "Name": "Proxy - User",
          "LeftSet": "Proxy",
          "RightSet": "User",
          "LeftRule": "ObjectId",
          "RightRule": "Id",
          "AllowLeftOuter": false,
          "AllowRightOuter": false
        }
      ],
      "FieldProjections": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "proxyAddress",
          "RelationName": "Proxy - User",
          "RelationSide": "Left",
          "ValueRule": "Value"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "DN",
          "RelationName": "Proxy - User",
          "RelationSide": "Right",
          "ValueRule": "DN"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "userPrincipalName",
          "RelationName": "Proxy - User",
          "RelationSide": "Right",
          "ValueRule": "Attributes.userPrincipalName"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "sAMAccountName",
          "RelationName": "Proxy - User",
          "RelationSide": "Right",
          "ValueRule": "Attributes.sAMAccountName"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "employeeID",
          "RelationName": "Proxy - User",
          "RelationSide": "Right",
          "ValueRule": "Attributes.employeeID"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "mail",
          "RelationName": "Proxy - User",
          "RelationSide": "Right",
          "ValueRule": "Attributes.mail"
        }
      ],
      "Transformations": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Transform, SoftwareIDM.ReportingModule",
          "FilterRule": "",
          "GroupingRule": "LowerCase(proxyAddress)",
          "TransformRules": [
            {
              "$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
              "Field": "proxyAddress",
              "Name": "",
              "Operator": "Map",
              "TransformRule": "Map(Rows, Data.proxyAddress)"
            },
            {
              "$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
              "Field": "DN",
              "Name": "Number",
              "Operator": "Count",
              "TransformRule": ""
            },
            {
              "$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
              "Field": "DN",
              "Name": "",
              "Operator": "Any",
              "TransformRule": "Map(Rows, FirstNotNull(Data.DN, \"N/A\"))"
            },
            {
              "$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
              "Field": "userPrincipalName",
              "Name": "",
              "Operator": "Map",
              "TransformRule": "Map(Rows, FirstNotNull(Data.userPrincipalName, \"N/A\"))"
            },
            {
              "$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
              "Field": "sAMAccountName",
              "Name": "",
              "Operator": "Map",
              "TransformRule": "Map(Rows, FirstNotNull(Data.sAMAccountName, \"N/A\"))"
            },
            {
              "$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
              "Field": "employeeID",
              "Name": "",
              "Operator": "Map",
              "TransformRule": "Distinct(Rows, FirstNotNull(Data.employeeID, \"N/A\"))"
            },
            {
              "$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
              "Field": "mail",
              "Name": "",
              "Operator": "Map",
              "TransformRule": "Map(Rows, FirstNotNull(Data.mail, \"N/A\"))"
            }
          ]
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Transform, SoftwareIDM.ReportingModule",
          "FilterRule": "Data.Number > 1",
          "GroupingRule": "",
          "TransformRules": []
        }
      ],
      "Styles": [],
      "Sort": {
        "Field": "",
        "Direction": "Ascending"
      }
    }
  ],
  "Count": 1
}