Duplicate Joins Report

In large and complex identity environments, it is important to be able to proactively enforce identity uniqueness to avoid ambiguity when it comes to keeping identities synchronized across multiple systems.  Where conflicts invariably do go undetected and result in ambiguous joins, it is important to identify them in a timely way to avoid loss of access and/or security violations.

The duplicateJoinsReport finds users with ambiguous joins in HyperSync.  Unlike the Review Join Data Report, these are user records for which there are multiple users from the same directory attempting to be joined to the same Hyperverse record.

{
  "Data": [
    {
      "$type": "SoftwareIDM.ReportingModule.Models.Report, SoftwareIDM.ReportingModule",
      "Id": "651f8cb6-70bf-4f32-8fb6-10d5ace8e8ce",
      "Name": "Duplicate Joins",
      "UserId": null,
      "UserProfile": false,
      "Tags": null,
      "Roles": null,
      "CacheExpiration": "01:00:00",
      "Description": "The duplicateJoinsReport finds users with ambiguous joins in HyperSync.",
      "Parameters": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.SelectReportParameter, SoftwareIDM.ReportingModule",
          "ValueChoices": [
            "",
            "",
            ""
          ],
          "Name": "Silo",
          "Description": "",
          "Required": true,
          "Validation": "",
          "DefaultValue": "PSFeed"
        }
      ],
      "DataSets": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
          "Clauses": [
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "Deleted",
              "Operation": "Null",
              "Value": "",
              "ObjectValue": null
            },
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "Silo",
              "Operation": "Eq",
              "Value": "Eval(\"special.Identity Silo.\" + Memo(\"Silo\"))",
              "ObjectValue": null
            }
          ],
          "SubQueries": [],
          "MapRule": "JoinValues",
          "MemoRules": [],
          "Aliases": null,
          "Name": "Silo Data",
          "Type": "SoftwareIDM.PanelModel.Models.ObjectRecord, SoftwareIDM.PanelModel",
          "Include": [
            "JoinValues",
            "DN",
            "Attributes"
          ],
          "Limit": null
        }
      ],
      "ReportSets": [],
      "Relations": [],
      "FieldProjections": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "DN",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "Parent.DN"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Join Value",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "Child"
        }
      ],
      "Transformations": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Transform, SoftwareIDM.ReportingModule",
          "FilterRule": "",
          "GroupingRule": "Data.Join Value",
          "TransformRules": [
            {
              "$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
              "Field": "DN",
              "Name": "Matches",
              "Operator": "Count",
              "TransformRule": ""
            },
            {
              "$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
              "Field": "Join Value",
              "Name": "",
              "Operator": "Any",
              "TransformRule": "Data.Join Value"
            },
            {
              "$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
              "Field": "DN",
              "Name": "",
              "Operator": "Map",
              "TransformRule": "Map(Rows, Data.DN)"
            }
          ]
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Transform, SoftwareIDM.ReportingModule",
          "FilterRule": "Data.Matches > 1",
          "GroupingRule": "",
          "TransformRules": []
        }
      ],
      "Styles": [],
      "Sort": {
        "Field": "",
        "Direction": "Ascending"
      }
    }
  ],
  "Count": 1
}