Install the attached report (JSON) to return records from the Identity Panel Graph based on a valid rule expression.
The report uses a single Graph Data Set, and the supplied rule expression is processed by the Eval() function.
When built, the report returns any matching graphs, displaying them in a generic set of columns (constructed from the root silo, generally defaulting to the Projected SIlo) to assist discovery and troubleshooting activity:
- Name - a link to the object in Service Panel
- ObjectType - identity object type (person, group, etc.)
- Admin Link - a link to the object in Time Traveler
- projectedId - the Id of the Projected Silo
- graph - a sorted list of graph nodes displayed as Time Traveler links, including the Created Date
- joinValues - a sorted list of join values for each graph node
As with any report, the output can be downloaded into various formats (most commonly Excel) in accordance with requirements.
The following is an example of a search for an error condition whereby multiple silos of the same name have been (generally incorrectly joined to the same graph (scenario #1 in the table below).
Report Dependencies
The report has dependencies on several Custom Rule Function definitions.
Add at least #2 and #3 to your implementation before building this report.
| # | Name | Description | Rule Expression |
|---|---|---|---|
| 1 | HistoryLink(objectId, displayName) | Construct the History URL for the specified object | If(
objectId,
$"https:/{null}/{IdentityPanelHost(true)}/history#!limit=20&skip=0&id={objectId}|{displayName}",
displayName
) |
| 2 | ServicePanelLink(objectId, displayName) | Construct the Service Panel URL for the specified object | If(
objectId,
$"https:/{null}/{ServicePanelHost(true)}/detail/{objectId}|{displayName}",
displayName
) |
| 3 | GetSiloDetails(siloNode) | Concatenate relevant details for silo context | Switch(
And(
ContainsNoCase("person", siloNode.ObjectType),
ContainsNoCase("|Projected|Hyperverse|",
siloNode.SiloName)),
$"{siloNode.SiloName} : {siloNode.DN} ({siloNode.ObjectType}, {siloNode.sourceId}, {siloNode.employeeType}, {siloNode.employeeStatus})",
And(ContainsNoCase("user", siloNode.ObjectType),
ContainsNoCase("|AD|",
siloNode.SiloName)),
$"{siloNode.SiloName} : {siloNode.DN} ({siloNode.ObjectType}, {siloNode.sAMAccountName}, {siloNode.mail}, {ADFlags(siloNode.userAccountControl)})",
And(
ContainsNoCase("group", siloNode.ObjectType),
ContainsNoCase("|AD|", siloNode.SiloName)),
$"{siloNode.SiloName} : {siloNode.DN} ({siloNode.ObjectType}, {siloNode.sAMAccountName}, {siloNode.mail})",
$"{siloNode.SiloName} : {siloNode.DN} ({siloNode.ObjectType})"
) |
Usage Scenarios
The following table lists some common usage scenarios.
Copy the example expression into the Query parameter of the report (multi-lines will be collapsed but still work).
| # | Description | Use Case | Example Rule Expression(s) |
|---|---|---|---|
| 1 | Find duplicate silos for the same graph | Resolving integrity issues caused by bad join values | And( EqualNoCase(ObjectType, "person"), AD.Count > 1 ) |
| 2 | Find duplicate silos for the same graph | Resolving integrity issues caused by bad join values created in the last day | And( EqualNoCase(ObjectType, "person"), AD.Count > 1, AD.Created > Ago(Days(1)) ) |
| 3 | Find duplicate silos for the same graph | Resolving integrity issues caused by bad join values across multiple silos | And(
ObjectType == "person",
Or(
AD.Count > 1,
HR.Count > 1,
ADLDS.Count > 1
)
) |
| 4 | Find attributes with data | Discover the extent to which a given attribute has a value in the graph | And( EqualNoCase(ObjectType, "person"), HV, HV.mobilePhone ) |
| 5 | Find criteria groups with large numbers of explicit members | Discover the extent to which a group filter would need adjusting to accommodate all required members | And( EqualNoCase(ObjectType, "group"), IDAM.filter, IDAM.manuallyManagedMembers.Count > 100 ) |
| 6 | Find unmapped group owners | Discover group ownership still visible in Time Traveler but not migrated to Identity Panel before MIM silos were removed from the graph | And(
EqualNoCase(ObjectType, "group"),
Not(IDAM.owners),
MIM: Portal,
First(
ResolveMultis(
MIM: Portal.Id,
special.Identity Silo.MIM: Portal,
"owner",
false
)
)
) |
| 7 | Find invalid HyperSync attribute values | Discover identity data in the Hyperverse of the incorrect data type | And(
EqualNoCase(ObjectType, "person"),
HV,
HV.manager,
Not(
EqualNoCase(
TypeName(HV.manager),
"GraphRef"
)
)
) |
Comments
0 comments
Please sign in to leave a comment.