Child pages
  • Reconciliation reports
Skip to end of metadata
Go to start of metadata

This note explains how to get some statistics from the reconciliation process.

Configuration

Reconciliation mapping

In a mapping definition (from sync.json or scheduler-xxxxx.json file) you need to define a "result" script. This script is called by the reconciliation process at the end of the reconciliation.

"mapping" : {
            "name" : "HRDB_Org_OpenDJ_Org",
            "source" : "system/HRDB/organization",
            "target" : "system/OpenDJ/organizationalUnit",
            "result" : {
                "type" : "text/javascript",
                "file" : "/opt/openidm/jscript/reconStats.js"
            },           
            "policies" : [ {
                           "situation" : "UNQUALIFIED",
                           "action" : "IGNORE"
                         } ],
            "properties" : [
                {
                "source" : "name",
                "target" : "ou"
                },
                {
                "source" : "name",
                "target" : "__NAME__",               
                "transform" : {
                    "type" : "text/javascript",
                    "source" : "'ou='+source+',dc=example,dc=com'"
                     }           
                },
                {               
                "source" : "description",
                "target" : "description"
                } ]       
}

Example

javascript

The attached script builts an HTML report of the reconciliation process and leverages the OpenIDM external email service to send it to the relevant persons.

Download reconStats.js

HTML report from the script

Global Statistics

Mapping Name: HRDB_Org_OpenDJ_Org
Recon Id: 5eb12a07-b850-4456-a53c-1c537988c33b
Start Time: 11/3/11 2:31 PM
End Time: 11/3/11 2:31 PM

Source System Statistics

System Name: system/HRDB/organization
Start Time: 11/3/11 2:31 PM
End Time: 11/3/11 2:31 PM
Duration: 0.016 minutes
Entry List Query duration: 0.05 seconds

SITUATIONS
  • CONFIRMED: 5
  • MISSING: 0
  • FOUND: 0
  • ABSENT: 0
  • UNQUALIFIED: 0
  • UNASSIGNED: 0
Target System Statistics

System Name: system/OpenDJ/organizationalUnit
Start Time: 11/3/11 2:31 PM
End Time: 11/3/11 2:31 PM
Duration: 0.0019 minutes
Entry List Query duration: 0.016 seconds

SITUATIONS
  • CONFIRMED: 0
  • MISSING: 0
  • FOUND: 0
  • ABSENT: 0
  • UNQUALIFIED: 1
  • UNASSIGNED: 0
    Detailed Source Statistics

Confirmed ids:
HR
SALES
SUPPORT
ENG
TEST1


Detailed Target Statistics

Unqualified ids:
4d84a521-ab93-3592-9b74-c15a70582351

2 Comments

  1. This page looks outdated and using it doesn't work for OpenIDM 2.1, lots of the fields remain empty/undefined, as show below:

    Global Statistics

    Mapping Name:undefined
    Recon Id:82e39d93-fe1b-4419-af5b-2546bb4115f4
    Start Time:2013-11-26T13:58:51.384Z
    End Time:

    Source System Statistics

    System Name:undefined
    Start Time:undefined
    End Time:undefined
    Duration:NaN minutes
    Entries:undefined read
    Entry List Query duration:NaN seconds

    SITUATIONS

    • CONFIRMED: 12
    • ABSENT: 0 (target does not exist)
    • FOUND: 0 (target not linked)
    • MISSING: 0 (target deleted)
    • UNQUALIFIED: 0 (ignored entries)
    • SOURCE_IGNORED: 0 (ignored entries)




    Target System Statistics

    System Name:undefined
    Start Time:undefined
    End Time:undefined
    Duration:NaN minutes
    Entries:undefined read
    Entry List Query duration:NaN seconds

    SITUATIONS

    • UNASSIGNED: 0 (orphan accounts)
    • SOURCE_MISSING: 0 (source deleted)
    • TARGET_IGNORED: 0 (ignored entries)  
    1. Thanks, cgrosjean.  OPENIDM-2170 is in progress now to fix this.