AD Unique Value Collisions Report

This report may be customized to show value collisions for any single-valued attribute in any silo. The sample report shows a single silo called AD, and offers a choice of several attributes, including mail, employeeID, and cn.

NOTE: As provided, this report requires version 3.3.11 or higher of Identity Panel. This is because the report takes advantage of the new list display feature for improved formatting. If using an older version it will be necessary to revise the field pass thru on the second transformation (the one with the group-by rule). For example, instead of:

Map(Rows, DN)

Do:

Join(", ", Map(Rows, DN))

As configured the report uses the AD Users Base report. To report off of a different silo a Query Data set must be created which pulls in ObjectRecords. The report fields must then be adjusted to project:

Attributes.<fieldname>

Another optional customization is to make the Silo selectable. This may be done by creating a select box report parameter, and adding values in the form:

[special.Identity Silo.MIM: AD], [special.Identity Silo.MIM: LDS]

The Silo parameter would then be referenced with the memo function in the query dataset.

{
  "Data": [
    {
      "$type": "SoftwareIDM.ReportingModule.Models.Report, SoftwareIDM.ReportingModule",
      "Id": "afa0407a-17bc-43e1-9a6d-bbd6e73cce13",
      "Name": "AD Unique Value Collisions",
      "UserId": null,
      "UserProfile": false,
      "Tags": null,
      "Roles": null,
      "CacheExpiration": "12:00:00",
      "Description": "",
      "Parameters": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.SelectReportParameter, SoftwareIDM.ReportingModule",
          "ValueChoices": [
            "employeeID",
            "mail",
            "cn"
          ],
          "Name": "Attribute",
          "Description": "Attribute to check for uniqueness",
          "Required": true,
          "Validation": "",
          "DefaultValue": ""
        }
      ],
      "DataSets": [],
      "ReportSets": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.ReportData, SoftwareIDM.ReportingModule",
          "Name": "AD",
          "Report": "cb5036bf-5ee6-43b0-b6ee-9fba04c3ea3b"
        }
      ],
      "Relations": [],
      "FieldProjections": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "DN",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "$\"{TimeTraveler(Id)}|{DN}\""
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "DisplayName",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "displayName"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "AccountName",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "sAMAccountName"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "employeeID",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "employeeID"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "mail",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "mail"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "cn",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "ParseCN(DN)"
        }
      ],
      "Transformations": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Transform, SoftwareIDM.ReportingModule",
          "FilterRule": "Key(Data, Memo(\"Attribute\")) != null",
          "GroupingRule": "",
          "TransformRules": []
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Transform, SoftwareIDM.ReportingModule",
          "FilterRule": "",
          "GroupingRule": "Key(Data, Memo(\"Attribute\"))",
          "TransformRules": [
            {
              "$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
              "Field": "DisplayName",
              "Name": "Collision",
              "Operator": "Any",
              "TransformRule": "Key(Data, Memo(\"Attribute\"))"
            },
            {
              "$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
              "Field": "DN",
              "Name": "",
              "Operator": "Map",
              "TransformRule": "Map(Rows, DN)"
            },
            {
              "$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
              "Field": "DisplayName",
              "Name": "",
              "Operator": "Map",
              "TransformRule": "Distinct(Rows, DisplayName)"
            },
            {
              "$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
              "Field": "AccountName",
              "Name": "",
              "Operator": "Map",
              "TransformRule": "Distinct(Rows, AccountName)"
            },
            {
              "$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
              "Field": "DN",
              "Name": "Number",
              "Operator": "Count",
              "TransformRule": ""
            }
          ]
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Transform, SoftwareIDM.ReportingModule",
          "FilterRule": "Data.Number > 1",
          "GroupingRule": "",
          "TransformRules": []
        }
      ],
      "Styles": [],
      "Sort": {
        "Field": "",
        "Direction": "Ascending"
      }
    }
  ],
  "Count": 1
}